Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Oracle java connection
- import java.sql.*;
- public class SimpleOraJava {
- public static void main(String[] args) throws SQLException, ClassNotFoundException {
- // TODO Auto-generated method stub
- DriverManager.registerDriver(new Oracle.jdbc.driver.OracleDriver());
- String serverName="10.20.228.67";
- String user="root";
- String password="root";
- String SID="abc";
- String URL="jdbc:oracle:thin:@"+serverName+":"+1520+":"+SID;
- Connection conn=DriverManager.getConnection(URL, user, password);
- String SQL="Select employeename from employee";
- Statement stat=conn.createStatement();
- ResultSet rs=stat.executeQuery(SQL);
- while (rs.next()){
- System.out.println(rs.getInt(1));
- }
- stat.close();
- conn.close();
- }
- }
- DriverManager.registerDriver(new Oracle.jdbc.driver.OracleDriver());
- DriverManager.registerDriver(new Oracle.jdbc.driver.OracleDriver());
- import java.sql.*;
- import oracle.jdbc.driver.*;
- public class myjdbcapp
- {
- public static void main(String[] args) throws SQLException
- {
- DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
- String url = "jdbc:oracle:thin:@server:port:orcl";
- String userName = "scott";
- String password = "tiger";
- Connection conn = DriverManager.getConnection (url, userName, password);
- OracleCallableStatement myprocst = (OracleCallableStatement)
- conn.prepareCall ("begin myproc(?); end;");
- // ...
- }
- }
Add Comment
Please, Sign In to add comment