zhuce3.jsp

解压在c盘

<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 

<% 
String spath="wangye/ec.mdb";   
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement();


 %>
<%

   String username=request.getParameter("username");
   String truename=request.getParameter("truename");
   String password=request.getParameter("pwd");
   String address=request.getParameter("address");
   String postcode=request.getParameter("postcode");
   String cardno=request.getParameter("cardno");
   String tel=request.getParameter("tel");
   String email=request.getParameter("email");
 
ResultSet rs=stmt.executeQuery("select * from maijia where username='"+username+"'");
if (rs.next()){
	out.println("<script language='javascript'>alert('该用户名已经存在，请重新注册！');window.location.href='zhuce3.htm';</script>");
}else{

%>


<%
 
  String reg="insert into maijia(username,truename,password,address,postcode,cardno,tel,email)values('"+username+"','"+truename+"','"+password+"','"+address+"','"+postcode+"','"+cardno+"','"+tel+"','"+email+"')";
        stmt.executeUpdate(reg);

%>


<%
   out.print("注册成功");
   session.setAttribute("maijianame",username);
			response.sendRedirect("maijiadengru.jsp");
			rs.close(); 
stmt.close(); 
conn.close();
   }
  %>