usermanage.java

网上商城代码

package com.fendou.dao;

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

import com.fendou.exception.UserException;
import com.fendou.platform.DBConnection;

public class UserManage {
	private Connection conn;
	private PreparedStatement pstm;
	private Statement stm;
	private ResultSet rs;	
	private DBConnection db=DBConnection.getInstance();
	
	public boolean validateUser(String user,String pwd) throws UserException{
		String sql = "select count(UserID) from T_User where UserName='"+user+"' and UserPassword='"+pwd+"'";       
        try{
        	conn=db.getConnection();
        	stm = conn.createStatement();
        	rs=stm.executeQuery(sql);
        	int count=0;
        	while(rs.next()){
        		count=rs.getInt(1);
        	}
        	if(count>0)
        		return true;
        	else
        		return false;
        }catch(SQLException e){
        	throw new UserException("validateUser error");
        }finally{
        	db.closeConnection(conn, stm, rs);        	
        }		
	}
	
	
}