<%@ 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>
添加回答
举报
0/150
提交
取消