不废话上干货。
package com.yl.util;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;public class JdbcUtil {/*** 加载驱动* 连接数据库* @return*/public static Connection getConn(){Connection conn=null;try {Class.forName("com.mysql.jdbc.Driver");try {conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/xt?characterEncoding=utf-8", "root", "123456");//conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/xt?characterEncoding=utf-8", "root", "root");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}/*** 关闭* @param ps* @param conn*/public static void close(PreparedStatement ps,Connection conn){if(ps!=null){try {ps.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(conn!=null){try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}
}