I cant get values in MS acces in tables

I got problem in sending values from servlet . * i am using ms acces * i cant display my values but der is increase in number of rows

my jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<!-- used jquery for datepicker -->

 <meta charset="utf-8" />    <title>register</title>    <link rel="stylesheet" href="css/jquery-ui[1].css" />    <script src="script/jquery-1.8.2.js"></script>    <script src="http://code.jquery.com/ui/1.9.0/jquery-ui.js"></script>    <link rel="stylesheet" href="/resources/demos/style.css" />    <script>    $(function() {        $( "#datepicker" ).datepicker();    });    </script>

</head>
<body background="images/register.bmp">
<div id="container" style="height:500px;width:500px">

<div id="login" style="background-color:#FAEBD7;height:500px;width:350px;float:left;">
<center><h2><i><b>Registration</b></i></h2></center>
<table>
<tr>
<td><b><i>Username</i></b></td>
<td><input type="text" size="15" maxlength="30" name="username" /></td>
</tr>
<tr>
<td ><b><i>Last Name</i></b></td>
<td><input type="text" size="15" maxlength="30" name="lastname" ></td>
</tr>
<tr>
<td ><b><i>Email</i></b></td>
<td><input type="text" size="15" maxlength="30" name="email" ></td>
</tr>
<tr>
<td ><b><i>Re-enter Email</i></b></td>
<td><input type="text" size="15" maxlength="30" name="reemail" ></td>
</tr>
<tr>
<td ><b><i>New Password</i></b></td>
<td><input type="password" size="15" maxlength="30" name="newpass" ></td>
</tr>
<tr>
<td ><b><i>Gender</i></b></td>

<td><select name="gender">
  <option value="male">male</option>
  <option value="female">female</option>

</select></td>

</tr>


<tr>
<td ><b><i>DOB</i></b></td>
<td>
<input type="text" id="datepicker" name="datepicker" />
</td>
</tr>


<tr>
 <form action="./Registartion" method="post">


            <input type="submit" value="SINGUP"></input>
        </form>

        <!--  <td><INPUT TYPE="button" VALUE="SIGNUP" onClick="parent.location='page1.html'"></td>-->

</tr>
</table>
</div>
</div>
</body>
</html>

registration servlet:

package validate;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
/**
 * Servlet implementation class Registartion
 */
public class Registartion extends HttpServlet {
    private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */


    public static String username="";
    public static String lastname="";
    public static String email="";
    public static String reemail="";
    public static String newpass="";
    public static String gender="";
    public static String datepicker="";
    public static void main(String[] args) {
        Connection con = null;
        try {



          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\\myca\\demo\\authors.accdb");
    // Creating a database table
          Statement sta = con.createStatement(); 
          int i=sta.executeUpdate("insert into registration (username,lastname,email,reemail,password,gender,dob) values('"+username+"','"+lastname+"','"+email+"','"+reemail+"','"+newpass+"','"+gender+"','"+datepicker+"')");
          System.out.println("Data is successfully inserted!");
          sta.close();        

          con.close();        
        } catch (Exception e) {
          System.err.println("Exception: "+e.getMessage());
        }
    // TODO Auto-generated constructor stub
    }


    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
         username=request.getParameter("username");
         lastname=request.getParameter("lastname");
         email=request.getParameter("email");
         reemail=request.getParameter("reemail");
         newpass=request.getParameter("newpass");
         gender=request.getParameter("gender");
         datepicker=request.getParameter("datepicker");

    }


    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
    }

}

please help in issue

View Answers

November 1, 2012 at 11:26 AM

Insert form data into MS database

Follow these steps:

1)Go to the start->Control Panel->Administrative Tools-> data sources.

2)Click Add button and select the driver Microsoft Access Driver(*.mdb).

3)After selecting the driver, click finish button.

4)Then give Data Source Name and click ok button.

5)Your DSN will get created.

6) Restart your server and run your jsp/servlet code.

1)form.jsp:

<html>
<body>
<form method="POST" action="../ServletForm">
  <pre>
  User Id:    <input type="text" name="userId" size="20"></p>
  First Name: <input type="text" name="firstname" size="20"></p>
  Surname:    <input type="text" name="surname" size="20"></p>
  Address1:   <input type="text" name="address1" size="20"></p>
  Address2:   <input type="text" name="address2" size="20"></p>
  Town:       <input type="text"   name="town" size="20"></p>
  City:       <input type="text" name="country" size="20"></p>
  Zip code:   <input type="text" name="zipcode" size="20"></p>
              <input type="submit" value="Submit" name="B1"></p>
              </pre>
</form>
</body>
</html>

2)ServletForm.data:

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class ServletForm extends HttpServlet{
  public void init(ServletConfig config) throws ServletException{
  super.init(config);
  }
  public void doPost(HttpServletRequest req, 
  HttpServletResponse res) throws ServletException,
  IOException{

  ResultSet rs;
  res.setContentType("text/html");
  PrintWriter out = res.getWriter();
  String uId = req.getParameter("userId");
  String fname = req.getParameter("firstname");
  String sname = req.getParameter("surname");
  String address1 = req.getParameter("address1");
  String address2 = req.getParameter("address2");
  String town = req.getParameter("town");
  String county = req.getParameter("country");
  String zipcode = req.getParameter("zipcode"); 
  try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn =DriverManager.getConnection("jdbc:odbc:access");

  String sql =  "insert into emp_details values (?,?,?,?,?,?,?,?)";
  PreparedStatement pst = conn.prepareStatement(sql);
  pst.setString(1, uId);
  pst.setString(2, fname);
  pst.setString(3, sname);
  pst.setString(4, address1);
  pst.setString(5, address2);
  pst.setString(6, town);
  pst.setString(7, county);
  pst.setString(8, zipcode);
  int numRowsChanged = pst.executeUpdate();
  out.println(" Hello : ");
  out.println(" '"+fname+"'");
  pst.close();
  }
  catch(ClassNotFoundException e){
  out.println("Couldn't load database driver: " 
  + e.getMessage());
  }
  catch(SQLException e){
  out.println("SQLException caught: " 
  + e.getMessage());
  }
  catch (Exception e){
  out.println(e);
  }
  finally {
  try {
  if (connection != null) connection.close();
  }
  catch (SQLException ignored){
  out.println(ignored);
  }
  }
  }
}

Advertisements

why cant i close this ??
why cant i close this ?? import java.util.Scanner; public class square { public static void main ( String [] args) { Scanner keyboard...("Thank you "); } } i should use while to get the square of the number entered

Connect to MS Acces wothout using ODBC but JDBC - JDBC
Connect to MS Acces wothout using ODBC but JDBC Hi, I want to connect my MS Access using JDBC but not ODBC. Please help me out. Thanks

regarding ms acces database and servlet - JDBC
regarding ms acces database and servlet hello there, i am trying to do a web application that makes use of a data base. I opted for ms access database, i could run java main programs(i e not servlets public static void main

fetch data from ms acces - Swing AWT
fetch data from ms acces How do i fetch back AUTO generated key from MS ACCESS table after inserting data through the java panel.... Please Help Thanks in adv. Hi Friend, Try the following code: import

how to get values for same column name from two different tables in SQL
how to get values for same column name from two different tables in SQL how to get values for same column name from two different tables in SQL???? column name is emp_id loacated in these two tables company,employee

How can I get query string values in JavaScript?
How can I get query string values in JavaScript? How can I get query string values in JavaScript? To get a query string value, you can use JQuery and JavaScript.. here is the code: function getParameterByName(name

how to store array values into two different tables in java?
how to store array values into two different tables in java? I have use 4/5 textboxes with same name(e.g.text1) and I get the values in a array and now I want to store these values in two different tables(i.e store 2 array

this is my code but i cant able to run it wt is the problem
this is my code but i cant able to run it wt is the problem import java.io.*; class createthread { int thread=4,i; class thread1 extends createthread { public void run() { for(i=0;i

how to insert values from jsp into ms access
how to insert values from jsp into ms access how to insert values using jsp into ms access database

Get the list of tables in Sybase
Get the list of tables in Sybase hello, How to get the list of tables in Sybase? hii,ADS_TO_REPLACE_1 Select name from sysobjects where type="...." it will give You list according to where clause

i cant find any compile time error but there is runtime error.
i cant find any compile time error but there is runtime error. ... (res.next()) { int i = res.getInt("stud_code"); String s = res.getString("stud_name"); System.out.println(i + "\t\t" + s

supplying values to in parameters of stored procedure in ms sql and displaying out parameters
supplying values to in parameters of stored procedure in ms sql and displaying out parameters I have to execute following procedure ALTER PROCEDURE [dbo].[get_date] @codeId int, @vardate as datetime OUTPUT AS SELECT

plz check my codings are correct or not...There is an error..i cant find it..
plz check my codings are correct or not...There is an error..i cant find it.. import java.util.Scanner; public class Student { private String indexNo; private String gender; private char initial; private int mark1

i want to update values
i want to update values in my form i have 2 submit buttons one... database and it need to insert automatically in to disabled text boxs and once i press the edit button all text boxs need to enable so that i can edit my details

how to acces file in c - WebSevices
how to acces file in c How to acces file in c.... I have doubt on visual c++ ... how to create dialog control in visual c

how to retreive values from MS Access Database based on the values entered in textbox values in jsp file
how to retreive values from MS Access Database based on the values entered in textbox values in jsp file Hi am new to java. i need to create a dynamic web application. Am using eclipse IDE and Apache tomcat server. i need

I need to join three tables and return data that may not be in all three tables
that are in all three tables. How do I get all the information for students from table...I need to join three tables and return data that may not be in all three tables How do I join three tables and return information even

sql query to get data from two tables
sql query to get data from two tables how can i get the data from two different tables? Hi Friend, Please visit the following link:ADS_TO_REPLACE_1 JOIN Query Simple Query ThanksADS_TO_REPLACE_2

get date picker values to a textbox
get date picker values to a textbox I am using DatePicker to select date in a form in asp.net using c#. I need the picked data to get in to a textbox. Please help me soon

get values from Excel to database
get values from Excel to database hi i want to insert values from Excel file into database.Whatever field and contents are there in excel file... express 2005. how can i do with java code

how can i hide and show tables
how can i hide and show tables hai, i am creating a form which the code is included below i want to hide the tables initially and after i click go i want to display the tables with result.so any help is appreciated much <

i want to display where i entered values to same page
i want to display where i entered values to same page hi friends !! i have a values from jsp page .and i want to store that values into DB at the same time i want to show immediatlly on same jsp page with tabular format

hi , i cant make this programmer , can any one help me to make it pls - Java Beginners
hi , i cant make this programmer , can any one help me to make it pls ...://www.roseindia.net/java/example/java/io/ Thanks i want to make the whole program. i cant find delete records or update records pls can

Get values from session to array
Get values from session to array Hello I have stored my 2 dimensional array into session using C#.net. Now on aspx page i want to store same session variable into 2 dimensional array. And how to find count of session valaiable

How to get a values - JSP-Servlet
How to get a values Dear sir, I have one input text field and one submit button .Within one file how to get a values within a same jsp. Thanks and Regards Harini Veerapur. Hi Friend, Try the following

to get picture from ms access database by jsp-servlet....
to get picture from ms access database by jsp-servlet.... I have inserted a picture in ms access data base,,,how we can retrieve that picture by using jsp

Get values in drop down list
Get values in drop down list Pls provide me jsp code to get values in drop down list from another table's field. my project has customer registration and company registration pages..... when i insert data in company

sql query to get name,age,phone,address from tables t1,t2,t3,t4,t5 ..
sql query to get name,age,phone,address from tables t1,t2,t3,t4,t5 .. ... by name"; i want for 12 tables : i want to fetch name age pwd phone address from 12... , address FROM t1 order by name"; this is for 2 tables : query ="SELECT t.name

how to get the values from dynamically generated textbox in java?
how to get the values from dynamically generated textbox in java? I... to get and update this textbox values into both the tables(Xray,CTScan... textbox corresponding to the data. I want to get data from textboxes(generated

i am getting multiple values in listbox
i am getting multiple values in listbox hi sir, i am using... table group by stuname) order by a.name in a subquery multiple recdates i am getting its working fine, but in main query also i am getting multiple name

create MS Word in Java - Java Beginners
creates the word document having different paragraphs and two tables. i have sample code "Hello World!!! HAHAHAHAHA I DID IT!!" where we get this code everywhere. But i need to write more to the document like Table inserting values init

How to get a values - JSP-Servlet
How to get a values Dear sir, I have a one form... getting a null value aprt from a attachmented file,so how to get a other values... When i submit a form ,inother jsp i.e

Get the color values as a matrix of color image
Get the color values as a matrix of color image I am new to java and image processing, i want to get the color values as a matrix from the color image for giving input to the compression algorithm by using java. plz provide

Get values from JSP pages - JSP-Servlet
Get values from JSP pages I have welcome.jsp in which it has... I need to get the value of those column names(First Name, Second... or input fields. Hi Friend, Do you want to pass the column values

How to get the correct value by calculating double values....
How to get the correct value by calculating double values.... Hello Sir, I have a method in which i am getting getting wrong... and values like 59,142 etc here i am getting wrong output for the same

How to get the request scope values? - Struts
How to get the request scope values? Get value in Struts

How do i retain values in the drop down - Struts
How do i retain values in the drop down Hi, I have a jsp page... with the drop down. My problem is whenever i do this the values in the drop down gets reset while the others in the text boxes don't. How do i retain the values

How to compare two tables, and insert values which r not in one table to another table?
How to compare two tables, and insert values which r not in one table to another table? Hi I need to compare two tables MainTable and OUTTable... insert the values to main_table... here is my sql query insert into Main_Table

How to get the correct value by calculating double values....
How to get the correct value by calculating double values.... Hello Sir, I have a method in which i am getting getting wrong... is integer type and values like 59,142 etc here i am getting wrong output for the same

solution to get values for xml namespace tags from sqldatabase in java
=" "/> now i need to get values from sql database for values in the blank field(" "). how do i get these values.. already connected database and created xml...solution to get values for xml namespace tags from sqldatabase in java

Want solution to get values for xml namespace tags from database in java
:loc=" "/> now i need to get values from sql database for values in the blank field(" "). how do i get these values.. already connected database and created...Want solution to get values for xml namespace tags from database in java

how can i store text box values as it is in database table
how can i store text box values as it is in database table CUSTOMER DESCRIPTION

how to get a values from processRecord - JSP-Servlet
how to get a values from processRecord dear sir, i have a problem in getting a values from java to jsp.Here jsp is used to read a excel sheet that intern call a java program so i want a column values i.e a column contains

Nest tables within tables
Nest tables within tables Can I nest tables within tables

I cant get values in MS acces in tables

Questions by Category