1.login.jsp
<%@ page language="java" pageEncoding="GB2312"%>
<html>
<head><title>用户登录提交页面</title>
<style type="text/css">
body{
background:url("wwe.jpg");
background-repeat:no-repeat;
background-size:cover;
}
</style>
</head>
<body>
<h3 align="center">登录页面</h3>
<form action="yanzheng.jsp" method="post">
<p align="center">
用户名称:<input type="text" name="username"><br><br>
用户密码:<input type="password" name="pass"><br><br>
<input type="submit" value="登录">
</form>
</body>
</html>
2.连接数据库
<%@ page language="java" import="java.sql.*" pageEncoding="GB2312"%>
<html>
<head>
<title>登录验证页面</title>
</head>
<body>
<%
Connection conn = null;
PreparedStatement pstmt = null;
;
ResultSet rs = null;
String driverName = "com.mysql.jdbc.Driver"; //驱动程序名
String dbName = "user"; //数据库名
String url1 = "jdbc:mysql://localhost/" + dbName;
String url2 = "?user=root&password=123456";
String url3 = "&useUnicode=true&characterEncoding=GB2312";
String url = url1 + url2 + url3;
try {
Class.forName(driverName);
conn = DriverManager.getConnection(url);
request.setCharacterEncoding("GB2312");
String name = request.getParameter("username");
String pw = request.getParameter("pass");
String sql = "select * from user_b where(uname=? and upassword=?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, pw);
rs = pstmt.executeQuery();
if (rs.next()) {
%>
<%=name%>:登录成功!<br>
<%
} else {
%>
<%=name%>:登录失败!<br>
<%
}
} catch (Exception e) {
%>
出现异常错误!
<br>
<%=e.getMessage()%>
<%
} finally {
if (rs != null) {
rs.close();
}
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
}
%>
</body>
<html>