<%@ page language="java" import="java.sql.*" pageEncoding="ISO-8859-1"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<% String driverName = "com.mysql.jdbc.Driver"; //驱动程序名
String userName = "root"; //数据库用户名
String userPwd = "123456"; //密码
String dbName = "students"; //数据库名
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; //形成带数据库读写编码的数据库连接字
Connection conn=null;
PreparedStatement pstmt=null;
String name=request.getParameter("userName");
String pw=request.getParameter("userPwd");
String sql;
try{
Class.forName(driverName);
conn=DriverManager.getConnection(url);
sql="update yonghu set Spassword=? where Sname=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, pw);
pstmt.setString(2,name);
int n= pstmt.executeUpdate();
if(n==1){
if(pstmt!=null){ pstmt.close(); }
if(conn!=null){ conn.close(); }
response.sendRedirect("xg.jsp");
}
else{
if(pstmt!=null){ pstmt.close(); }
if(conn!=null){ conn.close(); }
response.sendRedirect("xg1.jsp");
}
}catch(Exception e){
e.getMessage();
}
%>
</body>
</html>