jdbc连接问题不上数据库
首先是测试代码:importjava.sql.*;importjava.util.*;publicclassConnect{publicstaticConnectionG...
首先是测试代码:
import java.sql.*;
import java.util.*;
public class Connect {
public static Connection GetConn() {
//String url = "jdbc:mysql://172.22.12.251/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8";
String url = "jdbc:mysql://localhost/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8&useSSL=false";
//String url = "jdbc:mysql://47.95.122.86/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String password = "hanxu";
Connection conn = null;
PreparedStatement ps = null;
try {
Class.forName(driver);
}
catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("找不到驱动!");
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(url, user, password);
if(conn!=null){
System.out.println("connection successful");
}
}
catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println( "connection fail");
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
Connect con=new Connect();
Connection conn = con.GetConn();
try{
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM book");}
catch(Exception e){
System.out.println(e);
}
}
}
然后是报错信息(最主要部分):
[root@iz2ze2b0uk8w1d60w34totz test]# java Connect
connection fail
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
java.lang.NullPointerException
我这个在本地上跑是完全没有问题的,项目直接跑起。但在服务器上,在连接数据库这一关就挂了。上面的是测试代码。密码,用户都没有问题,网上的所谓的三种方式也都尝试了,求大神解决。 展开
import java.sql.*;
import java.util.*;
public class Connect {
public static Connection GetConn() {
//String url = "jdbc:mysql://172.22.12.251/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8";
String url = "jdbc:mysql://localhost/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8&useSSL=false";
//String url = "jdbc:mysql://47.95.122.86/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String password = "hanxu";
Connection conn = null;
PreparedStatement ps = null;
try {
Class.forName(driver);
}
catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("找不到驱动!");
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(url, user, password);
if(conn!=null){
System.out.println("connection successful");
}
}
catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println( "connection fail");
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
Connect con=new Connect();
Connection conn = con.GetConn();
try{
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM book");}
catch(Exception e){
System.out.println(e);
}
}
}
然后是报错信息(最主要部分):
[root@iz2ze2b0uk8w1d60w34totz test]# java Connect
connection fail
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
java.lang.NullPointerException
我这个在本地上跑是完全没有问题的,项目直接跑起。但在服务器上,在连接数据库这一关就挂了。上面的是测试代码。密码,用户都没有问题,网上的所谓的三种方式也都尝试了,求大神解决。 展开
6个回答
展开全部
丹青引赠曹霸将军(杜甫)
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
听董大弹胡笳声兼寄语弄房给事(李颀)[5]
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
白雪歌送武判官归京(岑参)
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
长恨歌(白居易)
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
感遇·江南有丹桔(张九龄)
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询