q26847929 2017-08-16 16:19 采纳率: 0%
浏览 1712

从控制台输入数据,怎么插到oracle数据库里面

public class MainUI {
static Scanner scanner = new Scanner(System.in);

public static void main(String[] args) {
        mainMenu();
}
public static void mainMenu(){
    System.out.println("欢迎登陆LUCK超市收银系统");
    System.out.println("1.登录");
    System.out.println("2.退出");
    System.out.print("请输入你的选择:(输入数字1-2)");
    System.out.println();
    int i = scanner.nextInt();
    switch (i) {
    case 1:
        Login();
        break;
    case 2:
        System.exit(0);
        break;
    }
}

public static void Login(){
    EmployeeEntity employeeEntity = new EmployeeEntity();
    System.out.println("请输入用户名:\t");
    employeeEntity.setAccountn(scanner.next());
    System.out.println("请输入密码:\t");
    employeeEntity.setPwd(scanner.next());

    EmployeeService eService = new EmployeeService();
    EmployeeEntity user = eService.Login(employeeEntity);
    if(null==user)
    {
        System.out.println("登录失败,用户或者密码错误!!");
        System.out.println();
        mainMenu();
    }
    else if(user.getIsadmin().equals("Y"))
    {
        AdminUI admin = new AdminUI();
        admin.adminMenu();
    }
    else if(user.getIsenable().equals("Y"))
    {
        EmployeeUI employeeUI = new EmployeeUI();
        employeeUI.userUI();
    }else
    {
        System.out.println("你的账户没有被激活请联系管理员!!!");
        System.out.println();
        mainMenu();
    }
}

}
public class AdminUI {

private EmployeeService employeeService = new EmployeeService();
Scanner sc = new Scanner(System.in);

public void  adminMenu()
{
    System.out.println("1.收银员账号管理(一期)");
    System.out.println("2.收银员考勤记录(三期)");
    System.out.println("3.商品管理 (一期)");
    System.out.println("4.供应商管理(一期)");
    System.out.println("5.退出");
    System.out.println("请输入你的选择:");
    int a = sc.nextInt();
    switch (a) {
    case 1:
        employeeManager();
    case 5:
        System.exit(0);
        break;
    }
}

public void employeeManager(){
    System.out.println("1.收银员账号查询");
    System.out.println("2.收银员账号添加");
    System.out.println("3.收银员账号删除");
    System.out.println("4.收银员账号修改");
    System.out.println("5.收银员账号激活或锁定");
    System.out.println("6.返回上级菜单");
    System.out.println("请输入你的选择:(1-6)");
    int b = sc.nextInt();
    switch (b) {
    case 1:
        select();
        break;
    case 2:
        addEmploy();
        break;
    case 6:
        adminMenu();
        break;
    }
}

public void select(){
    EmployeeEntity employeeEntity = new EmployeeEntity();
    System.out.println("请输入");
    employeeEntity.setEmpno(sc.nextInt());

    EmployeeEntity emp = employeeService.SelectAllEmployee(employeeEntity);
    if(null == emp){
        System.out.println("用户为空,请重新输入:");
        select();
    }else {
        System.out.println(emp.getEmpno()+"\t"+emp.getEname()+"\t"+emp.getPhone()+"\t"+emp.getAccountn()+"\t"+emp.getPwd()+"\t"+emp.getIsadmin()+"\t"+emp.getIsenable());   
    }
}
public void addEmploy(){
    System.out.println("添加收银员编号:");
    sc.nextInt();


}

}
public class EmployeeService {

private EmployeeDAOIpml dao = new EmployeeDAOIpml();

public EmployeeEntity Login(EmployeeEntity employee){
    String sql = "select * from EmployeeInfo where accountn=? and pwd=?";
    Object[] objects = new Object[]{
            employee.getAccountn(),
            employee.getPwd()
    };
    List<EmployeeEntity> list = dao.QueryAllEmployee(sql, objects);
    if(list.size() > 0 ){
        return list.get(0);
    }else {
        return null;
    }
}
public EmployeeEntity SelectAllEmployee(EmployeeEntity emp){
    String sql = "select * from employeeinfo";
    Object[] objects = new Object[]{
            emp.getEmpno(),
            emp.getEname(),
            emp.getPhone(),
            emp.getAccountn(),
            emp.getPwd(),
            emp.getIsadmin(),
            emp.getIsenable()
    };
    List<EmployeeEntity> list =  dao.QueryAllEmployee(sql, objects);
    if(list.size() > 0 ){
        return list.get(0);
    }else {
        return null;
    }
}
public EmployeeEntity AddEmploy(EmployeeEntity emp){
    String sql = "insert into employeeinfo values(?,?,?,?,?,?,?)";
    Object[] objects = new Object[]{
            emp.getEmpno(),
            emp.getEname(),
            emp.getPhone(),
            emp.getAccountn(),
            emp.getPwd(),
            emp.getIsadmin(),
            emp.getIsenable()
    };
    List<EmployeeEntity> list = dao.QueryAllEmployee(sql, objects);
    if(list.size() > 0 ){
        return list.get(0);
    }else {
         return null;
    }

}

}

  • 写回答

4条回答 默认 最新

  • threenewbee 2017-08-17 00:28
    关注
    评论

报告相同问题?

悬赏问题

  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!