userdao.java

新闻系统的具体的一块

package dao;
import java.sql.*;

public class UserDao {
	public UserDao(){}
	public boolean findUser(String un,String up){
		boolean existuser=false;
		Connection conn=ConnectionManager.getConnection();
		PreparedStatement stmt=null;
		ResultSet rs=null;
		try{
			String sql="select * from users where userName=? and userPassword=?";
			stmt=conn.prepareStatement(sql);
			stmt.setString(1,un);
			stmt.setString(2,up);
			rs=stmt.executeQuery();
			if(rs.next()){			
				existuser=true;
				}		
			else
				existuser=false;
		} catch(SQLException e){
			System.out.println("发生错误！错误原因："+e.getMessage());
		}finally{
			ConnectionManager.closeAll(null,stmt,conn);
		} 
		return existuser;
	}
//	public static void main(String[] args) {
//		Connection conn=ConnectionManager.getConnection();
//		try{
//			Statement stmt=conn.createStatement();
//			stmt.execute("insert into users values(44,'Jack','1')");
//			stmt.close();
//			conn.close();
//		} catch(SQLException e){
//			e.printStackTrace();
//		}			
//	}
}