📄 checknewservlet.java
字号:
import java.sql.*;
import javax.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import com.*;
//import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;
public class CheckNewServlet extends HttpServlet{
Connection con=null;
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws IOException, ServletException
{
response.setContentType("text/html;charset=gb2312");
PrintWriter out = response.getWriter();
try
{
String name=request.getParameter("name");
String pass=request.getParameter("pass");
String admin=request.getParameter("admin");
String user=request.getParameter("user");
String movie=request.getParameter("movie");
String order=request.getParameter("order");
String announce=request.getParameter("announce");
String message=request.getParameter("message");
String problem=request.getParameter("problem");
Connection con=DBConnection.getConnection();
CallableStatement stmt=con.prepareCall("{call register (?,?,?,?,?,?,?,?,?,?)}");
stmt.setString(1,name);
stmt.setString(2,pass);
System.out.println("11111111111111111111111");
System.out.println(name);
stmt.setInt(3,Integer.parseInt(admin));
System.out.println("22222222222222222222222");
stmt.setInt(4,Integer.parseInt(user));
stmt.setInt(5,Integer.parseInt(movie));
stmt.setInt(6,Integer.parseInt(order));
stmt.setInt(7,Integer.parseInt(announce));
stmt.setInt(8,Integer.parseInt(message));
stmt.setInt(9,Integer.parseInt(problem));
stmt.registerOutParameter(10,java.sql.Types.SMALLINT);
stmt.execute();
out.println("<html>");
out.println("<head><title>注册成功</title></head>");
out.println("<body>");
out.println("<center>");
out.println("<form>");
out.println("<p><br><font color='red'>"+name+"</font></br></p>"+"恭喜您注册成功！您的注册ID号是"+ "<br><font color='red'>"+stmt.getInt(11)+"</font></br></p>" +"请妥善保管好ID号。" );
out.println("<br>");
out.println("<form action='../login/index.html' name='MyForm'>");
out.println("<input type='submit' value='返回'>");
out.println("</form>");
out.println("</center>");
out.println("</body>");
out.println("</html>");
stmt.close();
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException, ServletException
{
doGet(request,response);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -