userdao.java

含有 销售商、进货商

package dao;

import java.sql.*;
import java.util.ArrayList;
import java.util.Iterator;

import po.UserPO;
import vo.incomeVO;

public class UserDAO {
	
	Connection conn = null;
	Statement state = null;
	ResultSet rs = null;
	
	//用户验证
	public UserPO FindUser(UserPO po)
	{
		UserPO upo = null;
		try {
			conn = Tools.getConnection();
			state = conn.createStatement();
			rs = state.executeQuery("select * from shop_user where username = '"+po.getUsername()+"' and password = '"+po.getPassword()+"'");
			
			if(rs.next())
			{   
				upo = new UserPO();
				upo.setUsername(rs.getString("username"));
				upo.setPassword(rs.getString("password"));
				upo.setFlag(rs.getString("flag"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
			try {
				rs.close();
				state.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return upo;
	}
}