JDBC工具类

最新推荐文章于 2023-01-12 10:53:41 发布

深海浩

最新推荐文章于 2023-01-12 10:53:41 发布

阅读量88

点赞数

分类专栏： Java Date JDBC 文章标签： JDBCUtil工具类

本文链接：https://blog.csdn.net/qq_40297463/article/details/100567507

版权

Java 同时被 3 个专栏收录

22 篇文章 0 订阅

订阅专栏

Date

3 篇文章 0 订阅

订阅专栏

JDBC

3 篇文章 0 订阅

订阅专栏

写个JDBC工具类怕以后忘记了：

public class JdbcUtil {
	public static Connection getConnection() throws Exception {
		//	1.加载驱动
	
		Class.forName("com.mysql.jdbc.Driver");
			
	/*		
	        Properties properties=new Properties();
			properties.load(new FileInputStream("db.properties"));
			//获取各种属性
			String user=properties.getProperty("user");
			String password=properties.getProperty("password");
			String url=properties.getProperty("url");
			String driverClass=properties.getProperty("driverClass");
			*/
		        String user="root";
				String password="123456";
				String url="jdbc:mysql://localhost:3306/haosql";
				
			
			Connection conn=DriverManager.getConnection(url, user, password);

			return conn;
		}
		public static void releaseSourse(Connection conn,Statement stmt,ResultSet result) {
			try {
				conn.close();
				stmt.close();
				result.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		public static void releaseSourse(Statement stmt,ResultSet result) {
			try {
				
				stmt.close();
				result.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		public static void releaseSourse(Connection conn,Statement stmt) {
			try {
				conn.close();
				stmt.close();
				
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		public static void releaseSourse(Connection conn) {
			try {
				conn.close();
				
				
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		 }
}