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



Home Answers Viewqa JSP-Servlet project development
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


S.MAHESHREDDY
project development
1 Answer(s)      2 years ago
Posted in : JSP-Servlet


i have one html page called register.html page it will be contain more number of fields and i am enter data stored in access database and i want code for jsp or servlets through access database urgent sir.


Advertisement
View Answers

November 26, 2012 at 6:01 PM


Here is a code that creates a registration form and save the data to Access database.

Follow these steps to set up the connection:

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 code.

1)register.jsp

<html>
<form method="post" action="insert.jsp">
<table>
<tr><td>First Name:</td><td><input type="text" name="fname"></td></tr>
<tr><td>Last Name:</td><td><input type="text" name="lname"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email"></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass"></td></tr>
<tr><td>Confirm Password:</td><td><input type="password" name="cpass"></td></tr>
<tr><td>Date Of Birth</td><td><input type="text" name="dob"></td></tr>
<tr><td>Age:</td><td><input type="text" name="age"></td></tr>
<tr><td>Gender</td><td><input type="text" name="gender"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></td></tr>
<tr><td>Country</td><td><input type="text" name="country"></td></tr>
<tr><td>State:</td><td><input type="text" name="state"></td></tr>
<tr><td>City</td><td><input type="text" name="city"></td></tr>
<tr><td>Telephone No:</td><td><input type="text" name="tno"></td></tr>
<tr><td>Mobile:</td><td><input type="text" name="mobile"></td></tr>
<tr><td>Language:</td><td><select name="lang">
<option value="C/C++">C/C++</option>
<option value="C#">C#</option>
<option value="Java">Java</option>
<option value="Perl">Perl</option>
<option value="Python">Python</option>
</select></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)insert.jsp:

<%@page import="java.sql.*,java.util.*"%>
<%
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String email=request.getParameter("email");
String pass=request.getParameter("pass");
String cpass=request.getParameter("cpass");
String dob=request.getParameter("dob");
int age=Integer.parseInt(request.getParameter("age"));
String gender=request.getParameter("gender");
String address=request.getParameter("address");
String country=request.getParameter("country");
String state=request.getParameter("state");
String city=request.getParameter("city");
int telephone=Integer.parseInt(request.getParameter("tno"));
int mobile=Integer.parseInt(request.getParameter("mobile"));
String lang=request.getParameter("lang");

        try{
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         Connection con = DriverManager.getConnection("jdbc:odbc:access");

           Statement st=con.createStatement();
           int i=st.executeUpdate("insert into student(firstname,lastname,email,pass,confirm_pass,dob,age,gender,address,country,state,city,telephone,mobile,language) values('"+fname+"','"+lname+"','"+email+"','"+pass+"','"+cpass+"','"+dob+"',"+age+",'"+gender+"','"+address+"','"+country+"','"+state+"','"+city+"',"+telephone+","+mobile+",'"+lang+"')");
        out.println("Data is successfully inserted!");
        }
        catch(Exception e){
        System.out.print(e);
        e.printStackTrace();
        }
        %>


Related Tutorials/Questions & Answers:
project development
project development  i have one html page called register.html page it will be contain more number of fields and i am enter data stored in access database and i want code for jsp or servlets through access database urgent sir
application development project
application development project   enter 10 integers, store it using array then display them from highest to lowest. 2.enter 10 integers, store... -plz answer my question..i hope that u can help us in our project..thank you:D
Advertisements
cs project - Development process
cs project  hello sir i am doing my masters in cs ,i have given a project by professor ,title is gossiping protocol,i have no project developing experience,please help me how to start the project from scratch like how to start
Project Question - Development process
Project Question  hello sir ,i have project in visual basic 6.0 ,i want to convert it in to visual basic.net2008 how i can convert it. plz Help Me its very very urgent
Java Project - Development process
Java Project  Hello Sir I want Java Project for Time Table of Buses.that helps to search specific Bus Time and also add ,Update,Delete the Bus Routes. Back End MS Access Plz Give Me
Project Location change - Development process
Project Location change  Hi , I have developed mini project . In my... ,ow can i run that project. Now i installed weblogic in tat system also. but still am getting 503 error. Is there any possibility to run my project in LAN
create a login project - Development process
create a login project  How to make an application(project)OF LOGIN APPLICATION USING MYSQL DATA BASE TO REGISTER AND LOGIN IN JSF FRAMEORK.  Hi friend, For solving the problem visit to : http://roseindia.net/jsf
Want Mini project - Development process
Want Mini project  Hi Can u plz send me mini project.I want to learn Dao, DaoImpl, Service,ServiceImpl, DTO, Action class, HibernateDao, HibernateDaoImpl, i.e; I want mini project implementing all concepts like jsp ,struts
Error in Shopping Cart project - Development process
Error in Shopping Cart project  I tried running the shopping cart project given in the below link: http://www.roseindia.net/shoppingcart... when I submit "http://localhost:8080/cart" I received the following error
deploy stand alone java project in JBoss - Development process
deploy stand alone java project in JBoss  i hv a stand alone java project nad a web project to be run on Jboss. from the web project i am calling the classes in stand alone java project. but i dont know how to deploy the stand
College Student Admission System Project in Java - Development process
College Student Admission System Project in Java   Front End -JAVA Back End - MS Access Hello Sir, I want College Student Admission Project in Java with Source code, that includes Following Forms 1) Student Admission
Java Error in Bus Time Table Project - Development process
*; import java.sql.*; import java.util.*; class Project{ JFrame f; JPanel...; GridBagConstraints gbc; Project(){ f=new JFrame("Bus TimeTable"); p=new JPanel(); p1
Java Project Outsourcing, Java Outsourcing Projects, Oursource your Java development projects
Java Project Outsourcing - Outsource Java development projects Java... Java project development services are cost effective and most beneficial... the development and release of the project We following quality
project
project  suggest a network security project based on core java with explanation
PROJECT
PROJECT  i want online polling system project codding
project
project  i need a project in java backend sql
project
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
project  sir i want module and source code on my project hospital management system
project
project  does hostel management system project contain any dynamic web pages
PROJECT
PROJECT  i want help on making project on mobile banking application..... the application should have SAVING ACCOUNT,CURRENT ACCOUNT,TRANSACTION ETC......... IN APPLICATION
project
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
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
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
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 ..my back end is mysgl....and am using wamp sever
Project
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..
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
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
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
project...
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
Project  How to show Questions randomly so that no two student get the same questions in online examination system project in Java Server Pages  
Advertisements
 

 

 

DMCA.com