login.java

JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计、JSP002网站流量统计

package bean;

import java.sql.*;


public class Login {

	Connection conn = null;
	Statement st = null;
	ResultSet rs = null;
	boolean bool = false;
	
	public boolean getLogin(String name,String pwd){
	

		 try{

	            conn = DBConn.getConn(); 
	            st=conn.createStatement();
	            rs=st.executeQuery("select * from [user] where loginName='"+name+"' and loginPwd='"+pwd+"' ");
	            
	            if(rs.next()){
	            	bool = true;
	            }
	            
	        }catch(Exception ex){
	            ex.printStackTrace();
	            bool = false;
	        }finally{
	        	try{
					if(rs!=null)rs.close();
					if(st!=null)st.close();
					if(conn!=null)conn.close();
				}catch(Exception ee){
					ee.printStackTrace();
				}
	        }
	
	        return bool;
	}
	

}