在context.xml中
<?xml version="1.0" encoding="UTF-8"?><Context antiJARLocking="true" path="/myDBname" allowCasualMultipartParsing="true" > <Realm className="org.apache.catalina.realm.CombinedRealm" > <Realm className="org.apache.catalina.realm.JDBCRealm" driverName="com.mysql.jdbc.Driver" name="myDBname" type="javax.sql.DataSource" connectionURL="jdbc:mysql://localhost:3306/mydbname" connectionName="root" connectionPassword="sasa" userTable="administrators" userNameCol="Email" userCredCol="Password" userRoleTable="administrators" roleNameCol="LoginRole" auth="Container" maxTotal="100" maxIdle="30" maxWaitMillis="10000" digest="MD5"/> <Realm className="org.apache.catalina.realm.JDBCRealm" driverName="com.mysql.jdbc.Driver" name="myDBname" type="javax.sql.DataSource" connectionURL="jdbc:mysql://localhost:3306/mydbname" connectionName="root" connectionPassword="sasa" userTable="users" userNameCol="Email" userCredCol="Password" userRoleTable="users" roleNameCol="LoginRole" auth="Container" maxTotal="100" maxIdle="30" maxWaitMillis="10000" digest="MD5"/> </Realm> </Context>
web.xml
<resource-ref> <description>DB Connection</description> <res-ref-name>myDBname</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth></resource-ref><login-config> <auth-method>FORM</auth-method> <realm-name>myDBname</realm-name> <form-login-config> <form-login-page>/pages/Login.jsp</form-login-page> <form-error-page>/pages/Error.jsp</form-error-page> </form-login-config></login-config><security-role> <description>Administrator</description> <role-name>admin</role-name></security-role><security-constraint> <web-resource-collection> <web-resource-name>myDBname</web-resource-name> <url-pattern>/pages/admin/*</url-pattern> <http-method>POST</http-method> <http-method>GET</http-method> <http-method>PUT</http-method> </web-resource-collection> <auth-constraint> <role-name>admin</role-name> </auth-constraint></security-constraint><welcome-file-list> <welcome-file>pages/home.jsp</welcome-file></welcome-file-list>
将mysql-connector-java-5.1.23-bin.jar复制到C: Program Files Apache Software
Foundation Apache Tomcat 8.0.15 lib
我还使用
<%= request.getContextPath() %>为了将资源连接到页面
<link href="<%= request.getContextPath() %>/resources/styles/main.css" rel="stylesheet" type="text/css"/>
Java代码要使用MD5哈希存储密码,请执行以下操作:
String passwordHash = org.apache.catalina.realm.Realmbase.Digest(password, "md5", "utf-8");
并将passwordHash写入数据库…



