Getting a SQL Exception ?

[lakmal padmakumara]

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sql;

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

/**
 *
 * @author Administrator
 */
public class LoginSystem {

    String username;
    String passowrd;

    public static void main(String[] args) {



        Connection conn = null;
        try {
            String url = "jdbc:mysql://localhost/librarysystem";
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection(url, "root", "");
            System.out.println("Database connection established");
            Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
          
            String name = "lakmal";
            String username = "lakmal";
            String password = "lakmal";
            String usertype = "Student";
            String email = "[e-mail]";
            String uniReg = "455363";
            boolean suspended = false;



            String sql = "INSERT INTO users " + "(name, username, password,usertype,email,unireg,issuspended) " + "VALUES " + "('" + name + "'," + "('" + username + "'," + "('" + password + "'," + "('" + usertype + "'," + "('" + email + "'," + "('" + uniReg + "'," + "('" + suspended + "')";


            statement.executeUpdate(sql);

        } catch (Exception e) {
            System.err.println("Cannot connect to database server");
            System.out.println(e);
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                    System.out.println("Database connection terminated");
                } catch (Exception e) { /* ignore close errors */ }
            }
        }
    }
}

Hey Friends , I'm getting an error which is mentioned below when i run my programme !!

run:
Database connection established
Cannot connect to database server
java.sql.SQLException: Syntax error or access violation message from server: "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 '' at line 1"
Database connection terminated
BUILD SUCCESSFUL (total time: 0 seconds)

I know something wrong with my sql query .But Cannot figure it out !!!I have attached my sql database also .It does not contain any data .Only a Table .I have been checking this for nearly 7 hours using tutorials and other internet stuff.If you can please give me a help !!

My SQL Db is here
http://download734.mediafire.com/d9ccljmteydg/tnhixyhlzz2/localhost.sql

[Vijitha Kumara]

As the exception says error is in your SQL:

INSERT INTO users " + "(name, username, password,usertype,email,unireg,issuspended) " + "VALUES " + "[b]([/b]'" + name + "'," + "('" + username + "'," + "('" + password + "'," + "('" + usertype + "'," + "('" + email + "'," + "('" + uniReg + "'," + "('" + suspended + "'[b])[/b]";   

After the "VALUES" clause you should have only one (opening) round bracket and one at the end (closing round bracket). It should not have any in between.

[lakmal padmakumara]

Hey Friends , I found it !!! From Java Ranch ,

The insert into code should be changed as

 String sql = "INSERT INTO users VALUES('lakmal','lakmal','12345','lakmal','lakmal','ddd',false)";