unable to insert data into database

unable to insert data into database

hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting data into database based on this ename.but it displays a message that "Sorry! Could Not Enter Details into Time Sheet!".can any one help me plz.

empbeans.java:

public void sheet() {

         ename = util.getSession().getAttribute("ename").toString();
        boolean done = userdao.sheet(pid, ptime, rtime, workdone,ename);
         if (done) {
             pid = ptime = rtime = 0;
            workdone = leavedate = "";
            message = "Entered details into Time Sheet Successfully!";
        } else {
            message = "Sorry! Could Not Enter Details into Time Sheet!";
        }
    }

userdao.java

  public static boolean sheet(int pid,int ptime,int rtime,String workdone,String ename) {
        Connection con = null;
        PreparedStatement ps1 = null;
        PreparedStatement ps2=null;
        ResultSet rs=null;
       try {
            con = Database.getConnection();
           ps1=con.prepareStatement("select eid from employee where ename=?");
            ps1.setString(1, ename);
            rs=ps1.executeQuery();
            ps2 = con.prepareStatement(
                    "insert into emp_timesheet values(?,sysdate,?,?,?,?)");
            ps2.setInt(1,rs.getInt(1));
            ps2.setInt(2, pid);
            ps2.setInt(3, ptime);
            ps2.setInt(4, rtime);
            ps2.setString(5, workdone);
            int count = ps2.executeUpdate();
             return count == 1;
        } catch (Exception ex) {
            System.out.println("Error in inserting into time sheet   -->" + ex.getMessage());
            return false;
        } finally {
            Database.close(con);
        }
    }
View Answers

Ads









Related Tutorials/Questions & Answers:
unable to insert data into database
unable to insert data into database    hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting data into database based
unable to insert data into database
unable to insert data into database    hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting data into database based
Advertisements
unable to insert data into database
unable to insert data into database    hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting data into database based
unable to insert data into database
unable to insert data into database    hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting data into database based
java script unable to connect to oracle database and insert data
java script unable to connect to oracle database and insert data  ... is to insert data from jsp to oracle database 8, so i create a table in oracle...=con.createStatement(); int i=st.executeUpdate("insert into departments
insert data into database
insert data into database  hi,thanks for reply just i am doing... and studentmaster is the database table name. i am using same details. Now give the data into the jsp page that data stored into the database.Here the error
database is connected but not insert the data
database is connected but not insert the data  hi, i am getting connected to database.Retrive the data also but cannot insert the data into database...=con.prepareStatement("insert into studentmaster(slno) values('"+batch+"')"); i
insert data into database
insert data into database  type Exception report message...)Go to the start->Control Panel->Administrative Tools-> data sources. 2... selecting the driver, click finish button. 4)Then give Data Source Name
Unable to connect servet, jsp to oracle 10g database.. Unable to retrieve data..
Unable to connect servet, jsp to oracle 10g database.. Unable to retrieve data.... If I use it also, unable to connect to backend oracle database. Let me...) { LoggerManager.writeLogWarning(e); } } return id; } } The data
insert data in the database using checkbox
insert data in the database using checkbox  i am fetching data from the database using servlet on the jsp page and there is checkbox corresponding... should i insert only checked data into database on submission.   We
Question about "Insert text file data into Database"
Question about "Insert text file data into Database"  Hey I was reading the tutorial "Insert text file data into Database", (awesome btw), and noticed that both a FileInputStream, a DataInputStream and a BufferedReader
how to insert data into database using jsp & retrive
how to insert data into database using jsp & retrive  Hello, I have created 1 html page which contain username, password & submit button. in my oracle10G database already contain table name admin which has name, password
what is the jsp coding to insert a data in database tables
what is the jsp coding to insert a data in database tables  Dear Sir, I Want to know the coding for insert the data from jsp to oracle database.. my... that insert the form values to MySQL database. 1)register.jsp: <html> <form
how to insert data in database using html+jsp
how to insert data in database using html+jsp  anyone know what... and database name. Here machine name id localhost and database name... = null; // declare a resultset that uses as a table for output data from
i need program to insert data in database using javascript
i need program to insert data in database using javascript  please help me
unable to connect database in java
unable to connect database in java  Hello Everyone! i was trying to connect database with my application by using java but i am unable to connect...: [Microsoft][ODBC Driver Manager] Data source name not fou nd and no default driver
Insert XML file data to database
Insert XML file data to database In this tutorial, you will learn how to insert the xml file data to database using dom parser. You all are aware of XML... to read the xml file data and save the values of an XML file to a Database
using ajax i want to insert data into oracle database
using ajax i want to insert data into oracle database  i would like to insert/update/select/delete from jsp to oracle database using ajax? please send a code for this iam using oracl database thank you
unable to connect database in java
unable to connect database in java  Hello Everyone! i was trying to connect database with my application by using java but i am unable to connect... Driver Manager] Data source name not fou nd and no default driver specified
Unable to store the image into database
); }   Hi, Please check the thread How to Insert image into database...Unable to store the image into database  Hello, I have created below... = con.prepareStatement("insert into IMAGEMAIN (id,image) values(?,?)"); pre.setString
How to insert data from textfields into database using hibernate?
How to insert data from textfields into database using hibernate?   try{ Session session = HibernateUtil.getSessionFactory().openSession...); System.out.println("Successfully data insert in database"); tx.commit
Insert data in mysql database through jsp using prepared statement
Insert data in mysql database through jsp using prepared statement...; This is detailed jsp code that how to insert data into database by using prepared statement...; <HEAD> <TITLE>insert data using prepared statement </TITLE>
How to Insert image and data both together in database in JSP/Servlet ?
How to Insert image and data both together in database in JSP/Servlet ? ... = connection.prepareStatement("insert into data(Name,City,Img) values('"+nn+"','"+cc...;BODY> <FORM ENCTYPE="multipart/form-data" ACTION
JDBC Video Tutorial- How to insert data into MySQL database table?
JDBC Video tutorial example for inserting data into MySQL database JDBC... and in this video I have explained the steps of write code to insert the data...; to insert the database into database. The executeUpdate() method
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql  can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql  can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql  can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql  can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
callable statement,stored procedure for insert data and also for update data into oracle database using jsp
callable statement,stored procedure for insert data and also for update data into oracle database using jsp  iam a fresher newbie to softparsing i... procedure for inserting data into oracle database as bind variable and same
Insert Data into Database Using Hibernate Native SQL
Insert Data into Database Using Hibernate Native SQL... to insert data into database. Native SQL is handwritten SQL for all database... native sql for inserting data into database. Hibernate Native uses only
Unable to Insert Arabic words in mysql table
Unable to Insert Arabic words in mysql table  I have I java program that I want to insert arabic letters in mysql. Do you have any idea about the configuration of mysql that accepts arabic charcters.   in jsp use
How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet  i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server
Create XML file from flat file and data insert into database
Create XML file from flat file and data insert into database... create XML and    data insert into the database.");  ... insert into the database.       Step:1 Create a "
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it   I have tried the following code Database creation: create database studentdb; create table stu_info ( ID int not null auto
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it   I have tried the following code Database creation: create database studentdb; create table stu_info ( ID int not null auto
Insert data in Excel File from Database using JSP
the data from database, create an excel file and data insert into newly... Insert data in Excel File from Database  using JSP ... developed a application to insert data  in excel file from database in JSP. We
Insert image in database
Insert image in database  Want a jsp-struts program in which the imageFile is in the form of getter and setter and inserted in the database as a Blob using . and then download the image and show on next jsp pg. No use
Unable to upload a file to mysql database using struts1
Unable to upload a file to mysql database using struts1  Hi, Below...="multipart/form-data"> Select a File :<html:file property="file"/> <... fileSize=formFile.getFileSize(); int insert=0; try{ Class.forName
how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database... a browse button which can upload a excelfile and after uploading the data should be inserted into oracle database.. please help me sir...   hi friend
Oracle Database - Insert System Time
Oracle Database - Insert System Time  Hi I want to insert only system time dynamically using a statement but not a prepared statement into Oracle Database please suggest me any code
Insert Records in Table
;  The Insert data in Table is used to insert  records or rows into the table in database. The Syntax used to insert records into a table... The Tutorial illustrates an example from Insert data in Table. In this Tutorial we
single query to insert the data
single query to insert the data  How to insert data for all HTML fields in single MYSQL query
insert date into database using jsf
insert date into database using jsf  Hello I need a simple example of source code to insert a date into a database using jsf what do I have to put in backing bean and page jsf ( i need juste a date ) thanks
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to get datas from oracle database
unable to get datas from oracle database  Dear Sir, I am again struck in my project.. i want to display data from oracle database but i get... org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred
How to insert clob data??
How to insert clob data??  Can any one tell me in details how... to insert more than 4000 characters.I have heard that clob fields can hold 4 gb of data and need pl/sql to avail that feature.Can any one tell me how to create
EJB Insert data
describes you the way  to insert data into the database using EJB. The steps involved in inserting data are as :- 1)Create an interface named... .style1 { color: #000000; } EJB Insert data
Insert data in database by using sql tag of JSTL SQL library
;> <c:out value="Unable to insert data in database." /> <... Insert data in database by using sql tag of JSTL SQL library... by user. To update database first create a data source and then execute insert sql

Ads