PreparedStatement ps=null;
Connection conn=null;
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//创建连接对象
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oracle","scott","root");
//创建SQL命令
// String sql1="update student set money=money-1000 where SNUM=1";//转账 // String sql2="update student set money=money+1000 where SNUM=2";//入账
String sql="update student set money=(money-1000) where SNUM=1";
//创建执行对象
ps=conn.prepareStatement(sql);
//执行SQL语句
int i=ps.executeUpdate();
System.out.println(i);
//关闭资源
ps.close();
conn.close();