Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import javax.sql.*;
- public class ReportMain{
- public static void main(String args[]){
- String dbUrl = "jdbc:oracle:thin:@//172.16.6.120:1521/BPIHQ";
- String dbClass = "oracle.jdbc.OracleDriver";
- String query = "SELECT * FROM TX_NOTE_CALCUL";
- String user = "antecalcul";
- String pass = "a";
- try {
- //Class.forName("com.mysql.jdbc.Driver");
- Class.forName(dbClass);
- Connection con = DriverManager.getConnection (dbUrl,user,pass);
- Statement stmt = con.createStatement();
- ResultSet rs = stmt.executeQuery(query);
- ResultSetMetaData rsmd = rs.getMetaData();
- int numCols = rsmd.getColumnCount();
- while (rs.next()) {
- for (int i=1;i<=numCols;i++)
- System.out.print(rs.getString(i)+ " ");
- System.out.println();
- } //end while
- con.close();
- } //end try
- catch(ClassNotFoundException e) {
- e.printStackTrace();
- }
- catch(SQLException e) {
- e.printStackTrace();
- }
- } //end main
- } //end class
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement