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 + -
显示快捷键?