import java.sql.*;
import javax.sql.rowset.CachedRowSet;
import com.sun.rowset.CachedRowSetImpl;

public class UpdateScore11_5 
{
	public static void main(String[] args) 
	{
		String user = "root";
		String password = "123456";
		String url = "jdbc:mysql://localhost:3306/test";
		try 
		{
			Class.forName("com.mysql.jdbc.Driver");	//Java 6 д˾ʡԲд
			Connection conn = DriverManager.getConnection(url, user, password);
			try 
			{
				CachedRowSet rs = new CachedRowSetImpl();
				rs.setCommand("select * from sc");
				rs.execute(conn);
				conn.close();
				while(rs.next()) 
				{
					int score = rs.getInt(3);
					if(score < 90) 
					{
						rs.updateInt(3, score+10);
						rs.updateRow();
					}
				}
				conn = DriverManager.getConnection(url, user, password);
				conn.setAutoCommit(false);
				rs.acceptChanges(conn);
			} finally 
			{
				conn.close();
			}
		} catch (Exception e) 
		{
			e.printStackTrace();
		}
	}
}
