Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL I cant get values in MS acces in tables

Have Programming Question? Ask it here!
 
 
 


shivanand42
I cant get values in MS acces in tables
1 Answer(s)      a year 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


Advertisement
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
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
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
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
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
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
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
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
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
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
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
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 <
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
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
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
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
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
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
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
How to get the request scope values? - Struts
How to get the request scope values?  Get value in Struts
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
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
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
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
i cNT GET ANSWER FOR THIS QUESTION
i cNT GET ANSWER FOR THIS QUESTION  The roots of the quadratic equation ax2+bx+c=0, aï??¹0 are given by the following formula: x=(-b?±â?š(b^2-4ac))/2a In this formula. The term b2-4ac is called
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
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
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
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
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 values to dropdownlist from oracle database
how to get the values to dropdownlist from oracle database   </script> </head> <body> <select name='countryname' onchange="showState(this.value)"> <option value
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 
Nest tables within tables
Nest tables within tables  Can I nest tables within tables
how i can get jqfade.js library
how i can get jqfade.js library  how i can get jqfade.j script library
Advertisements
 

 

 

DMCA.com