有大牛知道是哪里錯了嗎?
public?class?view?{ ????private?static?final?String?CONTEXT="歡迎來到女神禁區:\n"?+ ????????????"下面是女神禁區的功能列表:\n"?+ ????????????"[MAIN/M]:主菜單\n"?+ ????????????"[QUERY/Q]:查看全部女神的信息\n"?+ ????????????"[GET/G]:查看某位女神的詳細信息\n"?+ ????????????"[ADD/A]:添加女神信息\n"?+ ????????????"[UPDATE/U]:更新女神信息\n"?+ ????????????"[DELETE/D]:刪除女神信息\n"?+ ????????????"[SEARCH/S]:查詢女神信息(根據姓名、手機號來查詢)\n"?+ ????????????"[EXIT/E]:退出女神禁區\n"?+ ????????????"[BREAK/B]:退出當前功能,返回主菜單"; ????private?static?final?String?OPERATION_MAIN="MAIN"; ????private?static?final?String?OPERATION_QUERY="QUERY"; ????private?static?final?String?OPERATION_GET="GET"; ????private?static?final?String?OPERATION_ADD="ADD"; ????private?static?final?String?OPERATION_UPDATE="UPDATE"; ????private?static?final?String?OPERATION_DELETE="DELETE"; ????private?static?final?String?OPERATION_SEARCH="SEARCH"; ????private?static?final?String?OPERATION_EXIT="EXIT"; ????private?static?final?String?OPERATION_BREAK="BREAK"; ????public?static?void?main(String[]?args)?{ ????????System.out.println(CONTEXT); ????????Scanner?scan?=?new?Scanner(System.in); ????????Goddess?g?=?new?Goddess(); ????????ActionGoddess?ag?=?new?ActionGoddess(); ????????String?prenious?=?null; ????????int?step?=?1; ????????while(scan.hasNext()){ ????????????String?in=scan.next().toString(); ????????????if(OPERATION_EXIT.equals(in.toUpperCase()) ????????????????????||OPERATION_EXIT.substring(0,?1).equals(in.toUpperCase())){ ????????????????System.out.println("您已成功退出女神禁區。"); ????????????????break; ????????????}else?if(OPERATION_ADD.equals(in.toUpperCase()) ????????????????????||OPERATION_ADD.substring(0,?1).equals(in.toUpperCase()) ????????????????????||OPERATION_ADD.equals(prenious)){ ????????????????prenious?=?OPERATION_ADD; ????????????????if(step?==?1){ ????????????????????System.out.println("請輸入女神的姓名:"); ????????????????}else?if(step?==?2){ ????????????????????g.setUser_name(in); ????????????????????System.out.println("請輸入女神的年齡:"); ????????????????}else?if(step?==?3){ ????????????????????g.setAge(Integer.valueOf(in)); ????????????????????System.out.println("請輸入女神的生日:(例如:yyyy-MM--dd)"); ????????????????}else?if(step==4){ ????????????????????SimpleDateFormat?sdf?=?new?SimpleDateFormat("yyyy-MM-dd"); ????????????????????try?{ ????????????????????????Date?data?=?sdf.parse(in); ????????????????????????g.setBirthday(data); ????????????????????????System.out.println("請輸入女神的郵箱:"); ????????????????????}?catch?(ParseException?e)?{ ????????????????????????e.printStackTrace(); ????????????????????????step?=?3; ????????????????????} ????????????????}else?if(step?==?5){ ????????????????????g.setEmail(in); ????????????????????System.out.println("請輸入女神的電話號碼:"); ????????????????}else?if?(step==6){ ????????????????????g.setMobile(in); ????????????????????try?{ ????????????????????????ag.addGoddess(g); ????????????????????????System.out.println("新增女神成功"); ????????????????????}?catch?(Exception?e)?{ ????????????????????????e.printStackTrace(); ????????????????????????System.out.println("新增女神失敗"); ????????????????????} ????????????????} ????????????????if?(prenious.equals(OPERATION_ADD)) ????????????????????step++; ????????????} ????????} ????} }
public?class?ActionGoddess?{ ????GoddessDao?dao?=?new?GoddessDao(); ????public?void?addGoddess(Goddess?g)?throws?Exception{ ????????dao.addGod(g); ????} ????public?void?delG(String?name)?throws?Exception{ ????????dao.delGoddess(name); ????} ????public?void?updateG(Goddess?goddess)?throws?Exception{ ????????dao.updateGoddess(goddess); ????} ????public?List<Goddess>?query(List<Map<String,Object>>?params)?throws?Exception{ ????????List<Goddess>?goddesses?=?dao.queryByParams(params); ????????return?goddesses; ????} ????//查詢全部女神 ????public?List<Goddess>?query()?throws?Exception{ ????????List<Goddess>?gs?=?dao.query(); ????????return?gs; ????} }
public?class?GoddessDao?{ ????public?void?addGoddess(Goddess?g)?throws?Exception{ ????????Connection?conn?=?DBHelper.getConn(); ????????String?sql?=?""+ ????????????????"insert?into?imooc_goddess"?+ ????????????????"(user_name,sex,age,birthday,email,mobile,"?+ ????????????????"create_user,create_date,update_user,update_date,isdel)"?+ ????????????????"values("?+ ????????????????"?,?,?,?,?,?,?,current_date(),?,current_date(),?)"; ????????PreparedStatement?ptmt?=?conn.prepareStatement(sql); ????????ptmt.setString(1,?g.getUser_name()); ????????ptmt.setInt(2,?g.getSex()); ????????ptmt.setInt(3,?g.getAge()); ????????ptmt.setDate(4,?new?Date(g.getBirthday().getTime())); ????????ptmt.setString(5,?g.getEmail()); ????????ptmt.setString(6,?g.getMobile()); ????????ptmt.setString(7,?g.getCreate_user()); ????????ptmt.setString(8,?g.getUpdate_user()); ????????ptmt.setInt(9,?g.getIsdel()); ????????ptmt.execute(); ????} ????}
為什么我這里添加女神的時候老是報錯?
2017-08-24
GoddessAction.java中修改add函數
public void add(Goddess goddess) throws Exception{
GoddessDao dao=new GoddessDao();
goddess.setSex(1);
goddess.setCreate_user("ADMIN");
goddess.setUpdate_user("ADMIN");
goddess.setIsdel(0);
dao.addGoddess(goddess);
}
2018-05-10
你逗沒創堅Goddess對象