String dbStr = "jdbc:oracle:thin:usr/pass@host:1521:sid";
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(dbStr, null, null);然后你参照connection相关的方法来写程序,不过你要引入oracle的JDBC驱动程序包
在Oracle的客户端一般带有
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(dbStr, null, null);然后你参照connection相关的方法来写程序,不过你要引入oracle的JDBC驱动程序包
在Oracle的客户端一般带有
如何新增一条记录,更新记录等.不清楚语法,手头又没书.faint!
java.sql.Connection con=DriverManager.getConnection("jdbc:oracle:thin:@summiteam-test:1521:scmdb","summi","1");
//String name="SHP00000000000000001";java.sql.Statement st=con.createStatement();
java.sql.Date date=java.sql.Date.valueOf("2001-02-02");
java.sql.ResultSet res=null;
System.out.println(""+con.getTransactionIsolation());
try {
// String sel="select * from tblship where dateapprove>=to_date('"+date.toString()+"','yyyy-mm-dd') and dateapprove<to_date('2001-06-02','yyyy-mm-dd')" ;
String sel="select * from tbluser where chrusername='buy_worker'" ;
System.out.println(sel);
res=st.executeQuery(sel);
while(res.next())
{
System.out.println(res.getString("chrusername")); }
} catch (java.sql.SQLException ex)
{System.out.println(ex.getMessage());
ex.printStackTrace(System.out);
}
finally{
try {
if(res!=null)
res.close();
if(st!=null);
st.close();
if(con!=null)
con.close();
}
catch (java.sql.SQLException ex)
{System.out.println(ex.getMessage() );
}
}
现在只有了读出数据,那么新增,更新呢?