📄 check.java
字号:
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Check extends HttpServlet
{
Statement stmt;
Connection conn;
ResultSet rs;
PrintWriter out;
String name ="";
String password="";
public boolean Con()
{
conn=null;
try{
out.println("1");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.println("2");
conn=DriverManager.getConnection("jdbc:odbc:book");
out.println("3");
stmt=conn.createStatement();
out.println("4");
rs=stmt.executeQuery("Select * from check");
out.println("5"+"<br>");
while(rs.next())
{
//out.println(rs.getString(1)+"<br>");
//out.println("123".equals(rs.getString(1)) +"<br>");
//out.println(rs.getString(2)+"<br>");
//out.println("123".equals(rs.getString(2))+"<br>");
if(name.equals(rs.getString(1)) && password.equals(rs.getString(2)))
return true;
}
}
catch(Exception e)
{out.println("error");
e.printStackTrace();
}
return false;
}
public void doPost(HttpServletRequest req, HttpServletResponse res)throws ServletException, IOException
{
res.setContentType("text/html");
out = res.getWriter();
name=req.getParameter("username");
password=req.getParameter("password");
String remember = req.getParameter("remember");
out.println(remember+"<br>");
if(remember!=null)
{
Cookie c=new Cookie("username",name);
c.setMaxAge(60*60*24*365);
res.addCookie(c);
c=new Cookie("password",password);
c.setMaxAge(60*60*24*365);
res.addCookie(c);
}
boolean f=Con();
close();
out.println(f+"<br>");
if(f)
{
res.sendRedirect("http://localhost/wap/servlet/books");
}
else
{
res.sendRedirect("http://localhost/wap/servlet/index");
//out.println("<Html><body><b>Wrong Username or Password!!! Try Again</body></html>");
}
}
/*
public void init()
{
Con();
}
public void destroy()
{
close();
}*/
public void close()
{
try{
stmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -