userinfoserver.java

该项目采用Struts框架

package com.cattsoft.dao;

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

import com.cattsoft.vo.User;

public interface UserInfoServer {
	//新增用户
	public int addUser(User user) throws ClassNotFoundException, SQLException;
	//根据用户名查询用户详细信息
	public List<User> queryAll(String uname) throws ClassNotFoundException, SQLException;
	//根据用户名、密码、角色去查询用户信息
	public boolean queryBy(String username,String password,String role_id) throws ClassNotFoundException, SQLException;
	//根据用户名查询其姓名
	public String queryNameBy(String username) throws ClassNotFoundException, SQLException;
	//根据用户名查询其用户id
	public int queryUserIdBy(String username) throws ClassNotFoundException, SQLException;
	//查询所有的用户信息
	public List<User> queryAll() throws ClassNotFoundException, SQLException;
	//根据用户id删除对应的所有信息
	public void deleteUser(int user_id) throws ClassNotFoundException, SQLException;
	//根据用户名判断是否已经存在
	public boolean queryBy(String uname) throws ClassNotFoundException, SQLException;
	//查询所有的员工信息
	public List<User> queryAllEmployee() throws ClassNotFoundException, SQLException;
	//查询所有主管id和姓名
	public List<User> queryAllManager() throws ClassNotFoundException, SQLException;
	//根据用户id和主管id更新对应的用户信息
	public void update(int user_id,int managerId,String manager_name) throws ClassNotFoundException, SQLException;
	//根据主管id查询主管姓名
	public String queryBy(int managerId) throws ClassNotFoundException, SQLException;	
}