📄 userbo.java
字号:
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return fal;
}
// 修改管理员权限
public static boolean alterMasterInfo(String id,boolean a){
//
boolean flag=false;
String sql=null;
if(a){
sql="update t_employee set f_power='管理员'"+" where f_id='"+id+"'";
try {
int i=ConnData.conn().createStatement().executeUpdate(sql);
if(i==0){
flag=false;
}else{
flag=true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null){
rs.close();
}if(ConnData.co!=null){
ConnData.co.close();}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}else{
sql="update t_employee set f_power='普通员工'"+" where f_id='"+id+"'";
try {
int i=ConnData.conn().createStatement().executeUpdate(sql);
if(i==0){
flag=false;
}else{
flag=true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null){
rs.close();
}if(ConnData.co!=null){
ConnData.co.close();}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return flag;
}
//按ID查询管理员信息
public static ArrayList selectＭanager_id(String id)
{
ArrayList list = new ArrayList();
String sql="select * from t_employee where f_id='"+id+"' f_power='管理员'";
try {
rs=ConnData.conn().createStatement().executeQuery(sql);
if(rs.next())
{
Vector v = new Vector();
v.add(rs.getString(1));
v.add(rs.getString(2));
v.add(rs.getString(3));
v.add(rs.getString(4));
v.add(rs.getString(5));
v.add(rs.getString(6));
v.add(rs.getString(7));
v.add(rs.getString(8));
v.add(rs.getString(9));
v.add(rs.getString(10));
v.add(rs.getString(11));
v.add(rs.getString(12));
v.add(rs.getString(13));
v.add(rs.getString(14));
list.add(v);
}else
{
Vector v = new Vector();
v.add("F");
list.add(v);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null){
rs.close();
}if(ConnData.co!=null){
ConnData.co.close();}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}
//获取所有用户的信息
public static Vector userAllInfo()
{
Vector str = new Vector();
ResultSet rs = null;
try {
rs=ConnData.conn().createStatement().executeQuery("select * from t_employee");
while(rs.next())
{
Vector v=new Vector();
v.addElement(rs.getString(1).trim());
v.addElement(rs.getString(2).trim());
v.addElement(rs.getString(6).trim());
v.addElement(rs.getString(5).trim());
v.addElement(rs.getString(4).trim());
v.addElement(rs.getString(7).trim());
v.addElement(rs.getString(8).trim());
v.addElement(rs.getString(9).trim());
v.addElement(rs.getString(10).trim());
v.addElement(rs.getString(13).trim());
v.addElement(rs.getString(14).trim());
str.addElement(v);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null)rs.close();
if(ConnData.co!=null)
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return str;
}
// 获取所有普通管理员的信息
public static Vector masterAllInfo()
{
Vector str = new Vector();
ResultSet rs = null;
try {
rs=ConnData.conn().createStatement().executeQuery("select * from t_employee where f_power='管理员'");
while(rs.next())
{
Vector v=new Vector();
v.addElement(rs.getString(1).trim());
v.addElement(rs.getString(2).trim());
v.addElement(rs.getString(6).trim());
v.addElement(rs.getString(5).trim());
v.addElement(rs.getString(4).trim());
v.addElement(rs.getString(7).trim());
v.addElement(rs.getString(8).trim());
v.addElement(rs.getString(9).trim());
v.addElement(rs.getString(10).trim());
v.addElement(rs.getString(13).trim());
v.addElement(rs.getString(14).trim());
str.addElement(v);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null)rs.close();
if(ConnData.co!=null)
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return str;
}
public static ArrayList userinfo(String name)//根据部门获取用户
{
ResultSet rs = null;
ArrayList vector=new ArrayList();
try {
rs=ConnData.conn().createStatement().executeQuery("select f_name,f_headerpic from t_employee where f_deptName='"+name+"'");
while(rs.next())
{
String[] str=new String[2];
str[0]=rs.getString(1);
str[1]=rs.getString(2);
vector.add(str);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null)rs.close();
if(ConnData.co!=null)
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return vector;
}
public static Vector masterLogin(String id,String pwd)//普通管理员登陆
{
Vector vector=new Vector();
ResultSet rs = null;
String sql="select * from t_employee where f_power='管理员'";
try {
rs=ConnData.conn().createStatement().executeQuery(sql);
while(rs.next())
{
if(rs.getString(3).trim().equals(pwd.trim())&&rs.getString(1).trim().equals(id.trim()))
{
vector.add(rs.getString(1).trim());
vector.add(rs.getString(2).trim());
vector.add(rs.getString(4).trim());
vector.add(rs.getString(5).trim());
vector.add(rs.getString(6).trim());
vector.add(rs.getString(7).trim());
vector.add(rs.getString(8).trim());
vector.add(rs.getString(9).trim());
vector.add(rs.getString(10).trim());
vector.add(rs.getString(12).trim());
vector.add(rs.getString(13).trim());
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null)rs.close();
if(ConnData.co!=null)
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(vector.size()==0)
{
vector.addElement("false");
}
return vector;
}
public static String[] userhead(String id){//返回用户信息
String [] str=new String[14];
try {
rs=ConnData.conn().createStatement().executeQuery("select * from t_employee where f_id='"+id+"'");
if(rs.next()){
str[0]=rs.getString(1);
str[1]=rs.getString(2);
str[2]=rs.getString(3);
str[3]=rs.getString(4);
str[4]=rs.getString(5);
str[5]=rs.getString(6);
str[6]=rs.getString(7);
str[7]=rs.getString(8);
str[8]=rs.getString(9);
str[9]=rs.getString(10);
str[10]=rs.getString(11);
str[11]=rs.getString(12);
str[12]=rs.getString(13);
str[13]=rs.getString(14);
}else
{
str[0]="F";
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
UserBO.rs.close();
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return str;
}
public static Vector userLogin(String id,String pwd)//用户登陆
{
Vector vector=new Vector();
ResultSet rs = null;
String sql="select * from t_employee";
try {
rs=ConnData.conn().createStatement().executeQuery(sql);
while(rs.next())
{
if(rs.getString(3).trim().equals(pwd.trim())&&rs.getString(1).trim().equals(id.trim()))
{
vector.add(rs.getString(1).trim());
vector.add(rs.getString(2).trim());
vector.add(rs.getString(4).trim());
vector.add(rs.getString(5).trim());
vector.add(rs.getString(6).trim());
vector.add(rs.getString(7).trim());
vector.add(rs.getString(8).trim());
vector.add(rs.getString(9).trim());
vector.add(rs.getString(10).trim());
vector.add(rs.getString(12).trim());
vector.add(rs.getString(13).trim());
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null)rs.close();
if(ConnData.co!=null)
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(vector.size()==0)
{
vector.addElement("false");
}
return vector;
}
public static void updateLine(String id,boolean fal)//修改用户的状态
{
String sql="";
if(fal)//设置在线
{
sql="update t_employee set f_line='在线' where f_id='"+id+"'";
}else
sql="update t_employee set f_line='不在线' where f_id='"+id+"'";
try {
int i=ConnData.conn().createStatement().executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -