Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

insert new values in table using servlet ??

Posted on 2002-05-07
2
Medium Priority
?
173 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 200 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses
Course of the Month13 days, 13 hours left to enroll

580 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