Terima kasih.
import java.sql.*;
public class ResultSetUpdateRow{
public static void main(String args[]) throws SQLException, ClassNotFoundException{
Class.forName("org.gjt.mm.mysql.Driver");
Connection cn = DriverManager.getConnection("jdbc:mysql://aminem/test","root","");
Statement st = cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = st.executeQuery("Select EMPNO,ENAME,SAL
From EMP");adjustSalary(rs,500);
rs.close();
st.close();
}
public static void adjustSalary(ResultSet rs, double raise) throws SQLException {
double salary = 0;
while(rs.next())
{
salary = rs.getDouble(3);
rs.updateDouble(3, salary + raise);
rs.updateRow(); }
}
}
Exception in thread "main" com.mysql.jdbc.NotUpdatable: Result Set not updatable. This result set must come from a statement that was created with a result set t
ype of ResultSet.CONCUR_UPDATABLE, the query must select only one table, and must select all primary keys from that table. dst.....
===========================================================================================
"Ada yang baru di www.sekolah-online.net" buat kalian yang lagi siap-siap test masuk perguruan tinggi, silahkan coba latihan try out online di www.sekolah-online.net/tryout.
Buktikan kalo kalian emang udah siap masuk perguruan tinggi.
Ada bank soalnya juga lho...!
so, tunggu apa lagi, just click and do it...
"hanya bisa diakses dari Telkomnet Instan,Telkomnet ISDN, dan ASTINet" ===========================================================================================
-- Berhenti langganan: [EMAIL PROTECTED] Arsip dan info: http://linux.or.id/milis.php
