[prev in list] [next in list] [prev in thread] [next in thread] 

List:       suse-programming-e
Subject:    Re: [suse-programming-e] Can not issue data manipulation statements with executeQuery().
From:       Steve Graegert <graegerts () gmail ! com>
Date:       2006-01-16 8:42:59
Message-ID: 6a00c8d50601160042t7b190893m116719e0696646d7 () mail ! gmail ! com
[Download RAW message or body]

On 1/16/06, Patrix Linux <patrixlinux@arcor.de> wrote:
> Dear my friends...
>
>        I am confused why my program does not run properly.The error
>        message is:
>        "
>        Errorjava.sql.SQLException: Can not issue data manipulation
>        statements
>        with executeQuery().
>        ".
>
>        Please help me. Tell me where my mistake.
>
>        Thank you very much in advance.
>        ======
>        Here is my table:
>        "
>        mysql> describe karyawan;
>        +-----------+---------+------+-----+---------+-------+
>        | Field     | Type    | Null | Key | Default | Extra |
>        +-----------+---------+------+-----+---------+-------+
>        | id        | int(11) | YES  |     | NULL    |       |
>        | namadepan | text    | YES  |     | NULL    |       |
>        +-----------+---------+------+-----+---------+-------+
>        2 rows in set (0.00 sec)
>
>        mysql>
>        ".
>        --------------------------
>        And here is my code:
>
>        //package basisdata;
>        import java.sql.*;
>        import java.io.*;
>
>        public class login {
>            public static void main(String args[]) throws IOException{
>                BufferedReader stdin = new BufferedReader(new
>        InputStreamReader(System.in));
>                String username,koderahasia,basisdata, id,namadepan,
>        buff;
>                basisdata = "rumahsakit";
>                int pilih;
>                System.out.println("Login : ");
>                try{
>                    System.out.println("Username : ");
>                    username = stdin.readLine();
>                    System.out.println("Kode rahasia : ");
>                    koderahasia = stdin.readLine();
>
>                    Class.forName("com.mysql.jdbc.Driver");
>                    Connection connection =
>        DriverManager.getConnection("jdbc:mysql://localhost/"+
>                            basisdata, username,  koderahasia);
>                    System.out.println("Udah konek");
>
>                    System.out.println("Menu : ");
>                    System.out.println("1. Simpan data.");
>                    System.out.println("2. Edit data.");
>                    System.out.println("3. Hapus data.");
>                    System.out.println("4. Lihat data.");
>                    System.out.println("5. Exit.");
>                    System.out.println("Pilih menu !");
>                    buff = stdin.readLine();
>                    pilih = Integer.parseInt(buff);
>                    switch(pilih){
>                        case 1:
>                            System.out.println("Proses simpan.");
>                            System.out.println("ID karyawan : ");
>                            id = stdin.readLine();
>                            System.out.println("Nama depan : ");
>                            namadepan = stdin.readLine();
>
>                            Statement pernyataan  =
>        connection.createStatement();
>                            String sql = "insert into karyawan
>        values("+id+",'"+namadepan+"');";
>                            System.out.println(sql);
>                            pernyataan.executeQuery(sql);
>                            pernyataan.close();
>                            System.out.println("Data udah disimpan");
>                            break;
>                        case 2:
>                            System.out.println("Proses edit data.");
>                            break;
>                        case 3:
>                            System.out.println("Proses hapus data.");
>                            break;
>                        case 4:
>                            System.out.println("Proses lihat data.");
>                            break;
>                        default:
>                            System.out.println("Bye.");
>                            break;
>                    }
>
>                    connection.close();
>                }catch(Exception e){
>                    System.out.println("Error"+e);
>                }
>            }
>
>        }
>

executeQuery() returns a result set, but an INSERT statement does not
return a result.  Try execute(string sql) instead.

	\Steve

--

Steve Graegert <graegerts@gmail.com>
Software Consultant {C/C++ && Java && .NET}
Office: +49 9131 7123988
Mobile: +49 1520 9289212

-- 
To unsubscribe, email: suse-programming-e-unsubscribe@suse.com
For additional commands, email: suse-programming-e-help@suse.com
Archives can be found at: http://lists.suse.com/archive/suse-programming-e


[prev in list] [next in list] [prev in thread] [next in thread]