Java连接mysql出现SQL异常,ecilpse连接MySQL异常

代码：

//velues.java

package jdbc;

import java.sql.Connection;

public class Values

{

public static String DRIVER_MYSQL = "com.mysql.jdbc.Driver";

public static String URL = "jdbc:mysql://localhost:3306/TestJDBCd?"

+ "user=root&password=199429&useUnicode=true&characterEncoding=UTF8";

}

/*——————————————————————————————————————————*/

//TextJDBC.java

package jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class TestJDBC

{

private Statement statement;

public TestJDBC() {

try

{

Class.forName(Values.DRIVER_MYSQL);//加载JDBC驱动

System.out.println("Driver Load Success.");

Connection connection = DriverManager.getConnection(Values.URL);//创建数据库连接对象

statement = connection.createStatement();//创建Statement对象

} catch (Exception e)

{

// TODO Auto-generated catch block

e.printStackTrace();

}

}

/*

* 根据sql查询数据库，返回一个结果集

* 输    入:SQL语句

* 返回值:ResultSet 查询结果

*/

public ResultSet query(String sql) {

ResultSet result = null;

try

{

result = statement.executeQuery(sql);

} catch (SQLException e)

{

// TODO Auto-generated catch block

e.printStackTrace();

}

return result;

}

/*

* 打印UserInfo表的数据

* 输    入:结果集(数据表)

* 返回值:空

*/

public void printUserInfo(ResultSet result) {

try

{

while(result.next()) {

System.out.println("userNname:" + result.getString(1)

+ ", password:" + result.getString(2));

}

} catch (SQLException e)

{

// TODO Auto-generated catch block

e.printStackTrace();

}

}

/*

* 执行数据操作

* 输    入:SQL语句

* 返回值:空

*/

public void executeSql(String sql) {

try

{

statement.execute(sql);

} catch (SQLException e)

{

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static void main(String[] args)

{

// TODO Auto-generated method stub

String sql = "SELECT * FROM UserInfo";

TestJDBC db = new TestJDBC();

//db.executeSql("INSERT INTO UserInfo VALUES('小明', '666666')");

ResultSet result = db.query(sql);

db.printUserInfo(result);

}

}