首先要在lib目录下导入jar包:mysql-connector-java-3.0.17-ga-bin.jar
我连接的是MySQL的数据库。数据库名为:strut2user,用户名和密码为:root.
数据库连接代码ConnectDB.java
package com.struts.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnectDB {
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConn() {
Connection conn = null;
try {
conn = (Connection) DriverManager.getConnection(
"jdbc:mysql://localhost:3308/strut2user", "root", "root");
//System.out.println("数据库连接成功");
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
conn = null;
}
}
public static void close(Statement stmt) {
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
stmt = null;
}
}
public static void close(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
}
}
测试代码TestDB.java
需要把上面代码中的 //System.out.println("数据接成功");此段话的注释去掉。
如果连接成功,会在控制台打印“数据库连接成功”;
package com.struts.dao;
import com.mysql.jdbc.Connection;
public class TestDB {
public static void main(String[] args) {
Connection conn=(Connection)ConnectDB.getConn();
}
}