userdao.java

使用JAVA图形用户界面设计的简单的地址管理系统附带数据库

package com.huade.address.user.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.common.BaseDao;
import com.huade.address.linkmen.dto.UserinfoDto;
import com.huade.address.user.dao.impl.UserinfoImpl;

public class UserDao implements UserinfoImpl
{

	public void deleteUser(String userId)
	{
		String sql ="delete userinfo where userId  = "+userId;
		BaseDao.doExecute(sql);
	}

	public List getAllUser()
	{
        String sql = "select * from  userinfo";
        ResultSet rs =  BaseDao.doQuery(sql);
        List<UserinfoDto> userList  = new ArrayList<UserinfoDto>();
        try
		{
			while(rs.next())//next()的作用:1.判断指针下面是否有数据记录 2.有记录 返回 true  否则 返回 false
				{
				    UserinfoDto userinfoDto = new UserinfoDto();
				    //把表中字段的值封装到  javabean   ---->userinfoDto
				    userinfoDto.setUserId(rs.getString("userId"));
				    userinfoDto.setUserAccount(rs.getString("userAccount"));
				    userinfoDto.setUserPwd(rs.getString("userPwd"));
				    userinfoDto.setUserName(rs.getString("userName"));
				    userinfoDto.setUserSex(rs.getInt("userSex"));
				    userinfoDto.setUserAge(rs.getInt("userAge"));
				    userinfoDto.setUserTel(rs.getString("userTel"));
				    userinfoDto.setUserEmail(rs.getString("userEmail"));
				    userinfoDto.setUserAddress(rs.getString("userAddress"));
				    userinfoDto.setUserState(rs.getInt("userState"));
				    //把带有数据的  dto 放到 List
				    userList.add(userinfoDto);						    
				}
		} catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return userList;
	}

	public UserinfoDto getUserinfoById(String userId)
	{
		String  sql   = "select *  from  userinfo  where userId = "+userId;
          ResultSet rs =  BaseDao.doQuery(sql);
          UserinfoDto userinfoDto = new UserinfoDto();
      try
  		{
  			while(rs.next())//next()的作用:1.判断指针下面是否有数据记录 2.有记录 返回 true  否则 返回 false
  				{	   
  				    //把表中字段的值封装到  javabean   ---->userinfoDto
  				    userinfoDto.setUserId(rs.getString("userId"));
  				    userinfoDto.setUserAccount(rs.getString("userAccount"));
  				    userinfoDto.setUserPwd(rs.getString("userPwd"));
  				    userinfoDto.setUserName(rs.getString("userName"));
  				    userinfoDto.setUserSex(rs.getInt("userSex"));
  				    userinfoDto.setUserAge(rs.getInt("userAge"));
  				    userinfoDto.setUserTel(rs.getString("userTel"));
  				    userinfoDto.setUserEmail(rs.getString("userEmail"));
  				    userinfoDto.setUserAddress(rs.getString("userAddress"));
  				    userinfoDto.setUserState(rs.getInt("userState"));
  				 						    
  				}
  		} catch (SQLException e)
  		{
  			// TODO Auto-generated catch block
  			e.printStackTrace();
  		}
		return userinfoDto;
	}

	public void modifyUser(UserinfoDto userinfoDto)
	{
		// TODO Auto-generated method stub
		
		StringBuffer sql  = new StringBuffer();
		sql.append("update  userinfo set userAccount = '" +userinfoDto.getUserAccount()+"',");		
		sql.append(" userPwd = '"+userinfoDto.getUserPwd()+"', ");
		sql.append(" userName = '"+userinfoDto.getUserName()+"', ");
		sql.append("  userSex  = "+userinfoDto.getUserSex()+", ");
		sql.append(" userAge = "+userinfoDto.getUserAge()+", ");
		sql.append("  userTel = '"+userinfoDto.getUserTel()+"',");
		sql.append("  userEmail = '"+userinfoDto.getUserEmail()+"', ");
		sql.append( "  userState = " +userinfoDto.getUserState()) ;
		sql.append("   where userId = "+userinfoDto.getUserId());
		BaseDao.doExecute(sql.toString());

	}

	public void saveUser(UserinfoDto userinfoDto)
	{
		// TODO Auto-generated method stub
		
		StringBuffer sql = new StringBuffer();
		sql.append("  insert into  userinfo( userAccount, userPwd , userName , userSex    ,userAge   ,userTel  , userEmail  , userAddress  , userState) values ('");
		sql.append(userinfoDto.getUserAccount() +"','");
		 sql.append(userinfoDto.getUserPwd()+"','");
		sql.append(userinfoDto.getUserName()+"',");
		sql.append(userinfoDto.getUserSex()+",");
		sql.append(userinfoDto.getUserAge()+",'");
		sql.append(userinfoDto.getUserTel()+"','");
		sql.append(userinfoDto.getUserEmail()+"','");
	    sql.append(userinfoDto.getUserAddress()+"', ");
	    sql.append(userinfoDto.getUserState()+")");
	   BaseDao.doExecute(sql.toString());
	}

	public UserinfoDto isExistsUser(String userAccount ,String userPwd)
	{
		// TODO Auto-generated method stub
		String  sql  = "select * from  userinfo where userAccount= '"+userAccount+"'"
		                + " and  userPwd = '"+userPwd +"'";
		ResultSet rs = BaseDao.doQuery(sql);
		UserinfoDto userinfoDto  = new UserinfoDto();
		if(rs!=null)
		{
			try
			{
				while(rs.next())
				{
  				    userinfoDto.setUserId(rs.getString("userId"));
  				    userinfoDto.setUserAccount(rs.getString("userAccount"));
  				    userinfoDto.setUserPwd(rs.getString("userPwd"));
  				    userinfoDto.setUserName(rs.getString("userName"));
  				    userinfoDto.setUserSex(rs.getInt("userSex"));
  				    userinfoDto.setUserAge(rs.getInt("userAge"));
  				    userinfoDto.setUserTel(rs.getString("userTel"));
  				    userinfoDto.setUserEmail(rs.getString("userEmail"));
  				    userinfoDto.setUserAddress(rs.getString("userAddress"));
  				    userinfoDto.setUserState(rs.getInt("userState"));
                    return userinfoDto;				
				}
			} catch (SQLException e)
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return null;
	}

}