📄 sign.jsp
字号:
<html>
<body bgcolor="#CCFFFF">
<%@ page errorPage="errorpage.jsp" language="java" import="java.sql.*" %>
<%
Connection conn;
conn=null;
ResultSet rs;
rs=null;
String UserName=request.getParameter("UserName");
String Password=request.getParameter("Password");
String Password2=request.getParameter("Password2");
String FirstName=request.getParameter("FirstName");
String MiddleName=request.getParameter("MiddleName");
String LastName=request.getParameter("LastName");
String Address1=request.getParameter("Address1");
String Address2=request.getParameter("Address2");
String City=request.getParameter("City");
String State=request.getParameter("State");
String PinCode=request.getParameter("PinCode");
String Email=request.getParameter("Email");
String Phone=request.getParameter("Phone");
int flag=0;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn =DriverManager.getConnection("jdbc:odbc:Data","scott","tiger");
PreparedStatement stat= conn.prepareStatement("SELECT * FROM user_profile where username=?" );
stat.setString(1,UserName);
rs = stat.executeQuery();
out.println("query executed");
if(rs.next())
{
flag=1;
%>
<SCRIPT language="JavaScript">
alert("User name already exists");
location.href="NewUser.htm";
</SCRIPT>
<%
}
else
{
flag=0; // conn.close();
}
}
catch(Exception E)
{
out.println("Error "+E);
}
if(flag == 0)
{
try
{
PreparedStatement stat1=conn.prepareStatement("INSERT INTO user_auth values(?,?)");
stat1.setString(1,UserName);
stat1.setString(2,Password);
PreparedStatement stat=conn.prepareStatement("INSERT INTO user_profile values(?,?,?,?,?,?,?,?,?,?,?,?)");
stat.setString(1,UserName);
stat.setString(2,Password);
stat.setString(3,FirstName);
stat.setString(4,MiddleName);
stat.setString(5,LastName);
stat.setString(6,Address1);
stat.setString(7,Address2);
stat.setString(8,City);
stat.setString(9,State);
stat.setString(10,PinCode);
stat.setString(11,Email);
stat.setString(12,Phone);
stat.executeUpdate();
stat1.executeUpdate();
flag=0;
response.sendRedirect("Login.htm");
}
catch(Exception E)
{
out.println("Error inserting value"+E);
}
finally
{
rs.close();
conn.close();
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -