1.登陆验证代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test1","root","123456");
PreparedStatement pst=conn.prepareStatement("select * from user1 where username=? and password=?");
pst.setString(1,request.getParameter("username"));
pst.setString(2,request.getParameter("password"));
ResultSet rs=pst.executeQuery();
if(rs.next()){
out.print("登录成功");
response.setHeader("refresh","3;url=SelectNews.jsp");
}
else{
out.print("失败");
}
}
catch(Exception e){
out.println(e);
}
%>
</body>
</html>
注册代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test1","root","123456");
PreparedStatement pst=conn.prepareStatement("insert into user1(username,password) values(?,?)");
pst.setString(1,request.getParameter("username"));
pst.setString(2,request.getParameter("password"));
int rs=pst.executeUpdate();
if(rs>0){
out.print("成功");
response.setHeader("refresh","3;url=login1.jsp");
}
else{
out.print("失败");
}
}
catch(Exception e){
out.println(e);
}
%>
</body>
</html>
登陆页面代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="DoLogin.jsp" method="post">
<h3>输入用户名:<input type="text" name="username"/><h3>
<h3>输入密码:<input type="text" name="password"/><h3>
<input type="submit" value="登录">
</form>
</body>
</html>
注册页面代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="DoReg.jsp" method="post">
<h3>输入用户名:<input type="text" name="username"/><h3>
<h3>输入密码:<input type="text" name="password"/><h3>
<input type="submit" value="注册">
</form>
</body>
</html>
数据库增删改查
删
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<% try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "123456");
String id=request.getParameter("id");
PreparedStatement pst=conn.prepareStatement("delete from user1 where id=?");
pst.setString(1, id);
int rs=pst.executeUpdate();
}
catch(Exception e){
out.println(e);
}
%>
</body>
</html>