数据库连接

package org.utils;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;










public class MySqlConnection {


private static final String Url = "jdbc:mysql://127.0.0.1:3306/test";// MySql的连接地址
private static final String UserName = "root";// MySql的用户名
private static final String PassWord = "1234";// MySql的密码


// <1>获取数据库连接资源
public Connection getConnection() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(Url, UserName, PassWord);
} catch (Exception e) {
System.out.println("<===连接数据库失败===>" + e);
e.printStackTrace();
}
return conn;
}


// <2>关闭数据库连接
public void close(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
System.out.println("<===关闭数据库连接失败===>" + e);
e.printStackTrace();
}
}
}


// <3>关闭数据库描述
public void close(Statement ps) {
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
System.out.println("<===关闭数据库描述失败===>" + e);
e.printStackTrace();
}
}
}


// <4>关闭数据库结果集
public void close(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
System.out.println("<===关闭数据库结果集失败===>" + e);
e.printStackTrace();
}
}
}


}