check.java
来自「好东西 利用J2EE开发的系统 能连接数据库」· Java 代码 · 共 105 行
JAVA
105 行
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 + =
减小字号Ctrl + -
显示快捷键?