Advertisement
Guest User

Untitled

a guest
Oct 7th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.92 KB | None | 0 0
  1. import java.sql.*;
  2. import javax.sql.*;
  3.  
  4. public class ReportMain{
  5.  
  6. public static void main(String args[]){
  7.    
  8. String dbUrl = "jdbc:oracle:thin:@//172.16.6.120:1521/BPIHQ";
  9. String dbClass = "oracle.jdbc.OracleDriver";
  10. String query = "SELECT * FROM TX_NOTE_CALCUL";
  11. String user = "antecalcul";
  12. String pass = "a";
  13. try {
  14.  
  15. //Class.forName("com.mysql.jdbc.Driver");
  16.     Class.forName(dbClass);
  17. Connection con = DriverManager.getConnection (dbUrl,user,pass);
  18. Statement stmt = con.createStatement();
  19. ResultSet rs = stmt.executeQuery(query);
  20. ResultSetMetaData rsmd = rs.getMetaData();
  21. int numCols = rsmd.getColumnCount();
  22.  
  23. while (rs.next()) {
  24.     for (int i=1;i<=numCols;i++)
  25. System.out.print(rs.getString(i)+ " ");
  26.     System.out.println();
  27. } //end while
  28.  
  29. con.close();
  30. } //end try
  31.  
  32. catch(ClassNotFoundException e) {
  33. e.printStackTrace();
  34. }
  35.  
  36. catch(SQLException e) {
  37. e.printStackTrace();
  38. }
  39.  
  40. }  //end main
  41.  
  42. }  //end class
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement