userservice.java

基于MVC模式的文章采集检索系统

package com.liubin.service.user;
import java.util.*;
import com.liubin.database.*;
import java.sql.*;
import java.util.*;
import com.liubin.model.Department;
import com.liubin.database.JdbcBean;
import com.liubin.model.User;
import com.liubin.model.Level;
import com.liubin.model.Role;

public class UserService {
	public User IsUSerByName(String name, String password) {
		JdbcBean bean = new JdbcBean();
		ResultSet rs = null;
		User user = null;
		String sql = "select * from t_user where name='" + name + "'";
		rs = bean.query(sql);

		try {
			if (rs.next()) {
				user = new User();

				user.setId(rs.getString("id"));
				user.setName(rs.getString("name"));
				user.setPassword(rs.getString("password"));
				user.setDepartment_id(rs.getInt("department_id"));
				user.setAddress(rs.getString("address"));
				user.setAdmin_flag(rs.getString("admin_flag"));
				user.setLevel_id(rs.getInt("level_id"));
				user.setRole_id(rs.getInt("role_id"));
				user.setSex(rs.getString("sex"));
				user.setTelephone(rs.getString("telephone"));
				user.setEmail(rs.getString("email"));

			}

			rs.close();
		} catch (SQLException e) {
			System.out.println("asdf");
		} finally {

			bean.close();
		}
		return user;
	}
	
	public static void main(String ss[])
	{
		
	List arr=	new UserService().getAllDepartment();
	

	}
	public List<Department> getAllDepartment()
	{
		List<Department> list=new ArrayList<Department>();
		JdbcBean bean=new JdbcBean();
		ResultSet rs=null;
		String sql="select * from t_department";
		rs=bean.query(sql);
		try{
				while(rs.next()){
				Department dpt=new Department();
				dpt.setDepartment_id(rs.getInt("department_id"));
				dpt.setDepartment_name(rs.getString("department_name"));
				list.add(dpt);
				}
			}catch(Exception e){
				
			}
			
		return list;
	}
	public List<Level> getAllLevel()
	{
		List<Level> list=new ArrayList<Level>();
		JdbcBean bean=new JdbcBean();
		ResultSet rs=null;
		String sql="select * from t_level";
		rs=bean.query(sql);
		try{
				while(rs.next()){
				Level level=new Level();
				level.setLevel_id(rs.getInt("level_id"));
				level.setLevel_name(rs.getString("level_name"));
				list.add(level);
				}
			}catch(Exception e){
				
			}
			
		return list;
	}
	public List<Role> getAllRole()
	{
		List<Role> list=new ArrayList<Role>();
		JdbcBean bean=new JdbcBean();
		ResultSet rs=null;
		String sql="select * from t_role_privilege";
		rs=bean.query(sql);
		try{
				while(rs.next()){
				Role role=new Role();
				role.setRole_id(rs.getInt("role_id"));
				role.setRole_name(rs.getString("role_name"));
				list.add(role);
				}
			}catch(Exception e){
				
			}
			
		return list;
	}
	public boolean checkUser(String name)
	{
		boolean temp=true;
		JdbcBean bean=new JdbcBean();
		String sql="select * from t_user where name='"+name+"'";
		System.out.println(sql);
		ResultSet rs=bean.query(sql);
		try{
			if(rs.next()){
				temp=false;
			}
			rs.close();
		}
		catch(Exception e ){
			
			
		}
		
		finally{
			bean.close();
		}
		System.out.print(temp);
		return temp;
	}
	
	public List<User> getAllUser() {
		String sql = "select * from t_user";
		List<User> list = new ArrayList<User>();
		try {
			ResultSet rs = new JdbcBean().query(sql);
			while (rs.next()) {
				System.out.print("01-----------------");
				User user = new User();
				user.setId(rs.getString("id"));
				user.setName(rs.getString("name"));
				user.setPassword(rs.getString("password"));
				user.setAddress(rs.getString("address"));
				user.setAdmin_flag(rs.getString("admin_flag"));
				user.setDepartment_id(rs.getInt("department_id"));
				user.setEmail(rs.getString("email"));
				user.setLevel_id(rs.getInt("level_id"));
				user.setRole_id(rs.getInt("role_id"));
				user.setSex(rs.getString("sex"));
				user.setTelephone(rs.getString("telephone"));
				list.add(user);
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

	public int inserUser(User user) {
		String sql = "insert into t_user values('" + user.getId() + "','"
				+ user.getName() + "','" + user.getPassword() + "',"
				+ user.getDepartment_id() + ",'" + user.getSex() + "','"
				+ user.getAddress() + "','" + user.getTelephone() + "','"
				+ user.getEmail() + "','" + user.getAdmin_flag() + "',"
				+ user.getLevel_id() + "," + user.getRole_id() + ")";
		System.out.println(sql);
		JdbcBean bean = new JdbcBean();
		int temp = bean.update(sql);
		System.out.println(temp);
		bean.close();
		return temp;
	}

	public int updateUser(User user) {
		String sql = "update t_user set name='" + user.getName()
				+ "',password='" + user.getPassword() + "',department_id="
				+ user.getDepartment_id() + ",sex='" + user.getSex()
				+ "',address='" + user.getAddress() + "',telephone='"
				+ user.getTelephone() + "',email='" + user.getEmail()
				+ "',admin_flag='" + user.getAdmin_flag() + "',level_id="
				+ user.getLevel_id() + ",role_id=" + user.getRole_id()
				+ " where id='" + user.getId()+"'";
		System.out.println(sql);
		JdbcBean bean = new JdbcBean();
		int temp = bean.update(sql);
		bean.close();
		return temp;
	}

	public User getUserById(String id){
		User user=null;
		JdbcBean bean=new JdbcBean();
		String sql="select * from t_user where id='"+id+"'";
		ResultSet rs=bean.query(sql);
		System.out.println(sql);
		try{

			while(rs.next()){
				user=new User();
				user.setId(rs.getString("id"));
				user.setName(rs.getString("name"));
				user.setPassword(rs.getString("password"));
				user.setAddress(rs.getString("address"));
				user.setAdmin_flag(rs.getString("admin_flag"));
				user.setDepartment_id(rs.getInt("department_id"));
				user.setEmail(rs.getString("email"));
				user.setLevel_id(rs.getInt("level_id"));
				user.setRole_id(rs.getInt("role_id"));
				user.setSex(rs.getString("sex"));
				user.setTelephone(rs.getString("telephone"));
			}
		rs.close();
		}
		catch(Exception e){
			System.out.println("异常错误");
			e.printStackTrace();
		}
		bean.close();
		return user;
	}

	
	public void deleteUsersByIds(String[] ids)
	{	
		StringBuffer buffer=new StringBuffer("delete from t_user where 1=2");
		for(int i=0;i<ids.length;i++){
			buffer.append(" or id='"+ids[i]+"'");
		}
		String sql=buffer.toString();
		JdbcBean bean=new JdbcBean();
		bean.update(sql);
	}
	
	
	public String getLevel(int n)
	{
		ResultSet rs=null;
		String sql="select * from t_level where level_id="+n;
		JdbcBean bean=new JdbcBean();
		String temp=null;
		rs=bean.query(sql);
		try{
			rs.next();
			temp=rs.getString("level_name");
			return temp;
			}
		catch(Exception e){
			e.printStackTrace();
		}
		return temp;
	}
	public String getDepatement(int n)
	{
		ResultSet rs=null;
		String sql="select * from t_department where department_id="+n;
		JdbcBean bean=new JdbcBean();
		String temp=null;
		rs=bean.query(sql);
		try{
			rs.next();
			temp=rs.getString("department_name");
			return temp;
			}
		catch(Exception e){
			e.printStackTrace();
		}
		return temp;
	}
	public String getRole(int n)
	{
		ResultSet rs=null;
		String sql="select * from t_role_privilege where role_id="+n;
		JdbcBean bean=new JdbcBean();
		String temp=null;
		rs=bean.query(sql);
		try{
			rs.next();
			temp=rs.getString("role_name");
			return temp;
			}
		catch(Exception e){
			
			e.printStackTrace();
		}
		return temp;
	}
	public int getPageCount(){
		JdbcBean bean=new JdbcBean();
		String sql="select count(*) as total from t_user";
		System.out.println(sql);
		ResultSet rs=null;
		try {
			rs=bean.query(sql);
			if(rs.next())
				return rs.getInt("total");
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		bean.close();
		return -1;
	}
	public ArrayList<User> getUserByPage(int page){
		User user=null;
		ArrayList<User> list=new ArrayList<User>();
		JdbcBean bean=new JdbcBean();
		String sql=null;
		sql="select * from(select id,name,password,department_id,sex,address,telephone,email,admin_flag,level_id,role_id,row_number() over(order by id)as num from t_user)as tb where admin_flag='N' and num between "+(5*(page-1)+1)+" and "+(5*(page));  
		ResultSet rs=bean.query(sql);
		System.out.println(sql);
		try{

			while(rs.next()){
				user=new User();
				user.setId(rs.getString("id"));
				user.setName(rs.getString("name"));
				user.setPassword(rs.getString("password"));
				user.setAddress(rs.getString("address"));
				user.setAdmin_flag(rs.getString("admin_flag"));
				user.setDepartment_id(rs.getInt("department_id"));
				user.setEmail(rs.getString("email"));
				user.setLevel_id(rs.getInt("level_id"));
				user.setRole_id(rs.getInt("role_id"));
				user.setSex(rs.getString("sex"));
				user.setTelephone(rs.getString("telephone"));
				list.add(user);
			}
		rs.close();
		return list;
		}
		catch(Exception e){
			System.out.println("异常错误");
			e.printStackTrace();
		}
		bean.close();
		return list;
	}
}