jsp修改密码页面连接SQLserver数据库的代码，这个代码对吗？有源代码的可以发一下吗蟹蟹
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312" import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Insert title here</title>
</head>
<body>
<%
String username = request.getParameter("username") ;
String password = request.getParameter("userPassword") ;
public static void main(String[] args) {
final String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";//SQL数据库引擎
final String dburl="jdbc:sqlserver://localhost:1433;DatabaseName=stumanager";
final String username="sa";
final String password="123456";
Connection conn = null ;
PreparedStatement pstmt = null ;
String sql = null ;
if(username!=null&&password!=null){
try{
Class.forName(driverName) ;
conn = DriverManager.getConnection(dburl,username,password) ;
sql = "insert into users (username,userpassword) values (?,?)" ;
pstmt = conn.prepareStatement(sql) ;
pstmt.setString(1,username) ;
pstmt.setString(2,password) ;
pstmt.executeUpdate() ;
pstmt.close() ;
conn.close() ;
%>
<h3>修改成功!!!</h3>
<h3>三秒钟后自动转到登录页面!!!</h3>
<h3>如果没有跳转，请点击<a href="login.jsp">这里</a>!!!</h3>
<%
response.setHeader("refresh","3;url=login.jsp") ;
}catch(Exception e){
%>
<h3>修改失败!!!</h3>
<h3><%=e%></h3>
<%
}
}
%>
</body>
</html>
默雨_2回答
随时随地看视频慕课网APP
相关分类
Java
SQL Server