updateprize.java

来自「Light in the box 抓取程序。 使用HttpClient」· Java 代码 · 共 15 行

package com.blogool.export;

import java.sql.Connection;

public class UpdatePrize {
	public static void main(String[] args) {
		Connection conn = DBUtil.getConnection();
		for (int i = 20239; i <= 25283; i ++) {
			String sql = "update product set prize1 = prize1 * " + (0.75 + Math.random() / 20) + " where id = " + i;
			DBUtil.update(conn, sql, new Object[] {});
		}
	}
	
}