[linux-programming] JAVA MYSQL

[Aminem]

apakah database mysql tidak bisa diupdate dengan melalui 
object resultset ? sebab ketika tiap saya execute 
selalu muncul error. atau ada yg salah dalam coding saya ? 
mohon bantuannya.
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

Re: [linux-programming] JAVA MYSQL

[Donny Kurnia]

On Sat, 15 Nov 2003, Aminem wrote:

 apakah database mysql tidak bisa diupdate dengan melalui 
 object resultset ? sebab ketika tiap saya execute 

Object resultset itu 'read-only'

 selalu muncul error. atau ada yg salah dalam coding saya ? 
 mohon bantuannya.
 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);

Anda harus melakukan UPDATE dengan query update-nya MySQL.
Gunakan method executeUpdate dari Statement atau PreparedStatement.

   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.

--
Donny Kurnia  --  13500021
Software Engineering Laboratory
Department of Informatics
Bandung Institute of Technology


-- 
Berhenti langganan: [EMAIL PROTECTED]
Arsip dan info: http://linux.or.id/milis.php