get a database connection in java

Question

This is my source code.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;

public class DBConnect {

    public static void main(String[] args) {

        try {
            String host = "jdbc:derby://localhost:1527/Employee";
            String uName = "jayani";
            String uPass = "jayani";
            Connection con = DriverManager.getConnection(host, uName, uPass);
            Statement stmt = con.createStatement();
            String sql = "SELECT*FROM WORKERS";

            ResultSet rs = stmt.executeQuery(sql);

            while (rs.next()) {
                int id_col = rs.getInt("ID");
                String fname = rs.getString("FIRST_NAME");
                String lname = rs.getString("LAST_NAME");
                String job = rs.getString("JOB_TITLE");

                System.out.println(id_col + "" + fname + "" + lname + "" + job);

            }
        } catch (SQLException ex) {

            System.out.println(ex.getMessage());
        }
    }
}

Here i got an exception like "executeQuery method can not be used for update." What is this exception and how can I solve this. Thank you.

Which one do you actually use: Microsoft sql-server or MySQL? — Ivan Gerasimenko
– Ivan Gerasimenko, Commented Feb 25, 2015 at 6:10

Vivek Gupta · Accepted Answer · 2015-02-25 06:07:28Z

1

You need to use executeQuery like this

    Statement stmt = null;
    String query = "select * from <tablename>";
    stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery(query);

answered Feb 25, 2015 at 6:07

Vivek Gupta

1,0455 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Jayani Palansooriya Over a year ago

Thank you, but when i used it ,i'm getting an error like "incompatible types required: ResultSet found: int ----"..Why is that?

Vivek Gupta Over a year ago

What is the datatype of "FIRST_NAME", "LAST_NAME","JOB_TITLE" in database table

Jayani Palansooriya Over a year ago

How? I had to use String sql = "SELECT * F\";ROM APP.Workers"; in place of String query = "select * from <tablename>"; :)

Vivek Gupta Over a year ago

My Bad, that I gave you as an example only :)

Collectives™ on Stack Overflow

get a database connection in java

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related