package com.java.util;
/**
- 数据库工具类
- @author 26215
- /
import java.sql.Connection;
import java.sql.DriverManager;
public class DbUtil {
private String dbUrl = "jdbc:msql://localhost:3306/db_book";// 数据库连接地址
private String dbUserName = "root";// 用户名
private String dbPassword = "123456";// 密码
private String jdbcName = "com.mysql.jdbc.Driver";// 驱动名称
/**
* 获取数据库连接
*
* @return
* @throws Exception
*/
public Connection getCon() throws Exception {
Class.forName(jdbcName);
Connection con = DriverManager.getConnection(dbUrl, dbUserName, dbPassword);
return con;
}
/**
* 关闭数据库连接
*/
public void cloesCon(Connection con) throws Exception {
if (con != null) {
con.close();
}
}
public static void main(String[] args) {
DbUtil dbUtil = new DbUtil();
try {
dbUtil.getCon();
System.out.println("数据库连接成功");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("数据库连接失败");
}
}
}
实现结果
java.sql.SQLException: No suitable driver found for jdbc:msql://localhost:3306/db_book
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.java.util.DbUtil.getCon(DbUtil.java:27)
at com.java.util.DbUtil.main(DbUtil.java:45)
数据库连接失败