ValidateUserBean.java
上传用户:shangko128
上传日期:2020-01-23
资源大小:22k
文件大小:1k
- import java.io.*;
- import java.text.*;
- import java.util.*;
- import javax.servlet.*;
- import javax.servlet.http.*;
- import java.sql.*;
- public class ValidateUserBean
- {
- static Connection con = null;
- static Statement stmt = null;
- static ResultSet rs=null;
-
- public static void ValidateUserBean1( )
- {
-
- try
- {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/exam");
- stmt= con.createStatement();
- }
- catch(Exception e)
- {
- e.printStackTrace();
- }
- }
- public static boolean getValidUser(String userid,String password)
- {
- ValidateUserBean1();
- try
- {
- String ser = null;
-
- rs = stmt.executeQuery("Select * from table2 where uname = '"+userid+"' and pass='"+password+"'");
-
- if(rs.next())
- {
- System.out.println("Correct user & password in userBean"+userid);
- return true;
- }
- else
- {
- System.out.println("InCorrect user & password in userBean");
- return false;
- }
-
- }
- catch(Exception e)
- {
- System.out.println(e);
- return false;
- }
-
- }
- };