dataservlet.java
来自「j2EE」· Java 代码 · 共 68 行
JAVA
68 行
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DataServlet extends HttpServlet
{
Connection con;
Statement st;
String name =" ";
String password=" ";
int flag = 0;
public void doGet(HttpServletRequest req, HttpServletResponse res)throws ServletException, IOException
{
res.setContentType("text/html");
PrintWriter out = res.getWriter();
name = req.getParameter("username");
password = req.getParameter("password");
int num = Connect();
if(num==1)
{
res.sendRedirect("Application");
}
else
{
res.sendRedirect("http://localhost/Login.html");
//out.println("<Html><body><b>Wrong Username or Password!!! Try Again</body></html>");
}
}
public int Connect()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
System.out.println(ce);
}
try{
con = DriverManager.getConnection("jdbc:odbc:test2");
st = con.createStatement();
ResultSet rs = st.executeQuery("Select * from login");
rs.next();
if(name.equals(rs.getString(1)) && password.equals(rs.getString(2)))
flag=1;
else
flag = 0;
}catch(SQLException se)
{
System.out.println(se);
}
if(flag==1)return 1;
else return 0;
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?