package?com.manage.control;


import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.linkedList;
import?java.util.List;
import?java.util.Map;

import?org.apache.ibatis.session.SqlSession;
import?com.manage.mapper.IUsersMappler;
import?com.manage.mybatis.MysqlMyabitsSessionFactory;

import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;
import?com.manage.entity.Depts;
import?com.manage.entity.Positions;
import?com.manage.entity.Users;

public?class?UsersModel?{
????//mybatis連接池對象
	private?SqlSession?sqlSession=null;
	IUsersMappler?usersMappler=null;
	public?UsersModel（）?{
		//?TODO?Auto-generated?constructor?stub
		if（sqlSession==null）{
			sqlSession=MysqlMyabitsSessionFactory.getInstance（）.getSqlSessionFactory（）.openSession（）;
		}

		if?（usersMappler==null）?{
			usersMappler=sqlSession.getMapper（IUsersMappler.class）;
		}
	}
	
	public?Users?CheckLogin（Users?user）{
		user=usersMappler.CheckLogin（user）;	
		
		System.out.println（user.getUedu（））;
		return?user;
????}
	
	public?void?DeleteUsers（int?uid）?{
		try?{
			Users?users=new?Users（）;
			users.setUid（uid）;
			usersMappler.DeleteUsers（users）;
????????	sqlSession.commit（）;
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			e.printStackTrace（）;
			sqlSession.rollback（）;
		}finally?{
			//?TODO:?handle?finally?clause
			sqlSession.close（）;
		}
	}
	
	public?Mapject>?PagesManager（String?nameint?currentPageint?pageNums）{
		
		List?listapp;
		int?count;
		Users?us?=?new?Users（）;
		us.setUname（name）;
		us.setCurrentPage（currentPage）;
		us.setPageNums（pageNums）;
		listapp=usersMappler.SelectUser1（us）;
		count=usersMappler.Count1（us）;
		
	
?????	HashMap?map=null;
?????	Mapject>?mapall=new?HashMapject>（）;
?????	List>?list=new?ArrayList>（）;???
		for?（Users?users?:?listapp）?{
//			System.out.println（users.getDept（）.getDid（））;
			map=new?HashMap（）;
			map.put（“id“String.valueOf（users.getUid（）））;
				map.put（“name“users.getUname（））;
				map.put（“sex“users.getUsex（））;
				map.put（“deptname“users.getDept（）.getDname（））;
				map.put（“did“String.valueOf（users.getDept（）.getDid（）））;
				map.put（“lead“users.getDept（）.getDlead（））;
				map.put（“tel“users.getDept（）.getDtel（））;
			list.add（map）;
		}
		for?（Map?map2?:?list）?{
			System.out.println（map2.get（“id“））;
		}
		
		mapall.put（“rows“list）;		
		mapall.put（“total“?count）;
?	
		System.out.println（JSONobject.fromobject（mapall）.toString（））;
		return?mapall;????
?????}
	
	public?Mapject>?PagesManagerDept（String?nameint?currentPageint?pageNums）{
//		if?（name==null||name==““）?{
//			name=“renshi“;
//		}
		List?listapp;
		int?count;
		Depts?ds=?new?Depts（）;
		ds.setDname（name）;
		ds.setCurrentPage（currentPage）;
		ds.setPageNums（pageNums）;
		listapp=usersMappler.SelectUser2（ds）;
		count=usersMapp

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-12-10?14:22??manage\
?????文件?????????767??2017-12-10?13:57??manage\.classpath
?????文件?????????906??2017-08-11?11:12??manage\.project
?????目錄???????????0??2017-12-10?14:22??manage\.settings\
?????文件?????????567??2017-08-11?11:12??manage\.settings\.jsdtscope
?????文件?????????670??2017-12-10?15:02??manage\.settings\org.eclipse.jdt.core.prefs
?????文件?????????470??2017-08-13?20:49??manage\.settings\org.eclipse.wst.common.component
?????文件?????????307??2017-12-09?22:05??manage\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-08-11?11:12??manage\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-08-11?11:12??manage\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-12-10?14:22??manage\build\
?????目錄???????????0??2017-12-21?21:51??manage\build\classes\
?????目錄???????????0??2017-12-21?21:51??manage\build\classes\com\
?????目錄???????????0??2017-12-21?21:51??manage\build\classes\com\manage\
?????目錄???????????0??2017-12-21?21:51??manage\build\classes\com\manage\control\
?????文件???????10514??2017-12-21?21:51??manage\build\classes\com\manage\control\UsersModel.class
?????目錄???????????0??2017-12-21?21:51??manage\build\classes\com\manage\entity\
?????文件????????2388??2017-12-21?21:51??manage\build\classes\com\manage\entity\Depts.class
?????文件????????2192??2017-12-21?21:51??manage\build\classes\com\manage\entity\Positions.class
?????文件????????4018??2017-12-21?21:51??manage\build\classes\com\manage\entity\Users.class
?????目錄???????????0??2017-12-21?21:51??manage\build\classes\com\manage\mapper\
?????文件????????1222??2017-12-21?21:51??manage\build\classes\com\manage\mapper\IUsersMappler.class
?????目錄???????????0??2017-12-21?21:51??manage\build\classes\com\manage\mybatis\
?????文件????????1060??2017-11-01?22:31??manage\build\classes\com\manage\mybatis\mysql-config.xml
?????文件????????1382??2017-12-21?21:51??manage\build\classes\com\manage\mybatis\MysqlMyabitsSessionFactory.class
?????文件????????6266??2017-08-22?19:58??manage\build\classes\com\manage\mybatis\userSql.xml
?????目錄???????????0??2017-12-21?21:51??manage\build\classes\com\manage\servlet\
?????文件????????3250??2017-12-21?21:51??manage\build\classes\com\manage\servlet\caiwu2Servlet.class
?????文件????????2232??2017-12-21?21:51??manage\build\classes\com\manage\servlet\caiwuServlet.class
?????文件????????2921??2017-12-21?21:51??manage\build\classes\com\manage\servlet\DeleteServlet.class
?????文件????????2172??2017-12-21?21:51??manage\build\classes\com\manage\servlet\DeptListServlet.class
............此處省略1250個文件信息