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