在mysql建表如下:
创建登录界面jsp
姓名:
密码:
创建后台连接数据库log.jsp
String userName="root";
String userPwd="123456";
String dbName="userlog";
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
String user=request.getParameter("name");
String password=request.getParameter("pwd");
String sql="select * from user where name=? and password=?";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1,user);
pstmt.setString(2, password);
ResultSet rs = pstmt.executeQuery();
if(rs.next()) {
%>
登陆成功!
else {
%>
用户名或密码错误!
if(rs != null) {rs.close();}
if(pstmt!=null){pstmt.close();}
if(conn!=null){conn.close();}
%>