代码之家  ›  专栏  ›  技术社区  ›  onurbaysan

如何在JDeveloper Swing projects框架上显示oracledb表?

  •  0
  • onurbaysan  · 技术社区  · 16 年前

    1 回复  |  直到 16 年前
        1
  •  0
  •   onurbaysan    16 年前

    好 啊。我解决我的问题。

                DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
                Connection connection = DriverManager.getConnection(connStr,"scott","tiger"); 
    
                Connector conn = new Connector(connStr);
                Statement stmt = conn.getConnection().createStatement();                       
    
                ResultSet rset = stmt.executeQuery(sql); 
                ResultSetMetaData metaData = rset.getMetaData();
    
                int rowCount = metaData.getColumnCount();                 
    
                for(i=1;i<=rowCount;i++)
                    headers.add(metaData.getColumnLabel(i).toString()); 
    
    
                while(rset.next()){          
                    Vector tmp = new Vector();
                    for(i=1;i<=rowCount;i++) {
                        tmp.add(rset.getString(i));              
                    }
                    lists.add(tmp);
                    index++;                              
    

    这是我的连接器类。

    package client;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.Statement;
    
    
    public class Connector 
    {
      private String connection_string;
      private Statement stmt;
      private Connection connection;
    
      public Connector(String conn)
      {
          //String connection_string = "jdbc:oracle:thin:@<host>:<port>:<db name>";
          try 
          {
            connection_string = conn;
    
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());  
    
            connection = DriverManager.getConnection(conn,"scott","tiger");                 
    
          } catch(Exception f) 
          {
            f.printStackTrace();
          }
    
      }
    
      public ResultSet execute(String sql) 
      {
         try 
         {
           stmt = connection.createStatement();
           return stmt.executeQuery(sql);
         } catch (Exception f) 
         {
           f.printStackTrace();
         }    
         return null;
      }
    
    
      public void setConnection_string(String connection_string)
      {
        this.connection_string = connection_string;
      }
    
    
      public String getConnection_string()
      {
        return connection_string;
      }
    
    
      public void setStmt(Statement stmt)
      {
        this.stmt = stmt;
      }
    
    
      public Statement getStmt()
      {
        return stmt;
      }
    
    
      public void setConnection(Connection connection)
      {
        this.connection = connection;
      }
    
    
      public Connection getConnection()
      {
        return connection;
      }
    }
    
    推荐文章