login.java

来自「JSP酒店服务管理系统,用于中小型饭店的各种服务」· Java 代码 · 共 67 行

package login;

import java.sql.*;



public class login
{
	String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=preconcert"; 
  	String user="sa"; 
  	String password="";
	
	Connection conn =null; 
	Statement stmt =null;
	String sql =null;
	ResultSet rs =null;
	

	public login()
	{
		try{
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
   		conn= DriverManager.getConnection(url,user,password);   
  		stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
		}
		catch(Exception ex)
		{
			System.out.println(ex.getMessage());
		}
	}
	public boolean checkpassword(String user,String passwd)
	{
		String tmp = null;
		sql = "select * from login where username = \'"+user+"\'";
		try{
	
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				tmp = rs.getString(2);
				tmp=tmp.trim();
				if(passwd.compareTo(tmp)==0)
					return true;
				
			}
			
		}
		
		catch(Exception ex)
		{
			System.out.println(ex.getMessage());
		} 
		return false;
	}
	public void close()
	{
		try{
 		stmt.close();   
		conn.close();
		}
		catch(Exception ex)
		{
			System.out.println(ex.getMessage());
		}
	}
}