java code problem -
java code problem -
i have bean called empbeans.java calls dao class(userdao.java) used inserting info table named emp_leaves.it inserts values based on ename brought session.i have little coding problem.it displaying message "sorry! not apply leave!".is there error in userdao.java ?plz solve.
here code.
empbeans.javapublic void apply(actionevent evt) { ename = util.getsession().getattribute("ename").tostring(); boolean done= userdao.apply(this); if ( done ) { reason = ""; leavedate=""; message = "applied leave successfully!"; } else message = "sorry! not apply leave!"; } userdao.java public static boolean apply(empbeans e) { connection con = null; preparedstatement ps=null; preparedstatement ps1=null; seek { con = database.getconnection(); ps1=con.preparestatement("select eid employee ename=?"); ps1.setstring(1,e.getename()); resultset rs=ps1.executequery(); ps = con.preparestatement( "insert emp_leaves values(?,?,?,default)"); ps.setint(1,rs.getint(1)); ps.setstring(1,e.getleavedate()); ps.setstring(2,e.getreason()); int count = ps.executeupdate(); homecoming count == 1; } grab (exception ex) { system.out.println("error in inserting time sheet -->" + ex.getmessage()); homecoming false; } { database.close(con); } }
you have missed rs.next();. because of which, have problems in ps.setint(1,rs.getint(1));
java
Comments
Post a Comment