代码是这个样子的,求高手指点。
package com.cn.jdbc;import java.sql.DriverManager;import java.sql.SQLException;import com.mysql.jdbc.Connection;public class JDBC_Connection {
static String drivername = "com.mysql.jdbc.Driver";
static String url = "jdbc:mysql://localhost:8080/zcl";
static String username = "root";
static String password = "root";
static{
try {
Class.forName(drivername);
System.out.println("创建驱动成功");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn = null;
try{
conn = (Connection) DriverManager.getConnection(url,username,password);
System.out.println("连接数据库成功访");
}catch(SQLException e){
System.out.println("数据库连接失败!");
e.printStackTrace();
}
return conn;
}
public static void main(String [] args){
JDBC_Connection.getConnection();
}
}
package com.cn.jdbc;import java.sql.DriverManager;import java.sql.SQLException;import com.mysql.jdbc.Connection;public class JDBC_Connection {
static String drivername = "com.mysql.jdbc.Driver";
static String url = "jdbc:mysql://localhost:8080/zcl";
static String username = "root";
static String password = "root";
static{
try {
Class.forName(drivername);
System.out.println("创建驱动成功");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn = null;
try{
conn = (Connection) DriverManager.getConnection(url,username,password);
System.out.println("连接数据库成功访");
}catch(SQLException e){
System.out.println("数据库连接失败!");
e.printStackTrace();
}
return conn;
}
public static void main(String [] args){
JDBC_Connection.getConnection();
}
}
解决方案 »
- 初始学求教
- 求助前辈们关于set的用法
- mysql如何删掉数据表成绩最低的一条记录
- 请问mysql库-->user表--->host字段--->%--->什么意思?
- 为何我用 mysqld 启动 mysql 的服务后,在系统“服务”中查不到mysql服务呢?
- Java访问MySQL ,判断符合条件的记录是否为空
- 今天遇到一个组合查询 问题《高分求救!!!!!!>
- 请问我应该怎样使用mysql-front 3.2啊?
- mysql影响行数是什么意思?
- 不安装sql server 或者mysql、,只靠windows 默认的ODBC能否驱动excel表或者是access表?
- 编译安装的Mysql 第一次启动报错如下
- linux 系统如何安装MYSQL
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connectSTACKTRACE:java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.cn.jdbc.JDBC_Connection.getConnection(JDBC_Connection.java:26)
at com.cn.jdbc.JDBC_Connection.main(JDBC_Connection.java:36)
** END NESTED EXCEPTION **Last packet sent to the server was 16 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2621)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.cn.jdbc.JDBC_Connection.getConnection(JDBC_Connection.java:26)
at com.cn.jdbc.JDBC_Connection.main(JDBC_Connection.java:36)