jdbcexample.java

java数据库编程。JDBC+SQL+GUI。用java写的一个影碟租赁系统

import java.sql.*;
import javax.sql.*;
import oracle.jdbc.driver.*;
import oracle.jdbc.pool.OracleDataSource;

public class JDBCExample
{
        public static void main (String[] args) throws SQLException
        {
                OracleDataSource ods = new OracleDataSource();
                ods.setURL("jdbc:oracle:thin:@bajor.its.deakin.edu.au:1527:SSID"
);

                // Retrieve a connection
                Connection conn = ods.getConnection("bko","kokulnat");
                System.out.println("Connected to Database..");
                Statement state=conn.createStatement();
        //      ResultSet rs=state.executeQuery("select table_name from user_tables");

                ResultSet rs=state.executeQuery("SELECT * FROM imports");

                while(true)
                        {
                        boolean loop=rs.next();
                        if(loop!=true)
                        {
                        break;
                        }
                        else
                        {
                        ResultSetMetaData rsmd = rs.getMetaData();
                        for(int count=1;count<(rsmd.getColumnCount()+1);count++)
                        {
                        System.out.println(rs.getString(count));
                        }
                        System.out.print("\n");
                        }
                }
        // Close the connection
        conn.close();
        }
}