java sql query error

Question

I have this code:

import java.sql.Connection;

import java.sql.DriverManager;
import java.sql.Statement;


public class DBConntest {

    public static void main(String[] args) {
    try {

        Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/?user=root&useSSL=false", "root", "root");
        System.out.println("Connection succes!");
        Statement stmt = conn.createStatement();
        String query1 = "USE test; insert into dbtester(name,age,email) values ('Aram',18,'[email protected]');";
        stmt.executeUpdate(query1);

    }
    catch (Exception e){
        System.err.println(e);;
    }

    }

}

I use Eclipse, and after run it return this error com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into dbtester(name,age,email) values ('Aram',18,'[email protected]')' at line 1

Same SQL Query work in MySQL workbench. How I can solve this problem?

Change the line to String query1 = "insert into dbtester(name,age,email) values ('Aram',18,'[email protected]');"; — FallAndLearn
– FallAndLearn, Commented Feb 28, 2016 at 8:08

FallAndLearn · Accepted Answer · 2016-02-28 08:55:53Z

0

Change the line to String query1 = "insert into dbtester(name,age,email) values ('Aram',18,'[email protected]');";

For no database selected exception : Your URL for your database should include your database name. This is normally your URL followed by a "/databasename".

String url = "jdbc:mysql://localhost/databasename";
String username = "test";
String password = "test";
Connection connection = DriverManager.getConnection(url, username, password);

answered Feb 28, 2016 at 8:55

FallAndLearn

4,1351 gold badge20 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

java sql query error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related