论文部分内容阅读
用JSP编辑的网站中,一般要求用户提供登录该网站的用户名称和密码等信息,在注册页面中用SQL语句在数据库中查询该用户名和密码是否存在于数据库中,但是标准的SQL语句在复杂的数据库查询中却存在着诸多不足。而正则表达式有着强大的查询功能,通过对正则表达式特殊字符以及数据库查询语言中谓词的分析,提出了将正则表达式运用于数据库查询当中的新查询方法,降低查询语句的复杂程度而且还能简化对出错语句的修改工作。
Website edited with JSP, the user is generally required to log in to the site user name and password and other information in the registration page using SQL statements in the database query the user name and password exist in the database, but the standard SQL statements in complex There are many deficiencies in the database query. The regular expression has a powerful query function. Through the analysis of special characters in regular expressions and predicates in the database query language, a new query method using regular expression in database query is proposed, which reduces the complexity of the query and also Can simplify the modification of the error statement.