<%@page import=“java.sql.ResultSet”%>
<%@page import=“java.sql.Statement”%>
<%@page import=“java.sql.DriverManager”%>
<%@page import=“java.sql.Connection”%>
<%@page import=“java.util.Enumeration”%>
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
<%@page import=“java.util.Enumeration” %>
<%
String jsh = request.getParameter(“abc”);
String xm = request.getParameter(“abd”);
String xb = request.getParameter(“abe”);
String nl = request.getParameter(“abf”);
String kc = request.getParameter(“abg”);
Connection conn=null;
Statement stmt=null;
try{
Class.forName(“com.mysql.jdbc.Driver”);
String url=“jdbc:MYSQL://127.0.0.1:3306/wsf?useUnicode=true&characterEncoding=UTF-8”;
String dataUsername=“root”;
String dataPwd=“root”;
conn = DriverManager.getConnection(url,dataUsername,dataPwd);
stmt = conn.createStatement();
String sql1 = “insert into wwe values(’”+jsh+"’,’"+xm+"’,’"+xb+"’,’"+nl+"’,’"+kc+"’)";
if(stmt.executeUpdate(sql1)>0){
session.setAttribute(“message”,“注册成功!”);
response.sendRedirect("…/message.jsp");
//response.sendRedirect("…/index.jsp");
}else{
session.setAttribute("message","注册失败!");
response.sendRedirect("../message.jsp");
//response.sendRedirect("ZhuCe2.1.jsp");
}
}catch(ClassNotFoundException e){
out.println(“数据库驱动异常”);
e.printStackTrace();
}catch(Exception e){
session.setAttribute("message","注册失败!");
response.sendRedirect("../message.jsp");
}finally{
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
}
%>