dbconnection.java

来自「这是java的源代码,感觉上是挺不错的哦,要下载赶快来哦,有附加数据库的哦」· Java 代码 · 共 63 行

package ptu.db;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConnection 
{
	  private static final String conURL="jdbc:jtds:sqlserver://127.0.0.1:1433/ptstu;user=sa;password=11";
	    private static final String classInfo="net.sourceforge.jtds.jdbc.Driver";	
		
		
		public static Connection getConnection() throws Exception{
			Connection con=null;
	        try {
	            Class.forName(classInfo);
	        } catch (ClassNotFoundException ex) {
	            throw new SQLException("请确认数据库是否加载");
	        }
	        con=java.sql.DriverManager.getConnection(conURL);
			return con;
		}
		
		
		public static void closeConnection(Connection con){
			if (con!=null){
				try {
					con.close();
					con=null;
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		
		public static void closeStatement(Statement statement){
			if (statement!=null){
				try {
					statement.close();
					statement=null;
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		
		public static void closeResultSet(ResultSet rs){
			if (rs!=null){
				try {
					rs.close();
					rs=null;
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}

}