userimpl.java

ibatis 增删改查 ibatis 增删改查 ibatis 增删改查 登录验证

package com.test.vo;

import java.io.IOException;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.ibatis.sqlmap.client.SqlMapClient;
import com.test.bean.User;
import com.test.db.ConnectDataBase;
import com.test.interfaces.UserInterFace;

public class UserImpl implements UserInterFace  {
	
	private SqlMapClient sqlmap ;
	private int isOK = 0;
	private List getUser ; 
	ConnectDataBase cdb = new ConnectDataBase();
	public UserImpl(){
		try {
			this.sqlmap = cdb.getSqlMapClient();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	//删除单个用户
	public int deleteUser(int id) {
		try {
			sqlmap.startTransaction();
			
			isOK = sqlmap.delete("delete_user",id);
			
			sqlmap.commitTransaction() ;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			
			try {
				sqlmap.endTransaction();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return isOK;
	}
	
	//添加用户
	public int insertUser(User user) {
		try {
			sqlmap.startTransaction();
			isOK = (Integer)sqlmap.insert("insertUser",user);
			sqlmap.commitTransaction() ;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			
			try {
				sqlmap.endTransaction();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return isOK;
	}

	//查找一个用
	public List isUser(User user) {
		try {
			sqlmap.startTransaction();
			getUser = (List)sqlmap.queryForList("getUser",user);
			sqlmap.commitTransaction() ;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			
			try {
				sqlmap.endTransaction();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return getUser;
	}
	
	//修改用户
	public void updateUser(User user) {
		try {
			sqlmap.startTransaction();
			sqlmap.update("update_user",user);
			sqlmap.commitTransaction() ;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			
			try {
				sqlmap.endTransaction();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	//检查用户
	public int checkUser(User user) {
		try {
			sqlmap.startTransaction();
			isOK = (Integer)sqlmap.queryForObject("getOneUser",user);
			sqlmap.commitTransaction() ;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			
			try {
				sqlmap.endTransaction();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return isOK;
	}

	//批处理
	public void deleteBatch(List id) {
		// TODO Auto-generated method stub
		try {
			sqlmap.startTransaction();
			sqlmap.startBatch();
			for(int i = 0 ;i<id.size();i++){
				isOK = (Integer)sqlmap.delete("delete_user",id.get(i));
			}
			sqlmap.executeBatch();
			sqlmap.commitTransaction() ;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			
			try {
				sqlmap.endTransaction();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}