Java Example Event Programming

JDBC Program

import java.sql.*;
import java.sql.Types.*;
import java.util.*;
import java.io.*;
class callstatapp
{
public static final int VARCHAR=2;
public static void main(String args[])
{
try
{
String st;
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcoracle";
Connection con=DriverManager.getConnection(url,"palani","kumar");
CallableStatement cst;
cst=con.prepareCall("?=call fun");
con.close();
cst.registerOutParameter(1,VARCHAR);
st=cst.getString(1);
System.out.println("The result is "+st);
}
catch(Exception ex)
{
System.out.println(ex);
System.exit(0);
}
}
}
import java.sql.*;
import java.util.*;
class connecapp
{
public static void main(String sarg[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcoracle";
Connection con=DriverManager.getConnection(url);
DatabaseMetaData meta=con.getMetaData();
System.out.println("database : "+meta.getDatabaseProductName());
System.out.println("version : "+meta.getDatabaseProductVersion());
System.out.println("username : "+meta.getUserName());
con.close();
}
catch(Exception ex)
{
System.out.println(ex);
System.exit(0);
}
}
}
import java.sql.*;
class dbcon
{
static Connection con;
public static void main(String a[ ]) throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
try
{
con = DriverManager.getConnection("jdbc:odbc:empdsn","palani","kumar");
System.out.println("Connected to database");
Statement s = con.createStatement();
int rows = s.executeUpdate("Insert into emp values(110,'murali1',19000)");
System.out.println(rows + " rows inserted");
rows = s.executeUpdate("Update emp set salary=1200 where empid=120");
System.out.println(rows + " rows updated");
s.close();
con.close();
}
catch(SQLException e)
{
System.out.println("not Connected to database"+ e);
}
}
}
import java.sql.*;
class dbcon1
{
static Connection con;
public static void main(String a[ ]) throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
try
{
con = DriverManager.getConnection("jdbc:odbc:odbcoracle","palani","kumar");
System.out.println("Connected to database");
Statement s = con.createStatement();
int rows = s.executeUpdate("create table runtt (sno number, sname varchar2(20))");
System.out.println(rows + " table created");
s.close();
con.close();
}
catch(SQLException e)
{
System.out.println("not Connected to database"+ e);
}
}
}
import java.sql.*;
import java.util.*;
class driverapp
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Enumeration drivers=DriverManager.getDrivers();
System.out.println("The list of drivers in the system");
while(drivers.hasMoreElements())
{
Driver driver=(Driver)drivers.nextElement();
System.out.println("Driver: "+driver.getClass().getName());
System.out.println("Major version: "+driver.getMajorVersion());
System.out.println("Minor version: "+driver.getMinorVersion());
System.out.println("JDBC complaint: "+driver.jdbcCompliant());
DriverPropertyInfo props[]=driver.getPropertyInfo(" ",null);
if(props!=null)
{
System.out.println("The list of properties");
for(int i=0;i less than props.length;i++)
{
System.out.println(" Name : "+props[i].name);
System.out.println(" Description : "+props[i].description);
System.out.println(" value : "+props[i].value);
if(props[i].choices!=null)
{
System.out.println("The list of choices");
for(int j=0;i less than props[i].choices.length;j++)
System.out.println(" "+props[i].choices[j]);
}
System.out.println("requires :"+props[i].required);
}
}
}
}
catch(Exception ex)
{
System.out.println(ex);
System.exit(0);
}
}
}
import java.sql.*;
import java.util.*;
import java.io.*;
class prestat
{
public static void main(String args[])
{
int i=1;
try
{
String no;
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcoracle";
Connection con=DriverManager.getConnection(url,"palani","kumar");
PreparedStatement pst;
ResultSet rs;
boolean hasResults;
while(i<=2)
{
pst=con.prepareStatement("insert into tt values(?)");
System.out.println("\n Enter the employee no needed");
no=br.readLine();
System.out.println("\n The employee number chosen is "+no);
pst.setString(1,no);
hasResults=pst.execute();
if(hasResults)
{
rs=pst.getResultSet();
if(rs!=null)
disp(rs);
hasResults=false;
}
i=i+1;
}
con.close();
}
catch(Exception ex)
{
System.out.println(ex);
System.exit(0);
}
}
static void disp(ResultSet r) throws SQLException
{
System.out.print(r.getString(1));
boolean m =r.next();
System.out.print(r.getString(1));
}
}
}
import java.sql.*;
import java.util.*;
import java.io.*;
class prestatapp
{
public static void main(String args[])
{
int i=1;
try
{
String no;
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcoracle";
Connection con=DriverManager.getConnection(url,"palani","kumar");
PreparedStatement pst;
ResultSet rs;
boolean hasResults;
while(i<=3)
{
pst=con.prepareStatement("insert into tt values(?)");
System.out.println("\n Enter the employee no needed");
no=br.readLine();
System.out.println("\n The employee number chosen is "+no);
pst.setString(1,no);
hasResults=pst.execute();
if(hasResults)
{
rs=pst.getResultSet();
if(rs!=null)
disp(rs);
hasResults=false;
}
i=i+1;
}
con.close();
}
catch(Exception ex)
{
System.out.println(ex);
System.exit(0);
}
}
static void disp(ResultSet r) throws SQLException
{
ResultSetMetaData rmeta=r.getMetaData();
int numcol=rmeta.getColumnCount();
for(int i=1;i less than numcol;++i)
System.out.print(rmeta.getColumnName(i));
while(r.next())
{
for(int i=1;i less than numcol;++i)
System.out.print(r.getString(i));
}
}
}
import java.sql.*;
import java.util.*;
class resulapp
{
public static void main(String sarg[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcoracle";
Connection con=DriverManager.getConnection(url,"palani","kumar");
Statement st=con.createStatement();
String sql="select * from emp";
ResultSet rs=st.executeQuery(sql);
disp(rs);
con.close();
}
catch(Exception ex)
{
System.out.println(ex);
System.exit(0);
}
}
static void disp(ResultSet r) throws SQLException
{
ResultSetMetaData rmeta=r.getMetaData();
int numcol=rmeta.getColumnCount();
for(int i=1;i<=numcol;++i)
System.out.print(rmeta.getColumnName(i)+"\t");
Sytem.out.print("\n");
while(r.next())
{
for(int i=1;i<=numcol;++i)
System.out.print(r.getString(i)+ "\t" );
System.out.print("\n");
}
}
}
import java.sql.*;
import java.util.*;
class statapp
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcoracle";
Connection con=DriverManager.getConnection(url,"palani","kumar");
Statement st=con.createStatement();
String sql=args[0];
System.out.println(sql);
boolean hasResults=st.execute(sql);
if(hasResults)
{
ResultSet rs=st.getResultSet();
if(rs!=null)
disp(rs);
}
con.close();
}
catch(Exception ex)
{
System.out.println(ex);
System.exit(0);
}
}
static void disp(ResultSet r) throws SQLException
{
ResultSetMetaData rmeta=r.getMetaData();
int numcol=rmeta.getColumnCount();
for(int i=1;iless than numcol;++i)
System.out.print(rmeta.getColumnName(i));
while(r.next())
{
for(int i=1;i less than numcol;++i)
System.out.print(r.getString(i));
}
}
}
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
/* Table emp in oracle user palani columns eno ename sal */
class fram extends JFrame implements ActionListener
{
TextField txteno, txtename, txtsal ;
JLabel lbleno, lblename, lblsal, lblstat ;
Container cp;
Connection con;
Statement st;
JButton butinsert;
fram()
{
txteno = new TextField(12);
txtename = new TextField(12);
txtsal = new TextField(12);
lbleno = new JLabel("Empno ");
lblename= new JLabel("Ename ");
lblsal = new JLabel("salary");
lblstat = new JLabel("");
butinsert = new JButton("Insert");
cp = this.getContentPane();
cp.setLayout(new FlowLayout());
cp.add(lbleno);
cp.add(txteno);
cp.add(lblename);
cp.add(txtename);
cp.add(lblsal);
cp.add(txtsal);
cp.add(butinsert);
cp.add(lblstat);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcoracle";
con=DriverManager.getConnection(url,"palani","kumar");
lblstat.setText("successfully connected");
st=con.createStatement();
}
catch(Exception ex)
{
System.out.println("Cannot connect " + ex);
}
butinsert.addActionListener(this);
addWindowListener(new w(this));
}
class w extends WindowAdapter
{
fram f1;
w(fram f2)
{
f1 = f2;
}
public void windowClosing(WindowEvent we)
{
f1.setVisible(false);
f2.dispose();
}
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource() == butinsert)
{
try
{
int rows = st.executeUpdate("insert into emp values(121,'melvin',5500)");
lblstat.setText(rows+ "inserted");
} catch(SQLException se) { }
}
}
}
class swodbc
{
public static void main(String arg[])
{
fram f = new fram();
f.setVisible(true);
f.setSize(400,400);
f.setLocation(200,200);
}
}