Solved

insert new values in table using servlet ??

Posted on 2002-05-07
2
164 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
allswap challenge 6 97
Groovy problem when using SOAPUI : DispatchException occurred 7 44
java jdbc batch example 8 33
java stored proc example 9 29
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 …
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

770 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