loginutil.java

java登陆界面 java登陆界面

package com.liup.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class loginUtil {
	private Connection conn=null;
	private PreparedStatement pt=null;
	private ResultSet rs=null;
	private boolean flag;
	
	public boolean adminLogin(String username,String pwd){
		conn=DBConn.getConn();
		try {
			pt=conn.prepareStatement("select *from [user] where username=? and pwd=?");
			pt.setString(1, username);
			pt.setString(2, pwd);
			rs=pt.executeQuery();
			while(rs.next()){
				flag=true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			try {
		        rs.close();
				pt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		return flag;
	
	}

}