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;
}
}
}
http://download.csdn.net/download/u012164393/9605024
说下思路： 首先你要确定你的每一个值都是拿到的，------>然后是 写一个jdbc连接----->将接收到的参数拼装到插入sql中----》检查数据库
楼主已经有连接数据库的相关代码了吧？ 楼主的EmployeeService 类不就是连接数据库后的增删改查操作吗？ 操作之后数据库没有数据？ sql执行之后commit了没？
已经解决了，
连接到了数据库