jdbc连接mysql的问题
安装mysql成功,在命令行下mysql可以工作,但每次都要运行一下mysqlmanager,而且没有出现系统托盘(信号灯)。mysql jdbc driver 用的是mysql-connector-java-3.0.8-stable-bin.jar 从一个java报表软件中找到的,classpath 也设置了,
但是下面的程序出错:System.out.println("connection is beginning");
Class.forName("com.mysql.jdbc.Driver").newInstance();
System.out.println("handshake");
String url = "jdbc:mysql://localhost/lbz_db";
// testDB为你的数据库名
Connection conn = DriverManager.getConnection(url,"","");
System.out.println("get connection ");
Statement stmt = conn
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from cust_reply";
System.out.println("execute");
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
}
出错信息如下:
java.sql.SQLException: Communication link failure: Bad handshake
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:659)
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 org.hibernate.auction.LbzMySqlTest.main(LbzMySqlTest.java:29)
哪位高人指点一下