📄 userbo.java
字号:
package edu.sccp.chat.bo;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Vector;
import edu.sccp.chat.dao.ConnData;
public class UserBO {
public static ResultSet rs;
public static PreparedStatement stat;
// 删除用户信息的方法
public static boolean alldeletata(String id){
boolean flag=false;
String sql="delete from t_employee where f_id='"+id+"'";
try {
int i= ConnData.conn().createStatement().executeUpdate(sql);
if(i==0){
flag=false;
}else{
flag=true;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return flag;
}
// 修改用户的某写信息
public static boolean alterUserInfo1(String id,String name,String position,String sex,String date,String tel,String mail,String headpic,String remark){
boolean flag=false;
String sql="update t_employee set f_name='"+name +"',f_position='"+position+"',f_sex='"+sex+"',f_jion=to_date('"+date+"','yyyy-MM-dd'),f_tel='"+tel+"',f_mail='"+mail+"',f_headerpic='"+headpic+"',f_remark='"+remark+"' 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();
}
return flag;
}
//修改个人信息
public static boolean alterselInfo(String id,String name,String tel,String mail,String headpic,String remark){
boolean flag=false;
String sql="update t_employee set f_name='"+name +"',f_tel='"+tel+"',f_mail='"+mail+"',f_headerpic='"+headpic+"',f_remark='"+remark+"' 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();
}
return flag;
}
public static String[] masterhead(String id){//返回普通管理员信息
String [] str=new String[14];
try {
rs=ConnData.conn().createStatement().executeQuery("select * from t_employee where f_id='"+id+"' and f_power='管理员'");
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 String[] logionSelect(String id,char[] pwd)//服务器登陆身份验证
{
String str[] = new String[2];
String password="";
ResultSet rs = null;
for(int i=0;i<pwd.length;i++)
password=password+pwd[i];
String sql="select f_id,f_pwd,f_name from t_boss";
try {
stat=ConnData.conn().prepareStatement(sql);
rs=stat.executeQuery();
rs.next();
if(rs.getString(2).trim().equals(password)&&rs.getString(1).trim().equals(id))
{
str[0]="T";
str[1]=rs.getString(3);
}
else
{
str[0]="F";
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
UserBO.stat.close();
if(rs!=null)rs.close();
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return str;
}
// 插入用户信息
public static int insertInfo(String id,String name,String pwd,String position,String dept,String sex,String birth,String tel,String email,String headpic,String remark){
SimpleDateFormat sim=new SimpleDateFormat("yyyy-MM-dd");
PreparedStatement stat = null;
String jion=sim.format(new Date(System.currentTimeMillis()));//获得当前日期
int i = 0;
String sql="insert into t_employee values('"+id+"','"+name+"','"+pwd+"','"+position+"','"+dept+"','"+sex+"',to_date('"+birth+"','yyyy-MM-dd'),to_date('"+jion+"','yyyy-MM-dd'),'"+tel+"','"+email+"','普通员工','"+headpic+"','"+remark+"','不在线')";
try {
stat=ConnData.conn().prepareStatement(sql);
i=stat.executeUpdate();//如果I返回1则添加成功，返回0则不成功
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
stat.close();
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return i;
}
//查询所有管理员
public ArrayList selectallＭanager()
{
ArrayList list=null;
String sql="select * from t_employee where f_power='管理员'";
try {
rs=ConnData.conn().createStatement().executeQuery(sql);
while(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);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
// 修改用户信息
public static boolean alterUserInfo(String id,String name,String sex,String deptname,String position,String tel,String mail,String date,String remark,String headpic){
boolean flag=false;
String sql="update t_employee set f_name='"+name +"',f_sex='"+sex+"',f_deptname='"+deptname+"',f_position='"+position+"',f_tel='"+tel+"',f_mail='"+mail+"',f_jion=to_date('"+date+"','yyyy-MM-dd'),f_headerpic='"+headpic+"',f_remark='"+remark+"' 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();
}
return flag;
}
// 查询所有用户信息
public ArrayList selectalluser()
{
ArrayList list=null;
String sql="select * from t_employee where f_power='普通员工'";
try {
rs=ConnData.conn().createStatement().executeQuery(sql);
while(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);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
//修改服务器自身密码
public static boolean updatePassword(String id,String pwd,String newpwd)
{
boolean fal=false;
ResultSet rs = null;
String sql="select f_pwd from t_boss where f_id='"+id+"'";
try {
stat=ConnData.conn().prepareStatement(sql);
rs=stat.executeQuery();
rs.next();
if(rs.getString(1).trim().equals(pwd))
{
sql="update t_boss set f_pwd='"+newpwd+"' where f_id='"+id+"'";
stat=ConnData.conn().prepareStatement(sql);
int i=stat.executeUpdate();
if(i==1)
{
fal=true;
}else
{
fal=false;
}
}
else
{
fal=false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
UserBO.stat.close();
if(rs!=null)rs.close();
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return fal;
}
// 修改用户自身密码
public static boolean updatePassword1(String id,String pwd,String newpwd)
{
boolean fal=false;
ResultSet rs = null;
String sql="select f_pwd from t_employee where f_id='"+id+"'";
try {
stat=ConnData.conn().prepareStatement(sql);
rs=stat.executeQuery();
rs.next();
if(rs.getString(1).trim().equals(pwd))
{
sql="update t_employee set f_pwd='"+newpwd+"' where f_id='"+id+"'";
stat=ConnData.conn().prepareStatement(sql);
int i=stat.executeUpdate();
if(i==1)
{
fal=true;
}else
{
fal=false;
}
}
else
{
fal=false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
UserBO.stat.close();
if(rs!=null)rs.close();
ConnData.co.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return fal;
}
//修改别人密码
public static boolean updatePwd(String id,String pwd)
{
boolean fal=false;
System.out.println(pwd);
String sql="update t_employee set f_pwd ='"+pwd+"' where f_id='"+id+"'";
try {
stat=ConnData.conn().prepareStatement(sql);
int i=stat.executeUpdate();
if(i==1)
{
fal=true;
}else
{
fal=false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
UserBO.stat.close();
ConnData.co.close();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -