public void MainClassManager() {
boolean flag = true;
Class_ManageDao CM = new Class_ManageDaoImpl();
do {
System.out.println("\t1.增加大类");
System.out.println("\t2.删除大类");
System.out.println("\t3.返回上一级菜单");
Scanner input = new Scanner(System.in);
int choice = input.nextInt();
switch (choice) {
case 1:
{
System.out.println("请输入要添加的大类名称：");
String mainClass = input.next();
CM.Add(mainClass);
break;
}
case 2:
{
System.out.println("请输入要删除的大类名称：");
String name = input.next();
CM.del(name);
this.DelByName(name);
break;
}
case 3:
{
flag = false;
break;
}
}
} while (flag == true);
}
@Override
public int Add() { // 增加资产
Class_ManageDao cm = new Class_ManageDaoImpl();
Scanner input = new Scanner(System.in);
// 向资产表中添加数据
System.out.println("请输入要增加的资产name");
String name = input.next();
System.out.println("请输入要增加的资产mainclass");
String mainclass = input.next();
System.out.println("请输入要增加的资产model");
String model = input.next();
System.out.println("请输入要增加的资产value");
int value = input.nextInt();
System.out.println("请输入要增加的资产date");
String date = input.next();
System.out.println("请输入要增加的资产status");
int status = input.nextInt();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
try {
Date Occ_Date = sdf.parse(date);
} catch (ParseException e) {
e.printStackTrace();
}
String sql =
"insert into Fixed_Assets (Assets_name,MainClass,Model,Value,Buy_date,Status) values (?,?,?,?,?,?)";
Object[] param = {name, mainclass, model, value, date, status};
int result = this.exceuteUpdate(sql, param);
// 检查类表中是否有该大类，没有则添加
// 有该大类时,函数返回true,否则返回false
if (!cm.getByClassName(mainclass)) {
cm.Add(mainclass);
}
return result;
}