JAVA和数据库高性能软件开发 实践培训课程 第1课

完成一个最简单的jdbc java程序。

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class MyJDBCTest01 {

    private static final String driver = "oracle.jdbc.OracleDriver";
    private static final String ip = "10.141.132.119";
    private static final String port = "1521";
    private static final String sid = "jdbc:oracle:thin:";
    private static final String url = sid + "@" + ip + ":" + port + ":" + "imapdb";
    private static final String user = "naspa";
    private static final String password = "emsems";

    public static void main(String[] args) {
        test_Create();
        test_Insert();
        test_Query();
        test_Drop();
    }

    private Connection getConnection() {

     Connection conn = null;
     try {
      Class.forName(driver);
         conn = DriverManager.getConnection(url, user, password);
     } catch (ClassNotFoundException e) {
      System.err.println("MyJDBCTest01.getConnection() Class.forName error | " + e);
     } catch (SQLException e) {
      System.err.println("MyJDBCTest01.getConnection() DriverManager.getConnection error | " + e);
     }
     return conn;

    }

 private void close(Connection conn, Statement st, ResultSet rs) {
  
  if (rs != null) {
   try {
    rs.close();
   } catch (SQLException e) {
    System.err.println("MyJDBCTest01.close() close resultset error | " + e);
   }
  }
  
  if (st != null) {
   try {
    st.close();
   } catch (SQLException e) {
    System.err.println("MyJDBCTest01.close() close statement error | " + e);
   }
  }
  
  if (conn != null) {
   try {
    conn.close();
   } catch (SQLException e) {
    System.err.println("MyJDBCTest01.close() close connection error | " + e);
   }
  }
 }

    private static void test_Create() throws SQLException {

  Connection conn = getConnection();
     String sql = "create table mytest(ModTime Date, CardId long, Ename varchar2(255), WorkYears integer, Salary real, rate float)";

        Statement stat = conn.createStatement();

        stat.execute();
    }

    private static void test_Insert01(Connection conn) throws SQLException {
        PreparedStatement stat = conn.prepareStatement("insert into mytest values(?, ?, ?, ?, ?, ?)");
  stat.addBatch()
        for(int i = 1; i < 20; i++) {
            stat.setInt(1, i);
            String username = "user_" + i;
            stat.setString(2, username);
            stat.setInt(3, i);
            double salary = 10000.0 * i;
            stat.setDouble(4, salary);
            float rate = 0.01f * i;
            stat.setFloat(5, rate);
excuteBatch()
            stat.executeUpdate();
        }
    }

    private static void test_Query(Connection conn) throws SQLException {
        Statement stat = conn.createStatement();
        ResultSet rs = stat.executeQuery("select * from mytest");
        while(rs.next()) {
            StringBuffer sb = new StringBuffer();
            sb.append(rs.getDate(1)).append(",").append(rs.getLong(2)).append(",").append(rs.getString(3))
            .append(",").append(rs.getInt(4)).append(",").append(rs.getDouble(5)).append(",").append(rs.getFloat(6));
            System.out.println(sb);
        }
    }

    private static void test_Drop(Connection conn) throws SQLException {
        Statement stat = conn.createStatement();
        stat.execute("Drop table mytest");
    }

}