import java.sql.*;
import java.util.Date;class task4
{
public static void main (String args [])
throws SQLException, ClassNotFoundException
{
// Load the Oracle JDBC driver
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@data-pc33.cs.uow.edu.au:1521:db", "CSCI317", "CSCI317");
try{
Statement stmt1 = conn.createStatement ();
String query1 = "SELECT LINEITEM.L_ORDERKEY, SUM(PART.P_RETAILPRICE) " +
"FROM LINEITEM JOIN PART " +
"ON LINEITEM.L_PARTKEY = PART.P_PARTKEY " +
"GROUP BY LINEITEM.L_ORDERKEY " +
"HAVING SUM(PART.P_RETAILPRICE) > 10000";
String query2 = "UPDATE ORDERS SET ORDERS.O_TOTALPRICE = ? WHERE ORDERS.O_ORDERKEY = ?";
PreparedStatement pstmt1 = conn.prepareStatement ( query2 );
Date start_time = new Date();
ResultSet rset1 = stmt1.executeQuery(query1);
System.out.println("query");
int i = 0;
while(rset1.next())
{
int okey = rset1.getInt(1);
double price = rset1.getDouble(2);
if(i%100 == 0)
System.out.println(okey + " + " + price);
price = 1.1*price;
pstmt1.setDouble(1, price);
pstmt1.setInt(2, okey);
pstmt1.executeUpdate();
if(i%100 == 0)
System.out.println("3");
i++;
}
System.out.println( i + " rows updated." );
Date stop_time = new Date();
double etime = (stop_time.getTime() - start_time.getTime());
System.out.println("\nElapsed Time = " + etime + " milliseconds\n");
}
catch (SQLException e )
{
String errmsg = e.getMessage();
System.out.println( errmsg );
}
}
}stmt1运行正常,之后进入while后,一到pstmt1.executeUpdate();这里,就停住了,求助
import java.util.Date;class task4
{
public static void main (String args [])
throws SQLException, ClassNotFoundException
{
// Load the Oracle JDBC driver
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@data-pc33.cs.uow.edu.au:1521:db", "CSCI317", "CSCI317");
try{
Statement stmt1 = conn.createStatement ();
String query1 = "SELECT LINEITEM.L_ORDERKEY, SUM(PART.P_RETAILPRICE) " +
"FROM LINEITEM JOIN PART " +
"ON LINEITEM.L_PARTKEY = PART.P_PARTKEY " +
"GROUP BY LINEITEM.L_ORDERKEY " +
"HAVING SUM(PART.P_RETAILPRICE) > 10000";
String query2 = "UPDATE ORDERS SET ORDERS.O_TOTALPRICE = ? WHERE ORDERS.O_ORDERKEY = ?";
PreparedStatement pstmt1 = conn.prepareStatement ( query2 );
Date start_time = new Date();
ResultSet rset1 = stmt1.executeQuery(query1);
System.out.println("query");
int i = 0;
while(rset1.next())
{
int okey = rset1.getInt(1);
double price = rset1.getDouble(2);
if(i%100 == 0)
System.out.println(okey + " + " + price);
price = 1.1*price;
pstmt1.setDouble(1, price);
pstmt1.setInt(2, okey);
pstmt1.executeUpdate();
if(i%100 == 0)
System.out.println("3");
i++;
}
System.out.println( i + " rows updated." );
Date stop_time = new Date();
double etime = (stop_time.getTime() - start_time.getTime());
System.out.println("\nElapsed Time = " + etime + " milliseconds\n");
}
catch (SQLException e )
{
String errmsg = e.getMessage();
System.out.println( errmsg );
}
}
}stmt1运行正常,之后进入while后,一到pstmt1.executeUpdate();这里,就停住了,求助
解决方案 »
- 亲们,我问个令我纠结的问题
- 用JDBC连接oracle数据库要做的准备
- 关于javamail问题,困惑多天了,抛出AuthenticationFailedException异常,请高手指正
- replaceAll("<br\\s*/?>|<p\\s*/?>|[\\s\\n]", "");请问这是什么意思?
- 请教如何编写一个小游戏??
- java与c写的一个服务器通讯
- 咨询commons.fileupload 1.1的使用
- 学习JAVA程序编写,应该按什么顺序?
- 请问JAVA与SQL SERVER2000怎么连接
- 怎么样实现这样个阶乘函数?谢谢
- 十一黄金周 超低价格 超值培训
- 错误java.lang.UnsatisfiedLinkError发生了。。。
double price = rset1.getDouble(2);
pstmt1.setDouble(1, price);----》pstmt1.setDouble(2, price);
pstmt1.setInt(2, okey);----》pstmt1.setInt(1, okey);
是不是第一个字段是int
pstmt1.setDouble(1, price);就不对了?