logindao.java

广州物价系统开发部分模块

package gzwj.dao;

import java.sql.ResultSet;
import java.util.ArrayList;
//import gzwj.bean.CurrentUser;

import gzwj.bean.LoginBean;
import gzwj.iface.DaoCommon;
import gzwj.iface.FormBean;
import gzwj.sql.Dbpool;

public class loginDao extends Dao implements DaoCommon {
	
	public loginDao() throws Exception
	{
		this.db = new Dbpool(); 
		db.getPool(this.Constant.connectName);	
	}

	public Object queryExecute(DateBean context) throws Exception {
		// TODO Auto-generated method stub
		 
		LoginBean  bean =  (LoginBean)context;
		ArrayList list = new ArrayList();
		String u_name = bean.getUser_Name();
		//String u_password = bean.getMemberpassword();
		String sql = "select * from O_User_Master where User_Name= '"+u_name+"'";
	
		System.out.println(sql);
		ResultSet set; 
	    set = db.getRst(sql);
		if(set.next())
		{ 
			System.out.println("success login");
			list.add(set.getString("User_ID"));
			list.add(set.getString("User_Full_Name"));
			list.add(set.getString("User_State"));
			list.add(set.getString("User_Cell"));			
			list.add(set.getString("User_Company"));	
			list.add(set.getString("User_Phone"));	
			list.add(set.getString("User_Fax"));	
			list.add(set.getString("User_Email"));
			list.add(set.getString("User_Address"));
			list.add(set.getString("User_Content"));
		}
		//list.add(u_name);
		return list;
		
	}
	
}