Connecting to a database:

**jocdrew21** · September 10th, 2014, 12:41 PM

I am connecting to my database FINALLY however now I am getting the following error:

my output:

Database Established&#8230;
Error Catch: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 'FROM 'users' WHERE user_id='7'' at line 1

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
 
 
public class DBDemo 
{
	public static void main(String [] args){            
        try{
 
         Connection conn=null;//8889
         String url ="jdbc:mysql://localhost:3306/ch18";
         String user="root";
         String pass="root";
         conn = DriverManager.getConnection(url,user,pass);
         System.out.println("Database Established…");
 
            PreparedStatement ps = null;
            ps=conn.prepareStatement("SELECT FROM 'users' WHERE user_id='7'");
 
            ps.execute();
 
            System.out.println(ps);
 
                conn.close();
 
        }catch(SQLException e){
            System.out.println("Error Catch:"+e);
        }
 
    }
}

DataBase.jpg

Here is a picture of my MAMP mySQL database. This is my first time doing this and could use all the advice I can get.

**copeg** · September 10th, 2014, 12:45 PM

Thread moved to the appropriate section

The exception indicates an error in your syntax. Can you run that query directly in the database? I presume not, because usually a query needs to select something (for instance a single column, or wildcard ( * ) for everything)

**jocdrew21** · September 10th, 2014, 01:16 PM

Ok I fixed that now it just repeats the query back to me. I want it to execute it:

Database Established&#8230;
com.mysql.jdbc.JDBC4PreparedStatement@24599bcd: SELECT * FROM  `users` WHERE  `first_name` =  'Drew'

public static void main(String [] args){            
        try{
 
         Connection conn=null;//8889
         String url ="jdbc:mysql://localhost:3306/ch18";
         String user="root";
         String pass="root";
         conn = DriverManager.getConnection(url,user,pass);
         System.out.println("Database Established…");
 
            PreparedStatement ps = null;
            ps=conn.prepareStatement("SELECT * FROM  `users` WHERE  `first_name` =  'Drew'");
 
            ps.execute();
 
            System.out.println(ps);
 
                conn.close();
 
        }catch(SQLException e){
            System.out.println("Error Catch:"+e);
        }

**copeg** · September 10th, 2014, 01:24 PM

You must retrieve a ResultSet to get any results from a query. See the API for the class and methods you are using for full descriptions
PreparedStatement (Java Platform SE 7 )\
As an aside, I would also recommend closing any open resources (eg: PreparedStatement, ResultSet, Connection), possibly best done in the finally clause of the try/catch

Thread: Connecting to a database:

LinkBack

Thread Tools

Display

Connecting to a database:

Related threads:

Re: Connecting to a database:

Re: Connecting to a database:

Re: Connecting to a database:

Similar Threads

Connecting netbeans with sql database

Problem with connecting to DataBase

Error connecting to database

Looking at Exploring Database Connecting

Connecting to a database