<%@ 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數(shù)據(jù)庫(kù)引擎? ? ? ? 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>三秒鐘后自動(dòng)轉(zhuǎn)到登錄頁(yè)面!!!</h3>? ? <h3>如果沒(méi)有跳轉(zhuǎn),請(qǐng)點(diǎn)擊<a href="login.jsp">這里</a>!!!</h3>? ? <%? ? response.setHeader("refresh","3;url=login.jsp") ;? ? }catch(Exception e){? ? %>? ? <h3>修改失敗!!!</h3>? ? <h3><%=e%></h3>? ? <%?? ? }? ? }? ? %>? ? ? ? </body></html>
jsp修改密碼頁(yè)面連接SQLserver數(shù)據(jù)庫(kù)的代碼,這個(gè)代碼對(duì)嗎?有源代碼的可以發(fā)一下嗎蟹蟹
默雨_
2018-12-07 10:55:58