<%@ page language="java"contentType="text/html; charset=BIG5"
    pageEncoding="BIG5"%>
<%@pageimport="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type"content="text/html; charset=BIG5">
<title>checkname</title>
</head>
<body>
<%
    String user1 = request.getParameter("User");
    String pass1 = request.getParameter("Pass");
    ResultSet rs1;
    Statement stmt1;
    PreparedStatement pstmt1;
    Connection connAcce1;
    String strURL1;
    try{
        strURL1 = "jdbc:odbc:access";//access为DSN名称
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        connAcce1 = DriverManager.getConnection(strURL1,"","");
        stmt1 = connAcce1.createStatement();
        rs1 = stmt1.executeQuery("SELECT * FROM info");
while (rs1.next()) {

if (user1.equals(rs1.getString(2))) {
i = 1;break;
} else {
i = 0;
}
}
if (i == 0) {
pstmt1 = connAcce1
.prepareStatement("insert into info(Username,Pass) values(?,?)");
pstmt1.setString(1, user1);
pstmt1.setString(2, pass1);
pstmt1.executeUpdate();
session.setAttribute("success", "regist success!");
request.getRequestDispatcher("success.jsp").forward(
request, response);
} else {
session.setAttribute("error", "用戶名已存在！請重新輸入");
request.getRequestDispatcher("error.jsp").forward(request,
response);
}

 
        stmt1.close();
        connAcce1.close();
    }catch(Exception ex) {
        ex.printStackTrace();
    }
%>
</body>
</html>