shivanand42
i have done :
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
and created a table with fields:
my :
username(text data type)
lastname(text)
email(text)
reemail(text)
newpass(text)
gender(text) and dob(text)
REGISTER.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.JAVA
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,newpass,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
}
}
when i give data in register.jsp data is transferred into registration.java but i couldNOT get data displayed in table in my database (authors.accdb) when i run my registration.java , i got errror saying "EXCEPTION: GENERAL ERROR" PLEASE HELP , DONT GIVE AN EXAMPLE FOR PLEASE SOLVE MY PROGRAM . WHATS REALLY GOIGN WRONG .......WHY I CANT INSERT INTO TABLE (AUTHORS.ACCDB)
IF U GIVE ANY EXAMPLE PLEASE I NEED , IT HAS DROPS AND DATEPICKER IN IT...DONT JUST FOR TEXT BOXES..PEASE ITS REQUEST EVEN IN THE TABLE "USERNAME IS PREIMARY KEY " HELP ME ...I KNOW CONNECTION (MA ACCESS) LET ME KNOW IN MY PROGRAM WHERE I AM GOIN WRONG PLEASE
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
