用Java写一个公司员工管理系统!

用Java写一个公司员工管理系统!

今天看CSDN发现写管理系统的文章不少,我在这里也给大家用java写一篇!(当然这里只是最简单的那种qwq)

核心功能:对员工各项信息的管理
采用属性文件+资源文件(支持中文简体和英文)

目录

  • 第一步:创建一个记录员工信息的文件
  • 第二步:循环处理输入的信息
  • 第三步:用类及框架来完成对员工内容的管理

程序总体
图片

事不宜迟,现在就开始吧!


先创建一个Member类

package 管理;

public class Member  {
	private String name;                               
	private String money;
	private String post;
	public Member(String name,String money,String post) {
		this.name = name;
		this.money = money;
		this.post = post;
	}
	@Override
	public boolean equals(Object obj) {         //完成员工删除和查询的必要方法
		if (this == obj) {
			return true;
		}
		if (obj == null) {
			return false;
		}
		if (!(obj instanceof Member)) {
			return false;
		}
		Member mem = (Member) obj;
		return this.name.equals(mem.name) && this.money.equals(mem.money) && this.post.equals(mem.post);
	}
 	public String toString() {                 //输出员工信息的方法
		return this.name + ":" + this.money + ":" + this.post + "|";
	}
}



为了使程序更加流畅,再加一个垃圾处理的线程Optimization

package 管理;

public class Optimization extends Thread {
	private String title;
	private int number;
	private int wait;
	public Optimization(String title,int number,int wait) {
		this.title = title;
		this.number = number;
		this.wait = wait;
	}
	@Override
	public void run() {
		Runtime runtime =Runtime.getRuntime();
		System.out.println("[IO]name:" + this.title + ",member:" + this.number);
		while (true) {
			runtime.gc();
			try {
			     Thread.currentThread().sleep(this.wait);
				
			} catch (InterruptedException e) {
				e.printStackTrace();
			}
		}
	}
}


最后创建主类 ManagementSystem

package 管理;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;
import java.util.ResourceBundle;
import java.util.Scanner;


public class ManagementSystem {
	public static void main(String args[]) throws Exception{
		ResourceBundle resource = ResourceBundle.getBundle("管理.config");
		System.out.println(resource.getString("info.1"));
		new Optimization("Optimization",10,10000).start();
		System.out.println(resource.getString("info.2"));
		List<Member> all = new ArrayList<Member>();
		System.out.println(resource.getString("info.3"));
		File file = new File("./managementsystem");
		File read = new File("./managementsystem/info.txt");
		System.out.println(resource.getString("info.4"));
		if (file.exists()) {
			if (read.exists()) {
				try {
				System.out.println(resource.getString("info.5"));
				InputStream input = new FileInputStream(read);
				byte data [] = input.readAllBytes();
				String str = new String(data);
				String result[] =str.split("\\|");
				     for (int x = 0; x < result.length; x ++) {
					       String temp[] = result[x].split(":");
					       all.add(new Member(temp[0], temp[1], temp[2]));
				     }
				} catch(Exception e) {
					if (read.exists()) {
					     read.delete();
					}
					System.out.println(resource.getString("info.6"));
					System.exit(1);				
				}
				System.out.println(resource.getString("info.7"));
			} else {
				System.out.println(resource.getString("info.8"));
				read.createNewFile();
				System.out.println(resource.getString("info.9"));
				all.add(new Member("try" , "0", "try"));
			}
		} else {
			file.mkdir();
			System.out.println(resource.getString("info.8"));
			read.createNewFile();
			System.out.println(resource.getString("info.9"));
			all.add(new Member("try" , "0", "try"));
		}
		PrintWriter pu = new PrintWriter(new FileOutputStream(read));
		System.out.println(resource.getString("info.10"));
		System.out.println(resource.getString("info.11"));
		while (true) {
			System.out.println(resource.getString("info.12"));
			Scanner scanner = new Scanner(System.in);
			int i = scanner.nextInt();
			int n = 0;
		try {	
	    switch (i) {
	            case 0:
	            	System.out.print(resource.getString("info.13"));
	            	break;
			    case 1:
	            	System.out.print(resource.getString("info.14"));
	            	Scanner scanner1 = new Scanner(System.in);
	            	String name = scanner.next();
	            	System.out.print(resource.getString("info.25"));
	            	Scanner scanner2 = new Scanner(System.in);
	            	String member = scanner.next();
	            	System.out.print(resource.getString("info.26"));
	            	Scanner scanner3 = new Scanner(System.in);
	            	String card = scanner.next();
	            	all.add(new Member(name, member, card));
	            	System.out.println(resource.getString("info.27"));
	            	break;
			    case 2:
			    	System.out.print(resource.getString("info.15"));
	            	Scanner scanner11 = new Scanner(System.in);
	            	String name1 = scanner.next();
	            	System.out.print(resource.getString("info.25"));
	            	Scanner scanner12 = new Scanner(System.in);
	            	String member1 = scanner.next();
	            	System.out.print(resource.getString("info.26"));
	            	Scanner scanner13 = new Scanner(System.in);
	            	String card1 = scanner.next();
	            	all.remove(new Member(name1, member1, card1));
	            	System.out.println(resource.getString("info.28"));
	            	break;
			    case 3:
	            	System.out.print(resource.getString("info.16"));
			    	all.forEach(System.out::println);
			    	System.out.print(resource.getString("info.17"));
			    	break;
			    case 4:
			    	System.out.print(resource.getString("info.18"));
	            	Scanner scanner21 = new Scanner(System.in);
	            	String name2 = scanner.next();
	            	System.out.print(resource.getString("info.25"));
	            	Scanner scanner22 = new Scanner(System.in);
	            	String member2 = scanner.next();
	            	System.out.print(resource.getString("info.26"));
	            	Scanner scanner23 = new Scanner(System.in);
	            	String card2 = scanner.next();
	            	if (all.contains(new Member(name2, member2, card2))) {
	            		System.out.println(resource.getString("info.19"));
	            	} else {
	            		System.out.println(resource.getString("info.20"));
	            	}
	            	break;
			    case 5:
			    	System.out.println("=====ManagementSystem=====");
			    	System.out.println("=====author: Yaoboyu======");
			    	System.out.println("===version: beta1.00.1====");
			    	System.out.println("=====language: zh_CN======");
			    	System.out.println("==Thanks for using this!==");
			    	break;
			    case 6:
			    	System.out.println(resource.getString("info.22"));
			    	all.forEach(pu::print);
			    	pu.close();
			    	System.out.println(resource.getString("info.23"));
			    	System.out.println(resource.getString("info.24"));
			    	System.exit(i);
	          } 	
		      }  catch(Exception e) {
		    	  break;
		      }
		
	    }
    }
}

资源文件[这里就只放中文的哈!]:

info.1=[System]初始化中…
info.2=[System]优化线程启动成功!
info.3=[System]类及框架模块启动成功!
info.4=[System]IO读取流模块启动成功!
info.5=[IO]读取文件中…
info.6=检测到一个错误![建议:删除配置文件重新启动]
info.7=[IO]读取完成!
info.8=[IO]检测到未创建存档,正在创建存档!
info.9=[IO]创建成功![请勿随意更改配置文件!否则后果自负!]
info.10=[System]IO打印流模块启动成功!\n[System]初始化完成!
info.11=欢迎来到员工管理系统
info.12=请输入指令[输入0查询指令]
info.13=\n帮助\n1-添加员工\n2-删除员工\n3-获取全部员工信息\n4-查询员工是否存在\n5-获取程序信息\n6-退出程序\n================\n
info.14=添加员工\n请输入名称:
info.15=删除员工\n请输入名称:
info.16=输出所有数据\n员工名:员工工资:员工职务
info.17=完毕\n\n
info.18=查询员工\n请输入名称:
info.19=此员工存在!
info.20=此员工不存在!
info.21=请输入目标地址:
info.22=保存中…
info.23=关闭中…
info.24=关闭成功!
info.25=请输入工资:
info.26=请输入职位:
info.27=创建成功!
info.28=完成!

资源文件也都在下面的整合文件中

站内下载地址:点我!
源码下载地址(站外):别点他,点我!

新人作者,多多支持哈!
一键三连!

  • 8
    点赞
  • 56
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
package com.wsy.dao; import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Timestamp; import java.util.ArrayList; import java.util.List; import com.wsy.model.Back; import com.wsy.model.BookInfo; import com.wsy.model.BookType; import com.wsy.model.Borrow; import com.wsy.model.Operater; import com.wsy.model.Order; import com.wsy.model.OrderAndBookInfo; import com.wsy.model.Reader; import com.wsy.model.user; public class Dao { protected static String dbClassName = "com.mysql.jdbc.Driver"; protected static String dbUrl = "jdbc:mysql://localhost:3306/mysql"; protected static String dbUser = "root"; protected static String dbPwd = ""; protected static String second = null; private static Connection conn = null; private Dao() { try { if (conn == null) { Class.forName(dbClassName); conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd); } else return; } catch (Exception ee) { ee.printStackTrace(); } } private static ResultSet executeQuery(String sql) { try { if(conn==null) new Dao(); return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); return null; } finally { } } private static int executeUpdate(String sql) { try { if(conn==null) new Dao(); return conn.createStatement().executeUpdate(sql); } catch (SQLException e) { System.out.println(e.getMessage()); //if(e.getMessage().equals("[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]DELETE 语句与 COLUMN REFERENCE 约束 'FK_TB_BORRO_REFERENCE_TB_BOOKI' 冲突。该冲突发生于数据库 'db_library',表 'tb_borrow', column 'bookISBN'。")) return -1; } finally { } } public static void close() { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); }finally{ conn = null; } } /* * 管理员登录方法 */ public static Operater check(String name, String password) { int i = 0; Operater operater=new Operater(); String sql = "select * from tb_operator where name='" + name + "' and password='" + password + "'and admin=1"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { String names = rs.getString(1); operater.setId(rs.getString("id")); operater.setName(rs.getString("name")); operater.setGrade(rs.getString("admin")); operater.setPassword(rs.getString("password")); if (names != null) { i = 1; } } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return operater; } /* * 查询类别方法 */ public static List selectBookCategory() { List list=new ArrayList(); String sql = "select * from tb_bookType"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { BookType bookType=new BookType(); bookType.setId(rs.getString("id")); bookType.setTypeName(rs.getString("typeName")); bookType.setDays(rs.getString("days")); bookType.setFk(rs.getString("fk")); list.add(bookType); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static List selectBookCategory(String bookType) { List list=new ArrayList(); String sql = "select days from tb_bookType where typeName='"+bookType+"'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { BookType type=new BookType(); type.setDays(rs.getString("days")); list.add(type); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } /* * 图书类别表相关操作 * */ public static int InsertBookType(String bookTypeName,String days,Double fk){ int i=0; try{ String sql="insert into tb_bookType(typeName,days,fk) values('"+bookTypeName+"','"+days+"',"+fk+")"; i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } return i; } public static int UpdatebookType(String id,String typeName,String days,String fk){ int i=0; try{ String sql="update tb_bookType set typeName='"+typeName+"',days='"+days+"',fk='"+fk+"' where id='"+id+"'"; //System.out.println(sql); i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } // public static int DelbookType(String id){ // int i=0; // try{ // String sql="delete from tb_bookType where id='"+id+"'"; // //System.out.println(sql); // i=Dao.executeUpdate(sql); // }catch(Exception e){ // e.printStackTrace(); // } // Dao.close(); // return i; // } public static List selectBookTypeFk(String bookType) {//取每种书超过规定时间罚款金额 List list=new ArrayList(); String sql = "select * from tb_bookType where typeName='"+bookType+"'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { BookType type=new BookType(); type.setFk(rs.getString("fk")); type.setDays(rs.getString("days")); list.add(type); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } /* * 图书信息表相关操作 */ /* * 插入图书信息方法 */ public static int Insertbook(String ISBN,String typeId,String bookname,String writer,String translator,String publisher,Date date,Double price){ int i=0; try{ String sql="insert into tb_bookInfo(ISBN,typeId,bookname,writer,translator,publisher,date,price) values('"+ISBN+"','"+typeId+"','"+bookname+"','"+writer+"','"+translator+"','"+publisher+"','"+date+"',"+price+")"; //System.out.println(sql); i=Dao.executeUpdate(sql); }catch(Exception e){ System.out.println(e.getMessage()); } Dao.close(); return i; } /* * 查询图书相关信息 * */ public static List selectBookInfo() { List list=new ArrayList(); String sql = "select * from tb_bookInfo"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { BookInfo bookinfo=new BookInfo(); bookinfo.setISBN(rs.getString("ISBN")); bookinfo.setTypeid(rs.getString("typeid")); bookinfo.setBookname(rs.getString("bookname")); bookinfo.setWriter(rs.getString("writer")); bookinfo.setTranslator(rs.getString("translator")); bookinfo.setPublisher(rs.getString("publisher")); bookinfo.setDate(rs.getDate("date")); bookinfo.setPrice(rs.getDouble("price")); list.add(bookinfo); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static List selectBookInfo(String ISBN) { List list=new ArrayList(); String sql = "select * from tb_bookInfo where ISBN='"+ISBN+"'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { BookInfo bookinfo=new BookInfo(); bookinfo.setISBN(rs.getString("ISBN")); bookinfo.setTypeid(rs.getString("typeid")); bookinfo.setBookname(rs.getString("bookname")); bookinfo.setWriter(rs.getString("writer")); bookinfo.setTranslator(rs.getString("translator")); bookinfo.setPublisher(rs.getString("publisher")); bookinfo.setDate(rs.getDate("date")); bookinfo.setPrice(rs.getDouble("price")); list.add(bookinfo); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } /* * 修改图书信息方法 */ public static int Updatebook(String ISBN,String typeId,String bookname,String writer,String translator,String publisher,Date date,Double price){ int i=0; try{ String sql="update tb_bookInfo set ISBN='"+ISBN+"',typeId='"+typeId+"',bookname='"+bookname+"',writer='"+writer+"',translator='"+translator+"',publisher='"+publisher+"',date='"+date+"',price="+price+" where ISBN='"+ISBN+"'"; //System.out.println(sql); i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } // /* // * 删除图书信息方法 // */ // public static int Delbook(String ISBN){ // int i=0; // try{ // String sql="delete from tb_bookInfo where ISBN='"+ISBN+"'"; // //System.out.println(sql); // i=Dao.executeUpdate(sql); // }catch(Exception e){ // e.printStackTrace(); // // } // Dao.close(); // return i; // } /* * 对读者信息表执行的相关操作 */ public static int InsertReader(String name,String sex,String age,String identityCard,Date date,String maxNum,String tel,Double keepMoney,String zj,String zy,Date bztime,String ISBN){ int i=0; try{ String sql="insert into tb_reader(name,sex,age,identityCard,date,maxNum,tel,keepMoney,zj,zy,bztime,ISBN) values('"+name+"','"+sex+"','"+age+"','"+identityCard+"','"+date+"','"+maxNum+"','"+tel+"',"+keepMoney+",'"+zj+"','"+zy+"','"+bztime+"','"+ISBN+"')"; System.out.println(sql); i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } public static List selectReader() { List list=new ArrayList(); String sql = "select * from tb_reader"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { Reader reader=new Reader(); //reader.setId(rs.getString("id")); reader.setName(rs.getString("name")); reader.setSex(rs.getString("sex")); reader.setAge(rs.getString("age")); reader.setIdentityCard(rs.getString("identityCard")); reader.setDate(rs.getDate("date")); reader.setMaxNum(rs.getString("maxNum")); reader.setTel(rs.getString("tel")); reader.setKeepMoney(rs.getDouble("keepMoney")); reader.setZj(rs.getInt("zj")); reader.setZy(rs.getString("zy")); reader.setISBN(rs.getString("ISBN")); reader.setBztime(rs.getDate("bztime")); list.add(reader); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static List selectReader(String readerISBN) { List list=new ArrayList(); String sql = "select * from tb_reader where ISBN='"+readerISBN+"'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { Reader reader=new Reader(); reader.setName(rs.getString("name")); reader.setSex(rs.getString("sex")); reader.setAge(rs.getString("age")); reader.setIdentityCard(rs.getString("identityCard")); reader.setDate(rs.getDate("date")); reader.setMaxNum(rs.getString("maxNum")); reader.setTel(rs.getString("tel")); reader.setKeepMoney(rs.getDouble("keepMoney")); reader.setZj(rs.getInt("zj")); reader.setZy(rs.getString("zy")); reader.setISBN(rs.getString("ISBN")); reader.setBztime(rs.getDate("bztime")); list.add(reader); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static int UpdateReader(String id,String name,String sex,String age,String identityCard,Date date,String maxNum,String tel,Double keepMoney,String zj,String zy,Date bztime,String ISBN){ int i=0; try{ String sql="update tb_reader set name='"+name+"',sex='"+sex+"',age='"+age+"',identityCard='"+identityCard+"',date='"+date+"',maxNum='"+maxNum+"',tel='"+tel+"',keepMoney="+keepMoney+",zj='"+zj+"',zy='"+zy+"',bztime='"+bztime+"'where ISBN='"+ISBN+"'"; i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } public static int DelReader(String ISBN){ int i=0; try{ String sql="delete from tb_reader where ISBN='"+ISBN+"'"; //System.out.println(sql); i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } /* * 对订购信息表操作 */ public static int InsertBookOrder(String ISBN,Date date,String number,String operator,String checkAndAccept,Double zk){ int i=0; try{ String sql="insert into tb_order(ISBN,date,number,operator,checkAndAccept,zk) values('"+ISBN+"','"+date+"','"+number+"','"+operator+"',"+checkAndAccept+",'"+zk+"')"; i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } public static List selectBookOrder() { List list=new ArrayList(); String sql = "SELECT * FROM tb_order a INNER JOIN tb_bookInfo b ON a.ISBN = b.ISBN"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { OrderAndBookInfo order=new OrderAndBookInfo(); order.setISBN(rs.getString(1)); order.setOrderdate(rs.getDate(2)); order.setNumber(rs.getString(3)); order.setOperator(rs.getString(4)); order.setCheckAndAccept(rs.getString(5)); order.setZk(rs.getDouble(6)); order.setTypeId(rs.getString(8)); order.setBookname(rs.getString(9)); order.setWriter(rs.getString(10)); order.setTraslator(rs.getString(11)); order.setPublisher(rs.getString(12)); order.setDate(rs.getDate(13)); order.setPrice(rs.getDouble(14)); list.add(order); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static List selectBookOrder(String ISBN) { List list=new ArrayList(); String sql = "SELECT * FROM tb_order where ISBN='"+ISBN+"'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { Order order=new Order(); order.setISBN(rs.getString("ISBN")); order.setDate(rs.getDate("date")); order.setNumber(rs.getString("number")); order.setOperator(rs.getString("operator")); order.setZk("zk"); order.setCheckAndAccept("checkAndAccept"); list.add(order); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static int UpdateCheckBookOrder(String ISBN){ int i=0; try{ String sql="update tb_order set checkAndAccept=0 where ISBN='"+ISBN+"'"; i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } /* * 对借阅表进行操作 */ public static int InsertBookBorrow(String bookISBN,String readerISBN,String operatorId,Timestamp borrowDate,Timestamp backDate){ int i=0; try{ String sql="insert into tb_borrow(bookISBN,readerISBN,operatorId,borrowDate,backDate)values('"+bookISBN+"','"+readerISBN+"','"+operatorId+"','"+borrowDate+"','"+backDate+"')"; i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } public static List selectBorrow(String readerISBN) { List list=new ArrayList(); String sql = "select * from tb_borrow where readerISBN='"+readerISBN+"'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { Borrow borrow=new Borrow(); borrow.setId(rs.getInt("id")); borrow.setBookISBN(rs.getString("bookISBN")); borrow.setReaderISBN(rs.getString("readerISBN")); borrow.setBorrowDate(rs.getString("borrowDate")); borrow.setBackDate(rs.getString("backDate")); borrow.setBookName(rs.getString("borrowBookName")); list.add(borrow); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } /* * 查询还书内容,tb_bookinfo tb_reader tb_borrow之间的查询 */ public static List selectBookBack(String readerISBN) { List list=new ArrayList(); String sql = "SELECT a.ISBN AS bookISBN, a.bookname, a.typeId ,b.id,b.operatorId, b.borrowDate, b.backDate, c.name AS readerName, c.ISBN AS readerISBN FROM tb_bookInfo a INNER JOIN tb_borrow b ON a.ISBN = b.bookISBN INNER JOIN tb_reader c ON b.readerISBN = c.ISBN WHERE (c.ISBN = '"+readerISBN+"' and isback=1)"; System.out.println(sql); ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { Back back=new Back(); back.setBookISBN(rs.getString("bookISBN")); back.setBookname(rs.getString("bookname")); back.setTypeId(rs.getInt("typeId")); back.setOperatorId(rs.getString("operatorId")); back.setBorrowDate(rs.getString("borrowDate")); back.setBackDate(rs.getString("backDate")); back.setReaderName(rs.getString("readerName")); back.setReaderISBN(rs.getString("readerISBN")); back.setId(rs.getInt("id")); list.add(back); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static int UpdateBookBack(String bookISBN,String readerISBN,int id){//归还图书操作 int i=0; try{ String sql="update tb_borrow set isback=0 where bookISBN='"+bookISBN+"'and readerISBN='"+readerISBN+"' and id="+id+""; System.out.println(sql); i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } //new public static List selectbookserch() { List list=new ArrayList(); String sql = "select * from tb_bookInfo"; ResultSet s = Dao.executeQuery(sql); try { while (s.next()) { BookInfo bookinfo=new BookInfo(); bookinfo.setISBN(s.getString(1)); bookinfo.setTypeid(s.getString(2)); bookinfo.setBookname(s.getString(3)); bookinfo.setWriter(s.getString(4)); bookinfo.setTranslator(s.getString(5)); bookinfo.setPublisher(s.getString(6)); bookinfo.setDate(s.getDate(7)); bookinfo.setPrice(s.getDouble(8)); list.add(bookinfo); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static List selectbookmohu(String bookname){ List list=new ArrayList(); String sql="select * from tb_bookInfo where bookname like '%"+bookname+"%'"; System.out.print(sql); ResultSet s=Dao.executeQuery(sql); try { while(s.next()){ BookInfo bookinfo=new BookInfo(); bookinfo.setISBN(s.getString(1)); bookinfo.setTypeid(s.getString(2)); bookinfo.setBookname(s.getString(3)); bookinfo.setWriter(s.getString(4)); bookinfo.setTranslator(s.getString(5)); bookinfo.setPublisher(s.getString(6)); bookinfo.setDate(s.getDate(7)); bookinfo.setPrice(s.getDouble(8)); list.add(bookinfo); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return list; } public static List selectbookmohuwriter(String writer){ List list=new ArrayList(); String sql="select * from tb_bookInfo where writer like '%"+writer+"%'"; System.out.print(sql); ResultSet s=Dao.executeQuery(sql); try { while(s.next()){ BookInfo bookinfo=new BookInfo(); bookinfo.setISBN(s.getString(1)); bookinfo.setTypeid(s.getString(2)); bookinfo.setBookname(s.getString(3)); bookinfo.setWriter(s.getString(4)); bookinfo.setTranslator(s.getString(5)); bookinfo.setPublisher(s.getString(6)); bookinfo.setDate(s.getDate(7)); bookinfo.setPrice(s.getDouble(8)); list.add(bookinfo); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return list; } public static int Insertoperator(String name,String sex,int age,String identityCard,Date workdate,String tel,String password){ int i=0; try{ String sql="insert into tb_operator(name,sex,age,identityCard,workdate,tel,password) values('"+name+"','"+sex+"',"+age+",'"+identityCard+"','"+workdate+"','"+tel+"','"+password+"')"; System.out.println(sql); i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } public static List selectuser() { List list=new ArrayList(); String sql = "select id,name,sex,age,identityCard,workdate,tel,password from tb_operator where admin=0"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { user user=new user(); user.setId(rs.getInt(1)); user.setName(rs.getString(2)); user.setSex(rs.getString(3)); user.setAge(rs.getInt(4)); user.setIdentityCard(rs.getString(5)); user.setWorkdate(rs.getDate(6)); user.setTel(rs.getString(7)); user.setPassword(rs.getString(8)); list.add(user); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } public static int Deluser(int id){ int i=0; try{ String sql="delete from tb_operator where id='"+id+"'"; //System.out.println(sql); i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } public static int Updateuser(int id,String name,String sex,int age,String identityCard,Date workdate,String tel,String password){ int i=0; try{ String sql="update tb_operator set name='"+name+"',sex='"+sex+"',age="+age+",identityCard='"+identityCard+"',workdate='"+workdate+"',tel='"+tel+"',password='"+password+"' where id='"+id+"'"; i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } public static int Updatepass(String password,String name){ int i=0; try{ String sql="update tb_operator set password='"+password+"' where name='"+name+"'"; i=Dao.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); } Dao.close(); return i; } }
好的,我可以给您提供一个简单的员工管理系统的实现思路和代码框架。 1. 定义一个员工类,包含员工的基本信息,如姓名、性别、年龄、工号、部门等等。同时在员工类中提供一些基本的操作方法,如获取和设置员工信息的方法等。 ```java public class Employee { private String name; private String gender; private int age; private int empNo; private String department; public Employee(String name, String gender, int age, int empNo, String department) { this.name = name; this.gender = gender; this.age = age; this.empNo = empNo; this.department = department; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getGender() { return gender; } public void setGender(String gender) { this.gender = gender; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public int getEmpNo() { return empNo; } public void setEmpNo(int empNo) { this.empNo = empNo; } public String getDepartment() { return department; } public void setDepartment(String department) { this.department = department; } @Override public String toString() { return "Employee{" + "name='" + name + '\'' + ", gender='" + gender + '\'' + ", age=" + age + ", empNo=" + empNo + ", department='" + department + '\'' + '}'; } } ``` 2. 定义一个员工管理类,包含对员工信息进行增删改查等操作的方法。在这个类中,我们使用 Map 来存储员工信息。 ```java import java.util.HashMap; import java.util.Map; public class EmployeeManagement { private Map<Integer, Employee> employees; public EmployeeManagement() { employees = new HashMap<>(); } public void addEmployee(Employee employee) { employees.put(employee.getEmpNo(), employee); } public void removeEmployee(int empNo) { employees.remove(empNo); } public void updateEmployee(Employee employee) { employees.put(employee.getEmpNo(), employee); } public Employee findEmployee(int empNo) { return employees.get(empNo); } public void printAllEmployees() { for (Employee employee : employees.values()) { System.out.println(employee); } } } ``` 3. 接下来,我们需要设计一个登录界面,用于员工登录系统。在登录界面中,我们要求员工输入用户名和密码,然后检查员工输入的信息是否正确。如果正确,就可以允许员工进入系统,否则需要提示员工重新输入用户名和密码。 ```java import java.util.Scanner; public class Login { private static final String USERNAME = "admin"; private static final String PASSWORD = "password"; public static void main(String[] args) { Scanner scanner = new Scanner(System.in); System.out.println("Welcome to Employee Management System!"); System.out.print("Please enter username: "); String username = scanner.nextLine(); System.out.print("Please enter password: "); String password = scanner.nextLine(); if (username.equals(USERNAME) && password.equals(PASSWORD)) { System.out.println("Login successful!"); EmployeeManagement employeeManagement = new EmployeeManagement(); // TODO: 在这里添加员工信息和操作员工信息的代码 } else { System.out.println("Invalid username or password. Please try again."); } } } ``` 4. 最后,我们将以上三个部分整合在一起,形成一个完整的员工管理系统。 ```java import java.util.Scanner; public class EmployeeManagementSystem { private static final String USERNAME = "admin"; private static final String PASSWORD = "password"; public static void main(String[] args) { Scanner scanner = new Scanner(System.in); System.out.println("Welcome to Employee Management System!"); System.out.print("Please enter username: "); String username = scanner.nextLine(); System.out.print("Please enter password: "); String password = scanner.nextLine(); if (username.equals(USERNAME) && password.equals(PASSWORD)) { System.out.println("Login successful!"); EmployeeManagement employeeManagement = new EmployeeManagement(); // 添加员工信息 Employee employee1 = new Employee("Tom", "Male", 30, 1001, "Sales"); employeeManagement.addEmployee(employee1); Employee employee2 = new Employee("Lucy", "Female", 25, 1002, "Marketing"); employeeManagement.addEmployee(employee2); // 查询员工信息 Employee employee = employeeManagement.findEmployee(1001); System.out.println(employee); // 更新员工信息 employee1.setAge(31); employeeManagement.updateEmployee(employee1); System.out.println(employee1); // 删除员工信息 employeeManagement.removeEmployee(1002); employeeManagement.printAllEmployees(); } else { System.out.println("Invalid username or password. Please try again."); } scanner.close(); } } ``` 这个员工管理系统只是一个简单的示例,您可以根据自己的需求和实际情况来进行扩展和优化。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

Spasol

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值