package com.safiuz;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Manager4 {
public static void main(String[] args) {
//1. register driver
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ex){
ex.printStackTrace();
}
Connection con = null;
Statement stmt = null;
try
{
//2. Establish Database connection
con = DriverManager.getConnection("jdbc:odbc:oracle-datasource","system","great123");
//3. Get the Statement
stmt = con.createStatement();
//4. Compose Sql Query
String sql = "insert into tab1 values(4,'Safiuz')";
//5. trigger Sql query
int i = stmt.executeUpdate(sql);
System.out.println(i);
}
catch(SQLException ex){
ex.printStackTrace();
}
finally{
try{
//6. Close Database resources
if(stmt!= null){
stmt.close();
stmt= null;
}
}
catch(SQLException ex){
ex.printStackTrace();
}
try{
if(con!= null){
con.close();
con = null;
}
}
catch(SQLException ex){
ex.printStackTrace();
}
}
}
};
No comments:
Post a Comment