java连接mysql数据库实例源码



java连接mysql数据库实例源码。JDBC应用创建mysql驱动。连接MYSQL数据库的操作步骤与方法。

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:3306/bank”;
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) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
JDBC_Connection.getConnection();
}

}