Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class Javadb {
- public static void main(String args[]) {
- Connection con;
- class myTableModel() {
- String[] columnNames={" EbNr "," BtNr "," FzNr ", " Anzahl "};
- int nRow;
- Object[][] data;
- Address A;
- myTableModel() {
- }
- }
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- String conString = "jdbc:oracle:thin:@141.56.2.45:1521:orcl";
- con = DriverManager.getConnection(conString, "s76952", "s76952");
- DatabaseMetaData dmd = con.getMetaData();
- System.out.println("URL: "+dmd.getURL());
- System.out.println("Product: "
- +dmd.getDatabaseProductName()+" Vers."
- +dmd.getDatabaseProductVersion() );
- System.out.println("Driver : "
- +dmd.getDriverName()+" Vers."
- +dmd.getDriverVersion() );
- Statement stat = con.createStatement();
- String query = "SELECT * FROM Einbau";
- ResultSet rSet = stat.executeQuery(query);
- while(rSet.next()) {
- System.out.printf("%s, %d, %d\n", rSet.getString(1), rSet.getInt(2), rSet.getInt(2));
- myTableModel model=new myTableModel();
- Tbl =new JTable(model);
- S=new JScrollPane(Tbl);
- add(S);
- }
- myTableModel model=new myTableModel();
- Tbl =new JTable(model);
- S=new JScrollPane(Tbl);
- add("%s, %d, %d\n", rSet.getString(1), rSet.getInt(2), rSet.getInt(2));
- }catch(Exception e) {
- System.out.println(e);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement