Solved

insert new values in table using servlet ??

Posted on 2002-05-07
2
165 Views
Last Modified: 2013-11-24
would u give me simple example how to store values which are send from a form to a servlet into tables in microsoft access.
0
Comment
Question by:star4
2 Comments
 
LVL 18

Accepted Solution

by:
bobbit31 earned 50 total points
ID: 6994916
import java.sql.*;

Connection con = null;

try {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

   con = DriverManager.getConnection("jdbc:odbc:<DSN>");

   Statement stmt = con.createStatement();
   stmt.executeUpdate("Insert into <your table> (field1, field2, field3) values (<param1>, <param2>, <param3>)");
   stmt.close();
} catch (Exception e) {
   System.out.println(e.getMessage());  
} finally {
   if (con != null) { con.close(); }
}

to get parameters from form:

String param1 = request.getParameter("param1");
String param2 = request.getParameter("param2");
String param3 = request.getParameter("param3");

0
 

Author Comment

by:star4
ID: 7022252
may u help again bobbit31 :
i tried this code but nothing is entered in the database ?

 String strSQL,strSQL1,strSQL2;
               String empno,password,todaydate,massage;
         
               //Storing the result of Query in those variavles
               //after initializing them to null
               ResultSet rs=null, rs1=null;
            Statement stmt;
           
               //Making variables and initialze them
               int i=0;
               //In order to establish a connection to the databse
               //we should have the approperiate driver connect to
               //the DBMS.
               //db1 : is the name of the database where it is defind
               //on the jdbc:odbc driver
               
               Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
           con = DriverManager.getConnection("jdbc:odbc:db1");
                                                                //Creating statement for connection
               stmt = con.createStatement();
               
               //Get userid ,password ,month and year from the
               //web site forms, and store them in the approperiate variables
               empno = req.getParameter("empid");
            password = req.getParameter("password");
               todaydate = req.getParameter("todaydate");
            massage = req.getParameter("massage");
               //Check the Empid and password intered by the user
               //match the Empid and password stored in table LoginTable
               strSQL = "select * from LoginTable " +
            "where EmpID like '" + empno + "' and " +
           "Password like '" + password + "'";
              rs = stmt.executeQuery(strSQL);
           
               //If password and Empid are correct then assign true to logged
               //otherwise assign false
               if (rs.next())                                                      
                         {  
                     //Password and Empid are correct
                     logged=true;
                     //close the result
                     rs.close();
                }
                else
                {  
                  //Password or Empid are not correct
                     logged =false;
                     rs.close();
                }
               
               //IF logged = true
                if (logged)
                {      
                out.println("gooooooooood");              
            stmt.executeUpdate("Insert into reqleaves (empno,sendeddate,massage)values (empno, todaydate,massege)");
              }
             else
                {  
              out.println("Please Check your id and password");
                }    
                  //close the statement
               stmt.close();
                 
              //if errors exist then display them
       } catch (Exception e)
         {
           e.printStackTrace();
       }
         finally
         {
            if (con != null)
               {
                 try
                     {
                      con.close();
                 } catch (SQLException se) {
                      se.printStackTrace(System.err);
                 }
            }
       }
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to get all the API from website? 11 104
servlet example 17 51
Java string replace 11 54
Delphi Firemonkey: if the Sms contain special characters it won't send it 3 43
After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question