userdao.java

cantain海鲜超市管理系统

package com.j1132.dao.denglu;

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

import com.j1132.bean.UserBean;
import com.j1132.dao.AbstractDao;

public class UserDao extends AbstractDao implements Iuser {

	

	public UserBean result(String username, String password) {
		//创建userBean的对象
		UserBean ub = new UserBean();
		
		Connection conn = null;
		
		String sql = "select * from shop_user su where su.username =? and su.password=?";
		//创建一个预编译语句对象
		PreparedStatement ps = null;
		//获得一个连接
		conn = getConnection();
		//创建一个结果集
		ResultSet rs =null;
		
		//运行sql语句，查询结果，返回一个Bean的对象，关闭语句
		try{
		ps = conn.prepareStatement(sql);
		
		
		ps.setString(1,username);
		
		ps.setString(2,password);
		
		rs = ps.executeQuery();
		
		while (rs.next()){
			String user = rs.getString(1);
			String pass = rs.getString(2);
			int flag = rs.getInt(3);
			ub.setUsername(user);
			ub.setPassword(pass);
			ub.setFlag(flag);
		}
		}catch(Exception e){
			System.out.println("UserDao出现问题");
			e.printStackTrace();
		}finally{
			close(rs, ps, conn);
		}
		return ub;
	}

}