jsp MySQL database connectivity
BaabtraMentoringPartner
4,109 views
20 slides
Nov 16, 2013
Slide 1 of 20
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
About This Presentation
jsp MySQL database connectivity
Slide Content
Disclaimer: This presentation is prepared by trainees of baabtra as a part of mentoring program. This is not official document of baabtra –Mentoring Partner Baabtra-Mentoring Partner is the mentoring division of baabte System Technologies Pvt . Ltd
jsp MySQL database connectivity Shanu k k [email protected] www.facebook.com/shanunni twitter.com/ shanu in.linkedin.com/in/ shanu k k 9656153432
Week Target Achieved 1 25 25 2 30 27 3 29 30 Typing Speed
Jobs Applied # Company Designation Applied Date Current Status 1 www.noukri.com 2 www.shine.com 3 www.fresherworld.com
Accessing data in a database or in other data sources is an important task in web programming . data access from JSPs is done through Java Database Connectivity (JDBC). We will begin with an introduction to JDBC
Here are the steps required to access data in a database : Load the JDBC database driver . Create a connection. Create a statement. Create a resultset , if you expect the database server to send back some data.
There are two packages in JDBC java.sql javax.sql The javax.sql package is the JDBC Optional Package
DriverManager Class The DriverManager class is used to obtain a connection to a database . Database servers use their own proprietary protocols for communication, which are different from each other. However, we don't need to worry about these protocols because we can use "translators." These "translators" come in the form of JDBC drivers For an jDBC database, use the following code to load the driver: Class.forName (" com.mysql.jdbc.Driver ");
The Connection Interface To access a database, first you need to establish a connection to the database server . Connection connection = DriverManager.getConnection ( url , "root", " baabtra "); The most frequently used method of the Connection interface is createStatement (), which returns a Statement object for sending SQL statements to the database.
Statement Interface the Statement interface method to execute an SQL statement and obtain the produced results . Statement statement = connection.createStatement (); The two most important methods of this interface are executeQuery () and executeUpdate (). The executeUpdate () method executes an SQL INSERT, UPDATE, or DELETE statement The executeQuery () method executes an SQL SELECT statement that returns data.
<%@ page language = "java" contentType =" text /html; charset =ISO-8859-1" pageEncoding = "ISO-8859-1"%> <%@ page import = "java.sql.*" %> <%@ page import = "javax.sql.*" %> < html> <head> <meta http-equiv= "Content-Type" content="text/html; charset =ISO-8859-1"> <title>Front</title> </head> <body> <%
<% String name= request.getParameter ("name"); String password= request.getParameter ("pass"); String adress = request.getParameter ("address"); String dob= request.getParameter ("dob"); String url = " jdbc:mysql ://localhost:3306/ db_tes "; if(name!="" && password!="" && adress !="" && dob!="") { try { String insert = "INSERT INTO tbl_adress ( name,password,adress,DOB )" + "VALUES (? ,?, ?, ?)"; Class.forName (" com.mysql.jdbc.Driver "); Connection con = DriverManager.getConnection ( url , "root", " baabtra "); PreparedStatement ps = con.prepareStatement (insert);
ps.setString (1,name); ps.setString (2,password); ps.setString (3,adress); ps.setString (4,dob); ps.executeUpdate (); con.close (); } catch (Exception ex) { out.println ("error"); } } %>
<form action= "registration form.jsp" method="POST"> <table> < tr > < br > <td>Name</ br ></td> <td> <input type= "text" name="name"> </td> </ tr > < tr > < br ><td>Password</ br ></td> <td> <input type= "password" name="pass"> </td> </ tr >
< tr > < br ><td>date of birth</ br ></td> <td> <input type= "text" name="dob"> </td> </ tr > < tr > < br ><td> Adress </ br ></td> <td> < textarea name= "address"></ textarea > </td> </ tr > < br > < tr > <td><input type= "submit" value="register"></td> </ tr >
</table> < br > <hr> Already Registered!! To Login <a href = "login.jsp">Click Here</a> <hr> </form> </body> </html>
If this presentation helped you, please visit our page facebook.com/ baabtra and like it. Thanks in advance . www.baabtra.com | www.massbaab.com | www.baabte.com
Contact Us Emarald Mall (Big Bazar Building) Mavoor Road, Kozhikode, Kerala, India. Ph: + 91 – 495 40 25 550 NC Complex, Near Bus Stand Mukkam , Kozhikode, Kerala, India. Ph: + 91 – 495 40 25 550 Start up Village Eranakulam , Kerala, India. Email: [email protected]
Categories
GeneralDownload
Download Slideshow Get the original presentation fileQuick Actions
Statistics
- Views 4,109
- Slides 20
- Favorites 1
- Age 4398 days
Related Slideshows
22
Pray For The Peace Of Jerusalem and You Will Prosper
RodolfoMoralesMarcuc
30 views
26
Don_t_Waste_Your_Life_God.....powerpoint
chalobrido8
32 views
31
VILLASUR_FACTORS_TO_CONSIDER_IN_PLATING_SALAD_10-13.pdf
JaiJai148317
30 views
14
Fertility awareness methods for women in the society
Isaiah47
29 views
35
Chapter 5 Arithmetic Functions Computer Organisation and Architecture
RitikSharma297999
26 views
5
syakira bhasa inggris (1) (1).pptx.......
ourcommunity56
28 views