Java连接MySQL数据库
数据库帮助类DBHelper.java
使用的JDBC驱动是 mysql-connector-java-8.0.25.jar
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class DBHelper {
private static String url = "jdbc:mysql://localhost:3306/test?setCharacterEncoding=utf-8";
private static String driver = "com.mysql.cj.jdbc.Driver";
private static String user = "root";
private static String password = "123456";
public static Connection getConnection(){
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,user,password);
return conn;
}catch (Exception e){
e.printStackTrace();
}
return null;
}
public static void closeConnection(Connection conn, Statement st, ResultSet rs){
try {
if(conn != null) conn.close();
if(st != null) st.close();
if(rs != null) rs.close();
}catch (Exception e){
e.printStackTrace();
}
}
public static void main(String[] args) {
Connection conn = DBHelper.getConnection();
System.out.println("连接成功");
DBHelper.closeConnection(conn,null,null);
System.out.println("连接关闭");
}
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)