<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = null;
Statement st = null;
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=help", "sa","");
st = conn.createStatement();
%>
<%
String s_userid=request.getParameter("username");
String s_password=request.getParameter("password");
String s_gender=request.getParameter("gender");
String s_phone=request.getParameter("call");
String s_email=request.getParameter("email");
String s_sql="insert into userinfo(username,password,gender,call,email) "+
"values('"+s_userid+"','"+s_password+"','"+s_gender+"','"+s_phone+"','"+s_email+"')" ;
try{
st.executeUpdate(s_sql);
}
catch(Exception e){
response.sendRedirect("error.jsp");
}
%>
这是部分代码,就是如果重复的话,插入就会抛出异常,所以就用sendredirect跳转到error.jsp,但是,这样我每次访问注册页面,都直接跳去error.jsp,是因为异常还在吗?怎样解决?谢谢各位大大了~~~~~