dbuser.java

Struts数据库项目开发宝典光盘第一部分

package classmate;

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

public class DBUser {

	DataSource dataSource;
	
	public DBUser(DataSource dataSource) {
		
			this.dataSource = dataSource;
	}
	
	
	public boolean checkUser(String name,String psw) throws Exception{
        Connection connect = null;
		String strSql;
		ResultSet rs;
		boolean result=false;
        strSql = "select * from classuser where username='"
					+ name + "' and password='" + psw + "'";
		try {
			connect = dataSource.getConnection();
			Statement stmt = connect.createStatement();
			rs = stmt.executeQuery(strSql);
			if ( rs.next()) {
				result=true;
			}
		} 
		catch(SQLException ex) { 
			ex.printStackTrace();
		}
		finally{
			if(connect!=null)
				connect.close();
		}
		return result;
	
	}
	
}