java-programs

BatchUpdates

2011-02-11T11:45:00.005+05:30

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]);
}
}
}

CallableStmt

2011-02-11T11:45:00.003+05:30

import java.sql.*;
class CallableStmt
{
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");
CallableStatement pstmt=con.prepareCall("{call proc(?,?)}");
pstmt.setInt(1,10);
pstmt.setString(2,"arun");
pstmt.execute();
System.out.println("insert record is with Prepare Statement......");
con.close();
System.out.println("connection is closed");
}
}

PrepareStmtInput

2011-02-11T11:44:00.005+05:30

import java.io.*;
import java.sql.*;
class PrepareStmtInput
{
public static void main(String[] args) throws Exception
{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
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(?,?)");
System.out.println("Enteer emp no");
int empno=Integer.parseInt(br.readLine());
pstmt.setInt(1,empno);
System.out.println("enter emp name");
String empname=br.readLine();
pstmt.setString(2,"empname");
int a=pstmt.executeUpdate();
System.out.println("insert record is with Prepare Statement......"+a);
}
}

PrepareStmt

2011-02-11T11:44:00.003+05:30

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);
}
}

Prepare_statement

2011-02-11T11:44:00.001+05:30

// 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:

prepared statement is improves the performence

*/

Retrive_Records

2011-02-11T11:43:00.004+05:30

//Retriving the values from table student in a database

import java.sql.*;
public class Retrive_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

*/

UpdateRecord

2011-02-11T11:43:00.002+05:30

import java.sql.*;
class UpdateRecord
{
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();
int a=stmt.executeUpdate("update emp3 where name='rahul'");
System.out.println("no of rows are Updated:------->"+a);
}
}

Update_Records

2011-02-11T11:42:00.002+05:30

//Updating values in table student

import java.sql.*;
public class Update_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");
int a=stmt.executeUpdate("update student set sno=15 where sno=1");
System.out.println("Values are updated -------> "+a);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

/*
Explanation:

Here we use a SQL update Query
and it returns an interger value it indicates that how many record are updated.

*/

Statement_obj

2011-02-11T11:41:00.003+05:30

//Creating a Statement reference

import java.sql.*;
public class Statement_obj
{
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");

}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

/*
Explanation:

Here we are not creating a Statement object but
we are creating a reference variable to Statement interface
and we are creating a object which implements the Statement interface
(Most of the Techniclal Lazy people calls it as Statement object)

*/

Table_create

2011-02-11T11:41:00.001+05:30

//Creating a Table using java programe

import java.sql.*;
public class Table_create
{
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");
stmt.executeUpdate("create table student(sno number(5),name varchar2(10),place varchar2(10))");
System.out.println("Table is crated -------> ");
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

/*
Explanation:

Here we are used a method "executeUpdate()" it takes one parameter
as argument i.e SQL Query

*/

DisplayRecordIndex

2011-02-11T11:40:00.003+05:30

//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");
}
}

DisplayRecord

2011-02-11T11:40:00.001+05:30

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);
}
}
}

DeleteRecord

2011-02-11T11:39:00.002+05:30

import java.sql.*;
class DeleteRecord
{
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();
int a=stmt.executeUpdate("delete from emp3 where eno=1");
System.out.println("no of rows DeleteRecord:------->"+a);
con.close();
System.out.println("connection is closed");
}
}

Delete_Records

2011-02-11T11:38:00.005+05:30

//Deleting values in table student

import java.sql.*;
public class Delete_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");
int a=stmt.executeUpdate("delete from student where sno=1");
System.out.println("Values are deleted -------> "+a);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

/*
Explanation:

Here we use a SQL update Query
and it returns an interger value it indicates that how many record are deleted.

*/

InsertRecord

2011-02-11T11:38:00.002+05:30

import java.sql.*;
class InsertRecord
{
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();
int a=stmt.executeUpdate("insert into emp3 values(1,'rahul')");
System.out.println("no of rows inserted:------->"+a);
con.close();
System.out.println("connection is closed");
}
}

Insert_Records

2011-02-11T11:37:00.001+05:30

//inserting values into a table student

import java.sql.*;
public class Insert_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");
int a=stmt.executeUpdate("insert into student values(1,'rahul','hyd')");
System.out.println("Values are inseted -------> "+a);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

/*
Explanation:

Here we use a SQL insert Query
and it returns an interger value it indicates that how many record are inseted.

*/

DBConnect

2011-02-11T11:36:00.002+05:30

import java.sql.*;
class DBConnect
{
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();
stmt.executeUpdate("create table emp3(eno number(5),name varchar2(20))");
System.out.println("table is created......");
con.close();
System.out.println("connection is closed");
}
}

JDBC

2011-02-11T11:28:00.000+05:30

//Register orclae or thin driver using jdbc api

import java.sql.*;
public class DBRegister
{
public static void main(String args[])
{
try
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("thin driver is registerd");
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

/*
Explanation:

To execute this program we have to set the class path for "ojdbc14.jar" file
From the above programe "DriverManager" is a static class
"registerDriver" is method it takes one arugument i.e object of OracleDriver class
which is under "oracle.jdbc.driver" package

*/

Getting Connection from DataBase

2011-02-09T19:17:00.000+05:30

//get connection from DataBase using orclae or thin driver using jdbc api

import java.sql.*;
public class DBConnection
{
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");

}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Registeration faild");
}
}
}

/*
Explanation:

To get Connetion we has used "Connetion" interface
and getConnection method takes three parameters

1:URL
2:user name
3:password

*/

Registering Drivers

2011-02-09T19:13:00.000+05:30

read string

2011-02-04T11:58:00.002+05:30

// input from key board
import java.io.*;
class Inputstring
{
public static void main(String r[])throws IOException
{
//InputStreamReader id=new InputStreamReader(System.in);
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
System.out.println("enter a String vslue");
String s=br.readLine();
System.out.println("enter "+s);
}
}

read integer

2011-02-04T11:58:00.001+05:30

// input from key board

import java.io.*;

class Inputint

{

public static void main(String r[])throws IOException

{

InputStreamReader id=new InputStreamReader(System.in);

BufferedReader br=new BufferedReader(id);

System.out.println("enter a interger");

int s=Integer.parseInt(br.readLine());

System.out.println("enter "+s);

}

arthemetic operators using switch

2011-02-04T11:57:00.001+05:30

//arthemetic operators using switch

import java.io.*;

class Input2

{

public static void main(String[] args)throws IOException

{

char ch;

InputStreamReader ir=new InputStreamReader(System.in);

BufferedReader br=new BufferedReader(ir);

System.out.println("enter values of x");

int x=Integer.parseInt(br.readLine());

System.out.println("enter values of y");

int y=Integer.parseInt(br.readLine());

System.out.println("enter u r choice");

System.out.println("+ for additon");

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

System.out.println("/ for divide");

System.out.println("* for multipiy");

System.out.println("% for remainder");

ch=(char)br.read();

switch(ch)

{

case '+':

System.out.println("additon:"+(x+y));

break;

case '-':

System.out.println("sub:"+(x-y));

break;

case '*':

System.out.println("mul:"+(x*y));

break;

case '/':

System.out.println("divide:"+(x/y));

break;

case '%':

System.out.println("Remainder:"+(x%y));

break;

}

input from key board

2011-02-04T11:56:00.000+05:30

// input from key board

import java.io.*;

class Input1

{

public static void main(String r[])throws IOException

{

//InputStreamReader id=new InputStreamReader(System.in);

BufferedReader br=new BufferedReader(new InputStreamReader(System.in));

System.out.println("enter a double vslue");

double s=Double.parseDouble(br.readLine());

System.out.println("enter "+s);

}

InputStreamReader

2011-02-04T11:55:00.000+05:30

// input from key board

import java.io.*;

class Input

{

public static void main(String r[])throws IOException

{

InputStreamReader id=new InputStreamReader(System.in);

BufferedReader br=new BufferedReader(id);

System.out.println("enter achar");

char ch=(char)br.read();

System.out.println("enter "+ch);

}