java中关于数据库连接的获取

package com.util.www;import java.sql.*;public class DBUtil {//获取数据库连接public Connection getConn(){Connection conn=null;try {//加载驱动Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//获取连接conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=qlzx","sa","123456");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}//关闭数据库服务连接public void closeConn(ResultSet rs,PreparedStatement ps,Connection conn){try{//判断并关闭if(rs!=null){rs.close();}if(ps!=null){ps.close();}if(conn!=null){conn.close();}}catch(SQLException e){e.printStackTrace();}}}