📄 firstservlet.java
字号:
import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
public class FirstServlet extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
Connection con;
boolean userFound=false;
String accnum=req.getParameter("accnum");
String pinnum=req.getParameter("pinnum");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:MyDatabase","faculty","");
PreparedStatement ps=con.prepareStatement("Select cpin_no from login where cAccount_iD=?");
ps.setString(1,accnum);
ResultSet rs=ps.executeQuery();
if (rs.next())
{
if ((rs.getString(1).trim()).equals(pinnum))
{
System.out.println("pinnumu:=" + pinnum);
userFound=true;
}
}
con.close();
if (userFound)
{
ServletContext sc=getServletContext();
sc.setAttribute("accnumber",accnum);
RequestDispatcher disp=sc.getRequestDispatcher("/second");
if (disp==null)
{
res.sendError(res.SC_NO_CONTENT);
return;
}
disp.forward(req,res);
}
else
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println("<html>");
out.println("<Error, cannot find your number>");
out.println("</html>");
out.close();
}
}
catch(Exception e)
{
System.out.println(e);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -