OceanBase Connector/J 更改數(shù)據(jù)庫

PreparedStatement ps = null;
try{
    ps = conn.prepareStatement ("insert into customers (customerID, name) values (?, ?)");

    ps.setInt (1, 150);              // 第一個? 對應(yīng) customerID
    ps.setString (2, "Adam");   // 第二個? 對應(yīng) name

    ps.execute ();

    ps.setInt (1, 207);           
    ps.setString (2, "Alice");   
    ps.execute ();
}

finally{
     if(ps!=null)
     ps.close();
}

//創(chuàng)建表 customers 以及 customerID 和 name 列
String query;
Statement st=null;

try{
    query="create table customers " +
          "(customerID int, " +
          "name varchar(50))";
    st = conn.createStatement();
    st.executeUpdate(query);
    }
finally{
     //關(guān)閉 Statement
     st.close();
    }

PreparedStatement ps = null;
PreparedStatement ts = null;
try{
    ps = conn.prepareStatement ("insert into customers(customerID, name) values (?, ?)");
 
    // 添加新顧客 Adam，編號150
    ps.setInt (1, 150);          // 第一個? 對應(yīng) customerID
    ps.setString (2, "Adam");   // 第二個? 對應(yīng) name
    // 插入數(shù)據(jù)
    ps.execute ();
    
    ts = conn.prepareStatement("truncate table customers"); 
    ts.executeUpdate();
 
 
    // 添加新顧客 Alice，編號 207
    ps.setInt (1, 207);           // 第一個? 對應(yīng) customerID
    ps.setString (2, "Alice");   // 第二個? 對應(yīng) name
    // 插入數(shù)據(jù)
    ps.execute ();
 
    ts.close();
    ts = conn.prepareStatement("truncate table customers"); 
    ts.executeUpdate();
    }
finally{
     if(ps!=null)
     // 關(guān)閉 Statement
     ps.close();
}