java 连不上数据库 mysql

[xtw123]

import java.sql.*;
public class ConnectToMySQL {
public static Connection getConnection() throws SQLException,
java.lang.ClassNotFoundException{
String url = "jdbc:mysql://localhost:3306/bookstore?";
Class.forName("com.mysql.jdbc.Driver");
String userName = "root";
String password = "123456";
Connection con = DriverManager.getConnection(url, userName, password);
return con;
}
public static void main(String[] args){
try {
Connection con = getConnection();
Statement sql=con.createStatement();
/*
*/
String query = "select UserName,PassWord,Names from shop_user";
ResultSet result = sql.executeQuery(query);
// System.out.println("bookadmin表数据如下:");
// System.out.println("----------------------");
//System.out.println("用户名" + "\t" + "密码" + "\t\t" + "姓名");
// System.out.println("----------------------");
String UserName;
String PassWord;
String Names;
// int Id=0;
while (result.next()) {
// Id++;
UserName = result.getString(" UserName");
PassWord = result.getString(" PassWord");
Names = result.getString(" Names");
System.out.println( result.getString(" UserName"));
System.out.println(result.getString(" PassWord"));
System.out.println(result.getString(" Names"));
}
sql.close();
con.close();
}catch (java.lang.ClassNotFoundException e) {

System.err.println("ClassNotFoundException:" + e.getMessage());

}
catch (SQLException ex) {
System.err.println("SQLException:" + ex.getMessage());

}
}
}

[sutku]

[Quote=引用楼主 xtw123 的帖子:]

import java.sql.*;
public class ConnectToMySQL {
public static Connection getConnection() throws SQLException,
java.lang.ClassNotFoundException{
String url = "jdbc:mysql://localhost:3306/bookstore?";
Class.forName("com.mysql.jdbc.Driver");
String userName = "root";
String password = "123456";
Connection con = DriverManager.getConnection(url, user…
[/Quote]
报啥错误，你导入了数据库驱动没有

[xtw123]

出错


java.sql.SQLException: 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 ''wxy' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at bookshop.run.login.excute(login.java:63)
at org.apache.jsp.login$jsp._jspService(login$jsp.java:102)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:536)

[sutku]

[Quote=引用 2 楼 xtw123 的回复:]
出错


java.sql.SQLException: 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 ''wxy' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connecti…
[/Quote]
mysql数据库的版本和驱动版本对应不
lz的方法我这里测试没问题的

[老紫竹]

看错误，你的连接部分没有任何问题，是你的查询语句的语法错误，

wxy
看看你的哪里有这个东西吧，

[xtw123]

回复四楼
wxy 是数据库表中的一条数据

[dongguang1082]

这个数据格式不正确，把它删除了