数据库连接

2019-11-08 03:06:49

字体：大中小

来源：转载

供稿：网友

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();}}}}

上一篇：打印"*"等腰三角形

下一篇：c语言指针链表