TO Get Any Table
=================
import java.sql.*;
import java.util.*;
class Anytable_Retrieval
{
public static void main(String[] args) throws SQLException
{
Connection con;
Statement st;
ResultSet rs;
ResultSetMetaData rsmd;
Scanner sc=new Scanner(System.in);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sagar","system","bvrice");
while(true)
{
System.out.println("Enter which table details you want :");
String str=sc.next();
st=con.createStatement();
rs=st.executeQuery("select * from "+str);
rsmd=rs.getMetaData();
int cc=rsmd.getColumnCount();
for(int i=1;i<=cc;i++)
System.out.print(rsmd.getColumnName(i)+" ");
System.out.println();
while(rs.next())
{
for(int i=1;i<=cc;i++)
{
System.out.print(rs.getString(i)+" ");
}
System.out.println();
} // end inner while
System.out.println("Do you want another table details(false/true) :");
boolean choice=sc.nextBoolean();
if(!choice) // false
break;
}// end outter while
rs.close();
st.close();
con.close();
} // try
catch(Exception e)
{
System.out.println(e);
}
}
}
Monday, August 31, 2009
Monday, August 24, 2009
DB
=====DB1========
import java.io.*;
import java.sql.*;
import java.net.*;
public class DB1
{
static Connection con;
static Statement st1,st2;
static ResultSet rs1;
//static ResultSetMetaData rsmd;
static PreparedStatement pstmt;
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:irk");
pstmt = con.prepareStatement("update emp set name = ? where eno = ?");
pstmt.setString(1,"krishna");
pstmt.setString(2,"e1");
pstmt.executeUpdate();
st1=con.createStatement();
System.out.println("Done");
rs1=st1.executeQuery("select * from emp");
while(rs1.next())
{
System.out.println(" "+rs1.getString(1)+" "+rs1.getString(2));
}
st2=con.createStatement();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
=========DB--------
import java.io.*;
import java.sql.*;
import java.net.*;
public class DB
{
static Connection con;
static Statement st1,st2;
static ResultSet rs1;
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:tri");
st1=con.createStatement();
System.out.println("Done");
rs1=st1.executeQuery("select * from emp");
while(rs1.next())
{
System.out.println(" "+rs1.getString(1)+" "+rs1.getString(2));
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
import java.io.*;
import java.sql.*;
import java.net.*;
public class DB1
{
static Connection con;
static Statement st1,st2;
static ResultSet rs1;
//static ResultSetMetaData rsmd;
static PreparedStatement pstmt;
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:irk");
pstmt = con.prepareStatement("update emp set name = ? where eno = ?");
pstmt.setString(1,"krishna");
pstmt.setString(2,"e1");
pstmt.executeUpdate();
st1=con.createStatement();
System.out.println("Done");
rs1=st1.executeQuery("select * from emp");
while(rs1.next())
{
System.out.println(" "+rs1.getString(1)+" "+rs1.getString(2));
}
st2=con.createStatement();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
=========DB--------
import java.io.*;
import java.sql.*;
import java.net.*;
public class DB
{
static Connection con;
static Statement st1,st2;
static ResultSet rs1;
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:tri");
st1=con.createStatement();
System.out.println("Done");
rs1=st1.executeQuery("select * from emp");
while(rs1.next())
{
System.out.println(" "+rs1.getString(1)+" "+rs1.getString(2));
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
Subscribe to:
Comments (Atom)