Share on Google+Share on Google+

shivanand42
I cant get values in MS acces in tables
1 Answer(s)      4 years and 5 months ago
Posted in : SQL

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

Ads

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);
  }
  }
  }
}









Related Tutorials/Questions & Answers:
I cant get values in MS acces in tables
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... sta = con.createStatement(); int i=sta.executeUpdate("insert
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
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
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
can i insert values into two tables by a query - JDBC
can i insert values into two tables by a query  hi all, can i insert values into two tables by a query Thanks Bala k
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
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, Select name from sysobjects where type="...." it will give You list according to where clause
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
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
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
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
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
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 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
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
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: JOIN Query Simple Query Thanks
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
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
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 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
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
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
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 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
I need to join three tables and return data that may not be in all three tables
do not get all the students, I only get the students that are in all three tables...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
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
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
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 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 <
Tutorials   
Java Spring Hibernate Struts Training How to Fetch Data using dropdown option How to get day from date in SQL? Example of sorting results in MySQL Distinct and Limit example in MySQL How to download install and use MySQL workbench? Example of Average, Sum, Min and Max functions in MySQL How to delete data from MySQL? Update SQL Query Example Order by example in MySQL AND and OR Operators in MySQL Query Where clause with query in MySQL How to use select Statement in MySQL? How to insert data into MySQL Table? Create Database and tables in MySQL example of before insert trigger in mysql Failed to Call Procedure MY Sql Query Error - Not able to Understand the issue which query will be run for previous(button) question How to access data yearly from DB in C# ? Fastest way to upload huge raw data in database - c#, Java or stored procedure DB Insert Nb hours between 2 time stamps meets specific criteria mysql select into table from another table example MySQLselect into new table Example code How to create a .mdf file from script (.sql) Please help me out fixing broken relational links in MySQL database after an upgrade How do I upgrade mysql? mysql 4.x to 5.x upgrade problem Upgrading a PHP/MYSQL application? upgrading sql query join phpmyadmin in whm whm php version update php cpanel cpanel mysql downgrade cpanel mysql version upgrade mysql whm upgrade mysql 4 5 cpanel upgrade mysql cpanel server Did my upgrade from mySQL 5.1 to 5.5 work Upgrade to MySQL 5.5 ? - cPanel Mem use upgrade from MySQL 5.1 to 5.5 - cPanel Upgrading MySQL from 5.0 to 5.1 or 5.5 - cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel Updating from MySQL 5.0 to 5.5 cPanel MySQL 5.1 upgrade to 5.5 error Charset problem upon publishing PHP + MySQL website MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist SQL Error Version 5.5.15

Ads

 
Advertisement null

Ads