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.java public 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

Popular posts from this blog

iphone - Dismissing a UIAlertView -

c# - Can ProtoBuf-Net deserialize to a flat class? -

javascript - Change element in each JQuery tab to dynamically generated colors -