create database mydatabase;
use mydatabase;
create table account(name varchar(2
0) primary key,password varchar(5
0) not null);
insert into account(name,password) values('南京交通','njjt') ;
select*from account;
update account set password =md5(password);
select*from account;
package myPackage.examJavaBean;
import java.
sql.*;
public class DatabaseConn {
private static Connection conn =null;
public static Connection getConnection(String url,String username,String password) {
try {
Class.forName("com.my
sql.jdbc.Driver");
conn =DriverManager.getConnection(url,username,password);
}catch(ClassNotFoundException e) {
System.out.println(e);
}catch(
SQLException e){
System.out.println(e);
}
return conn;
}
public static void getClose(Connection conn,Statement ps,ResultSet rs){
try{
if(rs!=null)
rs.close();
if(ps!=null)
ps.close();
if(conn!=null)
conn.close();
}catch(
SQLException e){
System.out.println(e);
}
}
}
<%@ page language="java" contentType="text/html; charset=GB18
03
0"%>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<script src="/myPro/jQuery/jquery-3.6.4.min.js"></script>
<script type="text/javascript">
if($("#user").focus()){
var veriUser=function(){
var user=$("#user").val();
if(user==null||user=="")
$("#userMsg").html("输入用户名");
else
$("#userMsg").html("");
};
}
if($("#pwd").focus()){
var veriPwd=function(){
var pwd=$("#pwd").val();
if(pwd==null||pwd=="")
$("#pwdMsg").html("输入登录密码");
else
$("#pwdMsg").html("");
};
}
$(function(){
$("#btn").bind("click",function(){
var user =$("#user").val();
var pwd=$("#pwd").val();
if(user==null||user==""||pwd==null||pwd=="")
return false;
});
});
</script>
<body>
<form id="form" name="form" method="post" action="/myPro/servlet/Servletexam">
<p>用户名：<input type="text" name="user" id="user" maxlength="12" onblur="veriUser()"/><em id="userMsg"></em></p>
<p>密
码：<input type="password"name="pwd"id="pwd"maxlength="12"onblur="veriPwd()"/><em id="pwdMsg"></em></p>
<p>
<input type="submit"name="button"id="btn" value="提交"/>
<input type="reset"name="button" value="取消"/></p></form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=GB18
03
0"%>
<html>
<head>
<title>NewFile.jsp</title>
</head>
<style type="text/css">
h2{text-align:center}
p{text-align:center;color:red}
</style>
<body>
<h2>登录结果</h2>
<p> 登录成功！</p>
<p>欢迎你，<%=session.getAttribute("name")%></p>
</body>
</html>
package myPackage.examServlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.
sql.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.commons.codec.digest.DigestUtils;
import myPackage.examJavaBean.DatabaseConn;
@WebServlet("/servlet/Servletexam")
public class Servletexam extends HttpServlet{
private static final long serialVersionUID=1L;
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
doPost(request,response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
request.setCharacterEncoding("GB18
03
0");
String name=request.getParameter("user");
String password=request.getParameter("pwd");
response.setContentType("text/html;charset=GB18
03
0");
HttpSession session =request.getSession();
PrintWriter out =response.getWriter();
Connection conn =DatabaseConn.getConnection("jdbc:my
sql://localhost:33
06/myDatabase","root","my
sql");
try{
PreparedStatement ps=conn.prepareStatement("select password from account where name =?");
ps.setString(1,name);
ResultSet rs=ps.executeQuery();
if(rs. next()) {
if(DigestUtils.md5Hex(password).equals(rs.getString(1))){
session.setAttribute("name", name);
response.sendRedirect("/myPro/exam/success.jsp");
}else
out. print("<script type=text/javascript>alert(' 密码错误！重新登录'); location='/myPro/exam/login.jsp'</script>");
}else
out. print("<script type=text/javascript>alert(' 用户名错误！重新登录'); location='/myPro/exam/login.jsp'</script>");
DatabaseConn.getClose(conn,ps,rs);
}
catch(
SQLException e){
System.out.println(e);
}
}
}
<%@ page language="java" contentType="text/html; charset=GB18
03
0"%>
<html>
<body>
<%
out.print("这是一场考试");
%>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=GB18
03
0"%>
<html>
<body>
<%
int
sum=
0;
for( int i=1;i<=5
0;i++)
sum +=i;
%>
<p>5
0以内正整数的和为<%=
sum %></p>
</body>
</html>
扫一扫
1743
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
