Share on Google+Share on Google+

1 Answer(s)      7 years ago
Posted in : JDBC
code for front-end of any JDBC compatible database
View Answers

June 8, 2010 at 11:30 AM

Hi Friend,

Try the following code:


<center><h3>Registration Form</h3></center>
<form method="get" action="Registration.jsp">
<tr><td>First Name:</td><td><input type="text" name="firstname" size="20"></td></tr>
<tr><td>Last Name:</td><td><input type="text" name="lastname" size="20"></td></tr>
<tr><td>User Name:</td><td><input type="text" name="username" size="20"></td></tr>
<tr><td>Password:</td><td><input type="password" name="password" size="20"></td></tr>
<tr><td>Address </td><td><input type="text" name="address" size="20"></td></tr>
<tr><td>Contact No </td><td><input type="text" name="contact" size="20"></td></tr>
<tr><td>Email: </td><td><input type="text" name="email" size="20"></td></tr>
<tr><td>City: </td><td><input type="text" name="city" size="20"></td></tr>
<tr><td>State: </td><td><input type="text" name="state" size="20"></td></tr>
<tr><td>Country: </td><td> <input type="text" name="country" size="20"></td></tr>
<tr><td><input type="submit" value="Submit" name="B1"></td><td><input type="reset" value="Reset" name="B2"></td></tr>


<%@page import="java.sql.*" %>
String fname= request.getParameter("firstname");
String lname= request.getParameter("lastname");
String uname= request.getParameter("username");
String pass= request.getParameter("password");
String address= request.getParameter("address");
String contact=request.getParameter("contact");
String email=request.getParameter("email");
String city=request.getParameter("city");
String state=request.getParameter("state");
String country=request.getParameter("country");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
Statement st=conn.createStatement();
int i=st.executeUpdate("insert into employee(firstname,lastname,username,password,email,address, contactNo,city,state,country) values ('"+fname+"','"+lname+"','"+uname+"','"+pass+"','"+email+"','"+address+"','"+contact+"','"+city+"','"+state+"','"+country+"')");
out.println("Data is successfully inserted");

For the above code, we have created following database table:

CREATE TABLE `employee` (
`userid` bigint(30) NOT NULL auto_increment,
`firstname` varchar(40) default NULL,
`lastname` varchar(40) default NULL,
`username` varchar(40) default NULL,
`password` varchar(40) default NULL,
`email` varchar(100) default NULL,
`address` varchar(255) default NULL,
`contactNo` int(255) default NULL,
`city` varchar(255) default NULL,
`state` varchar(255) default NULL,
`country` varchar(255) default NULL,
PRIMARY KEY (`userid`)



Related Tutorials/Questions & Answers:
project  i need a project in java backend sql
PROJECT  i want online polling system project codding
project  suggest a network security project based on core java with explanation
project  sir i want a java major project in railway reservation plz help me and give a project source code with entire validation thank you
project  does hostel management system project contain any dynamic web pages
project  sir i want module and source code on my project hospital management system
PROJECT  i want help on making project on mobile banking application..... the application should have SAVING ACCOUNT,CURRENT ACCOUNT,TRANSACTION ETC......... IN APPLICATION
project  i have to do my final year project project topic:Weekly Automatic College Timetable Generation System BRIEF EXPLANATION ABOUT PROJECT This project takes various inputs from the user such as Teacher List, Course List
project  sir i want to a project on railway reservation,sir plz give me the source code   plz give me the source code of railway reservation
project   hi , we r working on one project related to our results. we using java and for back end sqlserver 2005. In dis we are trying to retrieve result from some site and store it in our data base so that we can perform
Project  Hi, Am starting a new project to draw a 2d graph using java swing and opengl,where in the input for X-axis and Y-axis co=ordinates should be accepted from user... As am very new to this am seeking help so pls help
project  For my project their is 2 users, one is users and administers.i want code for giving authentication to these users by using one, means same login form and database table back end is mysgl....and am using wamp sever
project..  Write a program to find the result of N students by accepting 5-subject marks from a Mark class and calculate the total and average mark. Display the result of all students in ascending order of rank from Result class
Project  &lt;% String project no=request.getParameter("project no"); String qry="select stud name,project name,project type,project...(receipt dt,'dd/mm/yyyy') from proj master "; qry+=" where project
Project  How to show Questions randomly so that no two student get the same questions in online examination system project in Java Server Pages  
project...   enter 10 integers, store it using array then display them from highest to lowest. 2.enter 10 integers, store it using array then display them from lowest to highest number to words conversion create a java program
project  I'm designing a netbeans java program/project. I have to design a program that captures the persons name and mark #.then find the average mark of the whole class.after that need to count and display who had the highest
=(String) vdata.get(1); String project_name=(String) vdata.get(2); String project