userdao.java

利用SQLServer2000实现学生管理系统！

package com.yhf.user;

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

import com.yhf.beans.CreateConnection;

public class UserDAO {
	private Connection conn;
	private Statement stmt;
	public UserDAO() throws SQLException{
		this.conn=CreateConnection.conn;
		this.stmt=conn.createStatement();
		
	}
	public boolean checkUser(UserBean userBean) throws SQLException{
		String loginname=userBean.getLoginname();
		String loginpwd=userBean.getLoginpwd();
		String sql="select * from userpwd where username='" + loginname 
					+ "' and pwd='" + loginpwd + "'";
		ResultSet rs=this.stmt.executeQuery(sql);
		boolean isFind=rs.next();
		rs.close();
		return isFind;
		
	}
}