Import java. sql .*;
class DatabaseConnection
{
Public static void main(String args[ ]) throws Exception
{
Class. forName(“sun. jdbc. odbc. JdbcOdbcDriver”);
Connection con = DriverManager. getConneciton(“jdbc:odbc:sac”);
PreparedStatement ps = con.prepareStatement(“insert into emp values (?,?,?)”);
ps.setString(1, “Emp001”);
ps.setString(2, “Akash”);
ps.setInt(1,00,000);
System.out.println(“Row inserted : ” +ps.execute Update( ));
Statement stmt = con.createStatement( );
ResultSet rs= stmt.executeQuery(“select * from emp”):
//obtaining Meta data of the result set
ResultSetMetaData rsmd = rs.getMetaData( );
int cc = rsmd.getColumnCount( );
System.out.printlln(“Number of columns in result set: ”+cc);
For(int i=1; i<=cc i++)
System.out.print(rsmd.getColumnName(i)+ “\t”);
System.out.println();
while(rs.next())
{
System.out.print(rs.getString(1)+ “\t”);
System.out.print(rs.getString(2)+ “\t”);
System.out.print(rs.getString(3)= “\t”);
}
}
}
The output of the program is as follow:
C:\javabook\program\java DatabaseConnection
Row inserted: 1
Number of columns in result set: 3
Empid Name Salary
Emp001 Akash 1, 00,000
For more detail please refer following link :
