数据库工具类

package com.imau.jdbc;
import java.sql.*;

import javax.sql.*;
// 数据库工具类

public class DBUtils {

private static Connection conn=null;
private static String url="jdbc:mysql://localhost:3306/stucms";
private static String user="root"; 
private static String password="12345678";

//数据库连接
public static Connection getConn() {
	
	
	try {
		
		Class.forName("com.mysql.jdbc.Driver");
		
		conn=DriverManager.getConnection(url, user, password);
		
		return conn;
		
	} catch (Exception e) {
	    e.printStackTrace();
	} 
	

	
	return null;
}

//释放数据资源
public static void close(Connection conn,PreparedStatement pstm,ResultSet rs) {
	
	
	try {
		
		if(rs!=null) {
			rs.close();
		}
		
		if(pstm!=null) {
			pstm.close();
			
		}
		
		if(conn!=null) {
			
			conn.close();
		}
		
		
	} catch (Exception e) {
		e.printStackTrace();
	}
	
}

}