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.
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 developmentproject 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 projectapplication
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 processcs 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 processProject 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 processJava 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 processProject 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 processcreate 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 processWant 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 processError 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
Mobile DevelopmentMobile Development Hi,
What is Mobile
Development and how I can...
Development is a term used for designing,
development, testing, releasing... application for your company. Then our software
development team will help you
App DevelopmentApp Development Hi,
Which is the best App
Development in India.... There are many companies providing App
Development services in India and around the world.
App
Development process includes:
Getting idea from client
Designing
iPad development outsourcing, payment,
project development
and release terms. Our team will start... a lot of
development cost by outsourcing iPad
development
project in India...iPad
development outsourcing
Save lot for cost cost by outsourcing iPad
Android Development development ??
Hi,
Java language is used to develop the application for android. You can download the Android SDK for the
development of Android... ) in google android
development...ADS_TO_REPLACE_2
Mobile App DevelopmentMobile App Development Hi,
What is the process of Mobile App
Development? How I can outsource my mobile application
development project and developed by an Indian developer?
Thanks
Mobile app development IndiaMobile app
development India Hi,
Which company is good for getting... looking for reliable company for outsourcing your mobile application
development project?
You have reached at right places. Rose India Technology is very experience
development environmentdevelopment environment in which operating system java developers will work in mnc companies (i.e unix,windows family..........).
Hi,
Developers are mostly using Windows OS for the
development of Java based
Ajax developmentAjax development Hi,
Which framework I should use in the
development of Rich Internet application for my client. My client is looking for highly interactive Ajax based application. Suggest me the frameworks to be used
web development.web
development. I have designed a website using asp.net in that i have used oracle as database,in that users can upload,view and edit their details.so,how to write code for edit,update and delete button in asp.net
PDT - PHP Development Tools;
PDT
Project
PHP
Development Tools
About PDTADS_TO_REPLACE_1
The PDT
project is working towards providing a PHP
Development Tools framework for the Eclipse platform. This
project will
encompass all
development Joomla Development IndiaJoomla
Development India
India is a front running company..., Directory,
Project management, Forum / message boards, Guest book, News... Custom
Modules
Development, Custom Component
Development, Joomla Module
Mobile App Development during
development.
We offer dedicated
project manager to look after the entire... Mobile App
Development Development company - Rose India
Mobile apps became... of sophisticated cross platform
development tools now businesses can easily their presence
What is Software development framework?What is Software
development framework? What is a software
development framework and what is its use?
Thanks
Hi,
Software
development... for making the application
development easy.
Check the page Software
development VoIP Development
VoIP
Development
VoIP
Development Platform
The VoIP
development...
development tools. The board has 4 FXS ports and 1 FXO port. It includes the Z.Voice....
There are some feature of VoIP
Development platform:- * 4FXS and 1FXO port
iPad Application Development in India and
development
methodology for building iPad applications. We use latest
project development...
iPad Application
Development in India
We provide iPad Application
Development service in India. Get your iPad and
iPhone application developed in India
Basic for iphone development??Basic for iphone
development?? hiii...
I want to go for iphone
development .. What are the basic for iphone
development can some body tell me...?????
hello,
if you want to go in iphone
development then i
Android app development companyAndroid app
development company Hi,
Which is most reliable Android app
development company in India?
Thanks
Hi,
Rose India is into
development of Android and iOS mobile applications in India.
Company develops
Mobile Application Development ServicesMobile Application
Development Services
Rose India Technologies is providing mobile application
development services
to individuals and corporates. We... employ latest mobile
development technologies to design, code, test and
release
iPhone App Development Development?
Thanks
Hi,
iPhone is one of the most famous device... provides XCode tool for application
development and testing.
iOS is the operating...
Development service in India and search for iOS developers then contact us at:
Mobile app
Offshore iPhone Apps DevelopmentOffshore iPhone Apps
Development
Since the origination of Apple's internet... of them.
Roseindia Technologies is a Delhi based software
development company that has
gained specialization in iPhone Application
Development. The product
Mobile fitness application development company services
development work to our client.
You have to discuss
project details...Mobile fitness application
development company Hi,
I am searching for mobile fitness application
development company from India. I need high impact
Eclipse - Integrated Development EnvironmentEclipse - Integrated
Development Environment
Eclipse IDE is extensively used... existing maven
project in Eclipse?
Learn the steps to import an existing maven
project into Eclipse IDE and
run the
project.
What is Web Development?What is Web
Development? As a end user what arises in your mind. Like "What is Web
development". Can any one explain with some examples.
Thanks
Language in iphone development??Language in iphone
development?? What programming language we use in iphone
development???
hello,
we are using Objective C in iphone development.ADS_TO_REPLACE_1
Offshore iPhone Development Development Project as well as
iPhone Content and iPhone compatible Website...Offshore iPhone
Development
With the evolution of Apple's iPhone (internet...
development for iPhone has boomed and several companies
are claiming to develop
web development traineeweb
development trainee How to store data and retrieve the stored data pleas give me details with examples
j2ee - Development processJ2EE
Development Process What is mean by J2EE
Development process? hi bhuvana,i think i may answer ur ques.see i can tell u in java script if u needed
Software Development Process Models development of a software
project.
Software
project management is a part of
project management especially designed for the management of software
development projects... successful software, it is very necessary to plan an effective software
project library files - Development processlibrary files Hi members, i am trying to develop a media player in java using netbeans but
what library files should i import for this
development website development in JSPwebsite
development in JSP I am requesting everyone again to please provide me with some idea on how can we implement video chatting in JSP please be helpful. Thanx