import java.sql.*;public class My {
public static void main(String args[]) {
try {
Class.forName("com.mysql.jdbc.Driver"); //加?MYSQL JDBC??程序
System.out.println("Success loading Mysql Driver!");
}
catch (Exception e) {
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
} try {
Connection connect = DriverManager.getConnection(
"jdbc:mysql://3.243.217.12:3306/worklog", "root", "root"); System.out.println("Success connect Mysql server!"); Statement stmt = connect.createStatement();
ResultSet rs = stmt.executeQuery("select * from classification");
while (rs.next()) {
System.out.println(rs.getString("no")); }
}
catch (Exception e) {
System.out.print("get data error!");
e.printStackTrace();
}
}
}///////////////////////////////////
Success loading Mysql Driver!
get data error!java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream** BEGIN NESTED EXCEPTION ** java.io.IOException
MESSAGE: Unexpected end of input streamSTACKTRACE:java.io.IOException: Unexpected end of input stream
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at My.main(My.java:15)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:699)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at My.main(My.java:15)
这是什么原因 我用4.0就不出现这个问题!!
public static void main(String args[]) {
try {
Class.forName("com.mysql.jdbc.Driver"); //加?MYSQL JDBC??程序
System.out.println("Success loading Mysql Driver!");
}
catch (Exception e) {
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
} try {
Connection connect = DriverManager.getConnection(
"jdbc:mysql://3.243.217.12:3306/worklog", "root", "root"); System.out.println("Success connect Mysql server!"); Statement stmt = connect.createStatement();
ResultSet rs = stmt.executeQuery("select * from classification");
while (rs.next()) {
System.out.println(rs.getString("no")); }
}
catch (Exception e) {
System.out.print("get data error!");
e.printStackTrace();
}
}
}///////////////////////////////////
Success loading Mysql Driver!
get data error!java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream** BEGIN NESTED EXCEPTION ** java.io.IOException
MESSAGE: Unexpected end of input streamSTACKTRACE:java.io.IOException: Unexpected end of input stream
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at My.main(My.java:15)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:699)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at My.main(My.java:15)
这是什么原因 我用4.0就不出现这个问题!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货