资产管理系统（java，课程设计）

import java.util.*; import java.sql.*; import javax.swing.*; /** * 有关资产信息数据库操作的类 */ public class AssetsBean { String sql; ResultSet rs = null; String field1; //assetsID; String field2; //assetsName; String field3; //typeID; String field4; //model; String field5; //price; String field6; //buyDate; String field7; //status; String field8; //other; String colName;//列名 String colValue;//列值 String colValue2;//列值 /** * 添加设备信息 */ public void add(String f1, String f2, String f3, String f4, String f5, String f6, String f7, String f8){ Database DB = new Database(); this.field1 = f1; this.field2 = f2; this.field3 = f3; this.field4 = f4; this.field5 = f5; this.field6 = f6; this.field7 = f7; this.field8 = f8; if(field1 == null||field1.equals("")){ JOptionPane.showMessageDialog(null, "请输入资产编号", "错误", JOptionPane.ERROR_MESSAGE); return; } else if (field2 == null||field2.equals("")){ JOptionPane.showMessageDialog(null, "请输入设备名称", "错误", JOptionPane.ERROR_MESSAGE); return; } else if (field3 == null||field3.equals("")){ JOptionPane.showMessageDialog(null, "请输入设备型号", "错误", JOptionPane.ERROR_MESSAGE); return; } else if (field4 == null||field4.equals("")){ JOptionPane.showMessageDialog(null, "请输入设备价格", "错误", JOptionPane.ERROR_MESSAGE); return; } else if (field5 == null||field5.equals("")){ JOptionPane.showMessageDialog(null, "请输入设备价格", "错误", JOptionPane.ERROR_MESSAGE); return; } else{ sql = "insert into Assets(AssetsID,Name,TypeID,Model,Price,BuyDate,Status,Other) values ('"+field1+"','"+field2+"','"+field3+"','"+field4+"','"+field5+"','"+field6+"','"+field7+"','"+field8+"')"; try{ DB.OpenConn(); DB.executeUpdate(sql); JOptionPane.showMessageDialog(null,"成功添加一条新的纪录！"); } catch(Exception e){ System.out.println(e); JOptionPane.showMessageDialog(null, "保存失败", "错误", JOptionPane.ERROR_MESSAGE); } finally { DB.closeStmt(); DB.closeConn(); } } } /** * 修改设备信息 */ public void modify(String f1, String f2, String f3, String f4, String f5, String f6, String f7, String f8){ Database DB = new Database(); this.field1 = f1; this.field2 = f2; this.field3 = f3; this.field4 = f4; this.field5 = f5; this.field6 = f6; this.field7 = f7; this.field8 = f8; if(field1 == null||field1.equals("")){ JOptionPane.showMessageDialog(null, "请输入资产编号", "错误", JOptionPane.ERROR_MESSAGE); return; } else if (field2 == null||field2.equals("")){ JOptionPane.showMessageDialog(null, "请输入设备名称", "错误", JOptionPane.ERROR_MESSAGE); return; } else if (field3 == null||field3.equals("")){ JOptionPane.showMessageDialog(null, "请输入设备型号", "错误", JOptionPane.ERROR_MESSAGE); return; } else if (field4 == null||field4.equals("")){ JOptionPane.showMessageDialog(null, "请输入设备价格", "错误", JOptionPane.ERROR_MESSAGE); return; } else if (field5 == null||field5.equals("")){ JOptionPane.showMessageDialog(null, "请输入设备价格", "错误", JOptionPane.ERROR_MESSAGE); return; } else{ sql = "update Assets set Name = '"+field2+"', typeID = '"+field3+"', model = '"+field4+"', price = '"+field5+"', buyDate = '"+field6+"', status = '"+field7+"', other = '"+field8+"' where AssetsID = "+field1+""; try{ DB.OpenConn(); DB.executeUpdate(sql); JOptionPane.showMessageDialog(null,"成功修改一条新的纪录！"); } catch(Exception e){ System.out.println(e); JOptionPane.showMessageDialog(null, "更新失败", "错误", JOptionPane.ERROR_MESSAGE); } finally { DB.closeStmt(); DB.closeConn(); } } } /** * 删除信息 */ public void delete(String f1){ Database DB = new Database(); this.field1 = f1; sql = "delete from Assets where AssetsID = "+field1+""; try{ DB.OpenConn(); DB.executeUpdate(sql); JOptionPane.showMessageDialog(null,"成功删除一条新的纪录！"); } catch(Exception e){ System.out.println(e); JOptionPane.showMessageDialog(null, "删除失败", "错误", JOptionPane.ERROR_MESSAGE); } finally { DB.closeStmt(); DB.closeConn(); } } /** * 根据编号查询信息 */ public String[] search(String f1){ Database DB = new Database(); this.field1 = f1; String[] s = new String[7]; sql = "select * from Assets where AssetsID = "+field1+""; try{ DB.OpenConn(); rs = DB.executeQuery(sql); if(rs.next()){ s[0] = rs.getString("Name"); s[1] = rs.getString("TypeID"); s[2] = rs.getString("Model"); s[3] = rs.getString("Price"); s[4] = rs.getString("BuyDate"); s[5] = rs.getString("Status"); s[6] = rs.getString("Other"); } else s = null; } catch(Exception e){ } finally { DB.closeStmt(); DB.closeConn(); } return s; } /** * 资产信息综合查询(查询所有记录) */ public String[][] searchAll(){ Database DB = new Database(); String[][] sn = null; int row = 0; int i = 0; sql = "select * from Assets order by AssetsID"; try{ DB.OpenConn(); rs = DB.executeQuery(sql); if(rs.last()){ row = rs.getRow(); } if(row == 0){ sn = null; } else{ sn = new String[row][8]; rs.first(); rs.previous(); while(rs.next()){ sn[i][0] = rs.getString("AssetsID"); sn[i][1] = rs.getString("Name"); sn[i][2] = rs.getString("TypeID"); sn[i][3] = rs.getString("Model"); sn[i][4] = rs.getString("Price"); sn[i][5] = rs.getString("BuyDate"); sn[i][6] = rs.getString("Status"); sn[i][7] = rs.getString("Other"); i++; } } } catch(Exception e){ } finally { DB.closeStmt(); DB.closeConn(); } return sn; } /** * 资产信息综合查询(按照ID进行查询) */ public String[][] searchAll(String f1){ this.field1 = f1; Database DB = new Database(); String[][] sn = null; int row = 0; int i = 0; sql = "select * from Assets where AssetsID="+field1+" order by AssetsID"; try{ DB.OpenConn(); rs = DB.executeQuery(sql); if(rs.last()){ row = rs.getRow(); } if(row == 0){ sn = null; } else{ sn = new String[row][8]; rs.first(); rs.previous(); while(rs.next()){ sn[i][0] = rs.getString("AssetsID"); sn[i][1] = rs.getString("Name"); sn[i][2] = rs.getString("TypeID"); sn[i][3] = rs.getString("Model"); sn[i][4] = rs.getString("Price"); sn[i][5] = rs.getString("BuyDate"); sn[i][6] = rs.getString("Status"); sn[i][7] = rs.getString("Other"); i++; } } } catch(Exception e){ } finally { DB.closeStmt(); DB.closeConn(); } return sn; } /** * 获得新的ID */ public int getId(){ Database DB = new Database(); int ID = 1; sql = "select max(AssetsID) from Assets"; try{ DB.OpenConn(); rs = DB.executeQuery(sql); if(rs.next()){ ID = rs.getInt(1) + 1; } else ID = 1; } catch(Exception e){ } finally { DB.closeStmt(); DB.closeConn(); } return ID; } /** * 获得表中的所有编号 */ public String[] getAllId(){ String[] s = null; int row = 0; int i = 0; Database DB = new Database(); sql = "select AssetsID from Assets"; try{ DB.OpenConn(); rs = DB.executeQuery(sql); if(rs.last()){ row = rs.getRow(); } if(row == 0){ s = null; } else{ s = new String[row]; rs.first(); rs.previous(); while(rs.next()){ s[i] = rs.getString(1); i++; } } } catch(Exception e){ System.out.println(e); }