Store the data in "ArrayList" object

/* Retrieves the Records form data base and store the data in ArrayList object */
import java.sql.*;
public class Store_Records

{
public static void main(String args[])
{
try
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("thin driver is registerd");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
System.out.println("Connection is established to DB");
Statement stmt=con.createStatement();
System.out.println("Statement object is created");
ResultSet rs=stmt.executeQuery("select *from student");
System.out.println("sno"+" "+"name"+" "+"place");
System.out.println("--------------------------------------");
ArrayList a=new ArrayList();
while(rs.next())
{
a.sadd("sno");
a.add("name");
a.add("place");
}
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

web.xml file

<web-app>
<context-param>
<param-name>driverclassname</param-name>
<param-value>oracle.jdbc.driver.OracleDriver</param-value>
</context-param>
<context-param>
<param-name>url</param-name>
<param-value>jdbc:oracle:thin:@localhost:1521:xe</param-value>
</context-param>
<servlet>
<servlet-name>ab</servlet-name>
<servlet-class>AddBook</servlet-class>
<init-param>
<param-name>dbuser</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>dbpass</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>sqlstatement</param-name>
<param-value>insert into AddBook values(?,?,?,?)</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>ab</servlet-name>
<url-pattern>/AddBook</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>srf</servlet-name>
<servlet-class>StudentRegForm</servlet-class>
<init-param>
<param-name>dbuser</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>dbpass</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>sqlstatement</param-name>
<param-value>insert into AddBook values(?,?,?,?,?,?,?)</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>srf</servlet-name>
<url-pattern>/StudentRegForm</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>af</servlet-name>
<servlet-class>AddFee</servlet-class>
<init-param>
<param-name>dbuser</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>dbpass</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>sqlstatement</param-name>
<param-value>insert into AddBook values(?,?,?,?,?,?,?,?)</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>af</servlet-name>
<url-pattern>/AddFee</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>ul</servlet-name>
<servlet-class>UserLogin</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ul</servlet-name>
<url-pattern>/UserLogin</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>al</servlet-name>
<servlet-class>AdminLogin</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>al</servlet-name>
<url-pattern>/AdminLogin</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>sb</servlet-name>
<servlet-class>SearchBook</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>sb</servlet-name>
<url-pattern>/SearchBook</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>fee</servlet-name>
<servlet-class>Fee</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>fee</servlet-name>
<url-pattern>/Fee</url-pattern>
</servlet-mapping>

<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list>
</web-app>

Next Link Program

Fee java File

import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class Fee extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sysrem","system");
ps=con.prepareStatement("select *from AddBook where bookname=?");
}
catch(Exception e)
{
e.printStackTrace();
}

}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String fee=request.getParameter("fee");
if(fee==null||fee.equals(""))
{
out.println("<html><body>");
out.println("<li><i>enter the course</i></li><br/>");
out.println("</body></html>");
}
ps.setString(1,fee);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.println("<html><body>");
out.println("<table border=1>");
out.println("<tr><td>rs.getString(1)<td>");
out.println("<td>rs.getString(2)</td>");
out.println("<td>rs.getString(3)</td>");
out.println("<td>rs.getString(4)</td>");
out.println("<tr><td>rs.getString(5)<td>");
out.println("<td>rs.getString(6)</td>");
out.println("<td>rs.getString(7)</td>");
out.println("<td>rs.getString(8)</td>");
out.println("</tr></table>");
out.println("</body></html>");
}
}
catch(Exception e)
{
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}

Next Link Programe

AddBook java file

import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class AddBook extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{ //we get the information from the web.xml file
ServletContext ctxt=getServletContext();
String driverclassname=ctxt.getInitParameter("driverclassname");
String url=ctxt.getInitParameter("url");
String dbuser=ctxt.getInitParameter("dbuser");
String dbpass=ctxt.getInitParameter("dbpass");
String sqlstmt=ctxt.getInitParameter("sqlstatement");
con=DriverManager.getConnection(url,dbuser,dbpass);
ps=con.prepareStatement(sqlstmt);
}
catch(Exception e)
{
e.printStackTrace();
}

}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String bookname=request.getParameter("bookname");
String auther=request.getParameter("auther");
String bookno=request.getParameter("bookno");
String desc=request.getParameter("desc");

ps.setString(1,bookname);
ps.setString(2,auther);
ps.setString(3,bookno);
ps.setString(4,desc);
int count=ps.executeUpdate();
if(count==1)
{
out.println("successfully added a book");
}
else
{
out.println("<html><body><h1> sorry try again</h1></body></html>");
}
}
catch(Exception e)
{
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}

Next Link Program

UserLogin Java File

import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class UserLogin extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sysrem","system");
ps=con.prepareStatement("select *from StudentRegForm where name=? and pass=?");
}
catch(Exception e)
{
e.printStackTrace();
}

}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String name=request.getParameter("name");
String pass=request.getParameter("pass");
if(name==null||name.equals("")||pass==null||pass.equals(""))
{
out.println("<html><body>");
out.println("<li><i>user name and pass word cnt be empty</i></li><br/>");
out.println("</body></html>");
}
ps.setString(1,name);
ps.setString(2,pass);
}
catch(Exception e)
{
out.println("<h2>un ble</h2>");
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}
Next Link Program

StudentRegForm Java file

import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class StudentRegForm extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{ //we get the information from the web.xml file
ServletContext ctxt=getServletContext();
String driverclassname=ctxt.getInitParameter("driverclassname");
String url=ctxt.getInitParameter("url");
String dbuser=ctxt.getInitParameter("dbuser");
String dbpass=ctxt.getInitParameter("dbpass");
String sqlstmt=ctxt.getInitParameter("sqlstatement");
con=DriverManager.getConnection(url,dbuser,dbpass);
ps=con.prepareStatement(sqlstmt);
}
catch(Exception e)
{
e.printStackTrace();
}

}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String sname=request.getParameter("sname");
String sid=request.getParameter("sid");
String pwd=request.getParameter("pwd");
String course=request.getParameter("course");
String email=request.getParameter("email");
String phone=request.getParameter("phone");
String addr=request.getParameter("addr");

ps.setString(1,sname);
ps.setString(2,sid);
ps.setString(3,pwd);
ps.setString(4,course);
ps.setString(5,email);
ps.setString(6,phone);
ps.setString(7,addr);
int count=ps.executeUpdate();
if(count==1)
{
out.println("successfully added a book");
}
else
{
out.println("<html><body><h1> sorry try again</h1></body></html>");
}
}
catch(Exception e)
{
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}

Next Link Program

search a book

	<html>
	<head>
	<title>Search A Books</title>
	</head>
	<body bgcolor="#ffeebb">
	<div style="position:absolute;left:200;top:100;">
	<form name="sregform">
	<table border=0 bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>Search A Books</h2></center></td></tr>
	<tr><td>Book Name</td><td><input type="text" name="dur"></td></tr>
	<tR><td colspan="2"><center><button value="search">SEARCH</center></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Program

add book to library

	<html>
	<head>
	<title>Add Books TO Library</title>
	</head>
	<body bgcolor="#ffeebb" action="./AddBook">
	<div style="position:absolute;left:200;top:100;">
	<form name="sregform">
	<table border=0 bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>Add New Books TO Library</h2></center></td></tr>
	<tr><td>Book Name</td><td><input type="text" name="bookname"></td></tr>
	<tr><td>Auther</td><td><input type="text" name="auther"></td></tr>
	<tr><td>Book No</td><td><input type="text" name="bookno"></td></tr>
	<tr><td>Description</td><td><textarea rows=4 cols=17 name="desc"></textarea></td></tr>
	<tR><td colspan="2"><center><button value="OK">OK</center></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Program

get course details

	<html>
	<head>
	<title>Course</title>
	</head>
	<body bgcolor="#ffeebb" action="./Course">
	<div style="position:absolute;left:200;top:100;">
	<form name="">
	<table bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>Get Course Details</h2></center></td></tr>
	<tr><td>Course</td>
	<td>
	<select name="course">
	<option value="B.Tech">B.Tech</option>
	<option value="B.Sc">B.Sc</option>
	<option value="pharmacy">pharmacy</option>
	<option value="mca">MCA</option>
	<option value="mba">MBA</option>
	<option selected value="select course">select course</option>
	</select></td></tr>
	<tr><td colspan="2"><center><button>Get Details</button></center></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Program

user login form

	<html>
	<head>
	<title>User Login</title>
	</head>
	<body bgcolor="#ffeebb" action="./UserLogin">
	<div style="position:absolute;left:200;top:100;">
	<form name="sregform">
	<table border=0 bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>User Login</h2></center></td></tr>
	<tr><td>Student Name</td><td><input type="text" name="name"></td></tr>
	<tr><td>PassWord</td><td><input type="text" name="pwd"></td></tr>
	<tR><td colspan="2"><center><input type="submit" value="login"></center></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Programe

student reg form

	<html>
	<head>
	<title>student registration form</title>
	</head>
	<body bgcolor="#ffeebb" action="./StudentRegForm">
	<div style="position:absolute;left:200;top:100;">
	<form name="sregform">
	<table border=0 bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>Student Registration Form</h2></center></td></tr>
	<tr><td>Student Name</td><td><input type="text" name="sname"></td></tr>
	<tr><td>Student ID</td><td><input type="text" name="sid"></td></tr>
	<tr><td>Password</td><td><input type="text" name="pwd"></td></tr>
	<tr><td>Re-type pass word</td><td><input type="text" name="rpwd"></td></tr>
	<tr><td>Course</td><td><select name="course">
	<option value="B.Tech">B.Tech</option>
	<option value="B.Sc">B.Sc</option>
	<option value="pharmacy">Pharmacy</option>
	<option value="mca">MCA</option>
	<option value="mba">MBA</option>
	<option selected value="select course">select course</option>
	</select></td></tr>
	<tr><td>Email</td><td><input type="text" name="email"></td></tr>
	<tr><td>Phone</td><td><input type="text" name="phone"></td></tr>
	<tr><td>Address</td><td><textarea rows=4 cols=17 name="addr"></textarea></td></tr>
	<tR><td><input type="submit" value="REGISTER"></td><td><input type="reset"></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Programe

Home Page

	<html>
	<head>
	</head>
	<frameset rows="20%,80%">
	<frame src="./log.html">
	<frameset cols="20%,60%,20%">
	<frame src="./sub.html">
	<frame src="./blank.html" name="mid">
	<frame src="./adds.html">
	</frameset>
	</frameset> </html> Next Link Programe

Display Records as Normal

Display Record

import java.sql.*;
class DisplayRecord
{
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select eno,name from emp3");
System.out.println(rs);
while(rs.next())
{
int deno=rs.getInt("eno");
System.out.println("Eno: "+deno);
String s=rs.getString("name");
System.out.println("Nane: "+s);
}
}
}

Using Index Retrive Data From The Table
Using Prepared Statement
retrieve-records

Display Record Using Index

DisplayRecordIndex

//Retrive the data from DB and display it Using with INDEXS

import java.sql.*;
import java.sql.*;
class DisplayRecordIndex
{
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select eno,name from emp3");
System.out.println(rs);
while(rs.next())
{
int deno=rs.getInt(1);
System.out.println("Eno: "+deno);
String s=rs.getString(2);
System.out.println("Nane: "+s);
}
con.close();
System.out.println("connection is closed");
}
}


Using Prepared Statement 
retrieve-records

PrepareStmt_insert operation

PrepareStmt_insert operation

import java.sql.*;
class PrepareStmt
{
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
PreparedStatement pstmt=con.prepareStatement("insert into emp3 values(?,?)");
pstmt.setInt(1,10);
pstmt.setString(2,"anjali");
int a=pstmt.executeUpdate();
System.out.println("insert record is with Prepare Statement......"+a);
}
}



Using Index Retrive Data From The Table
retrieve-records

Prepare_statement

Prepare_statement

// PrepareStatement retriving the values from table student in a database

import java.sql.*;
public class Prepare_statement

{
public static void main(String args[])
{
try
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("thin driver is registerd");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
System.out.println("Connection is established to DB");
PreparedStatement pstmt=con.prepareStatement("select *from student where sno=?");
System.out.println("preparedStatement object is created");
pstmt.setInt(1,15);
ResultSet rs=pstmt.executeQuery();
System.out.println("sno"+" "+"name"+" "+"place");
System.out.println("--------------------------------------");
while(rs.next())
{
System.out.println();
System.out.print(rs.getInt("sno")+" ");
System.out.print(rs.getString("name")+" ");
System.out.print(rs.getString("place"));
}
pstmt.executeQuery();
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

/*
Explanation:
Table in Database:

create table student(sno number(10),name varchar2(20),place varchar2(20));

prepared statement is improves the performence

*/

http://java-rules.blogspot.com/2011/09/display-record-using-index.html

http://java-rules.blogspot.com/2011/09/display-records-as-normal.html

http://java-rules.blogspot.com/2011/09/preparestatement.html

http://java-rules.blogspot.com/2011/09/retrieve-records.html

http://java-rules.blogspot.com/2011/09/retrive-data-from-table-in-db-using.html

Retrieve Records

Retrieve_Records

//Retrieving the values from table student in a database

import java.sql.*;

public class Retrieve_Records

{

public static void main(String args[])

{

try

{

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

System.out.println("thin driver is registerd");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");

System.out.println("Connection is established to DB");

Statement stmt=con.createStatement();

System.out.println("Statement object is created");

ResultSet rs=stmt.executeQuery("select *from student");

System.out.println("sno"+" "+"name"+" "+"place");

System.out.println("--------------------------------------");

while(rs.next())

{

System.out.println();

System.out.print(rs.getInt("sno")+" ");

System.out.print(rs.getString("name")+" ");

System.out.print(rs.getString("place"));

}

}

catch(Exception e)

{

e.printStackTrace();

System.out.println("Registeration faild");

}

}

}

/*

Explanation:

For Select Querys we have to use the "executeQuery" method

it return the Results into a ResultSet object

by using next() method we can move the next row from one row to anethor

here we used differnt type getter method(we can use getString() for all data types)

but its not recomended

TRy with different type select querys

*/

Using Index Retrive Data From The Table
Using Prepared Statement 

Batch Updates

BatchUpdates

import java.sql.*;
class BatchUpdates
{
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
Statement stmt=con.createStatement();
String s1="insert into emp3 values(1,'rahul')";
String s2="insert into emp3 values(2,'arun')";
String s3="insert into emp3 values(3,'pavan')";
String s4="insert into emp3 values(4,'gopi')";
String s5="insert into emp3 values(2,'arun')";
String s6="insert into emp3 values(2,'arun')";
stmt.addBatch(s1);
stmt.addBatch(s2);
stmt.addBatch(s3);
stmt.addBatch(s4);
stmt.addBatch(s5);
stmt.addBatch(s6);
int a[]=stmt.executeBatch();
for(int i=0;i<=a.length;i++) { System.out.println("no of rows inserted:------->"+a[i]);
}
}
}

Connect To DataBase and Creating a File

Connect To Data Base and Creating a File

import java.sql.*;
class DBConnect
{
public static void main(String[] args) throws Exception
{
//Step 1: register the Driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//Step 2: get the connetion using the Connection interface
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
//Step 3: get statement reference variaable
Statement stmt=con.createStatement();
//Step 4: execute Query
stmt.executeUpdate("create table emp3(eno number(5),name varchar2(20))");
System.out.println("table is created......");
//Step 5: close the connetion
con.close();
System.out.println("connection is closed");
}
}

Retrive the data from the table in db using java(jdbc)

DisplayRecord

import java.sql.*;
class DisplayRecord
{
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select eno,name from emp3");
System.out.println(rs);
while(rs.next())
{
int deno=rs.getInt("eno");
System.out.println("Eno: "+deno);
String s=rs.getString("name");
System.out.println("Nane: "+s);
}
}
}