常规的连接数据库方法(以MySQL为例)
第一步:创建数据库连接类
package com.dzsw.util;
//先在lib下引入包:mysql-connector-java-5.1.39-bin.jar
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
//import java.sql.*;
//连接数据库的工具类
public class Todb {
//jdba java database connect
static final String NAME = "root";
static final String PASSWORD = "123456";
//链接地址 协议 地址 数据库名
static final String URL = "jdbc:mysql://localhost:3306/test";
static final String DRIVER = "com.mysql.jdbc.Driver";
public static Connection getConnection() {
Connection con = null;
try {
//加载驱动
Class.forName(DRIVER);
//获取连接
con= (Connection) DriverManager.getConnection(URL,NAME,PASSWORD);
}catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
return