前端页面在此很简单,就是两个文本框
<form action="validate.jsp" name="login">
username<input type="text" name="username"><br/>
password<input type="password" name="password"><br/>
<input type="submit">
</form>
<form action="validate.jsp" name="login">触发动作到validate.jsp页面
<body> <jsp:useBean id="user" class="com.jkxy.model.usertable"></jsp:useBean> <jsp:useBean id="userservice" class="com.jkxy.service.userservice"/> <jsp:setProperty property="*" name="user"/> <% out.print(user.getUsername()); out.print(user.getPassword()); if(userservice.valiUser(user)) out.print("success"); else out.print("error"); %> </body>
<jsp:setProperty property="*" name="user"/>这步获取登录页面中文本框输入后request中的值
<jsp:useBean id="userservice" class="com.jkxy.service.userservice"/>在此用到一个userservice类来判断是否与数据库中的内容相符
package com.jkxy.service; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.jkxy.model.usertable; public class userservice { private Connection conn; private PreparedStatement pstmt; public userservice() { conn = new com.jkxy.conn.conn().getCon(); } public boolean valiUser(usertable user) { try { pstmt = conn.prepareStatement("select * from usertable where username=? and password=?"); pstmt.setString(1, user.getUsername());// 1表示第一个问号 pstmt.setString(2, user.getPassword());// 2表示第二个问号 ResultSet rs = pstmt.executeQuery();// 结果集查询 if (rs.next()) return true; else return false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return false; } } }