databaseconnection.java

来自「可以把客户端的内容存入数据库中」· Java 代码 · 共 55 行

package com.conn;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DatabaseConnection {
	public static String url="jdbc:odbc:User_DSN";
	public static String user="";
	public static String password="";
	public static String driver="sun.jdbc.odbc.JdbcOdbcDriver";
	public static Connection getConnection() throws ClassNotFoundException {
		try{
			Class.forName(driver);
			return DriverManager.getConnection(url,user,password);
		}catch(SQLException e){
			
			e.printStackTrace();
			return null;
		}
		
	}

	public static void releaseConnection(Connection conn, PreparedStatement st, ResultSet rs) {
		if(rs!=null){
			try{
				rs.close();
			}
		catch(SQLException e){
			e.printStackTrace();
			}
		}
		if(st!=null){
			try{
				st.close();
				}
			catch(SQLException e){
				e.printStackTrace();
			}
		}
		if(conn!=null){
			try{
				conn.close();
				}
			catch(SQLException e){
				e.printStackTrace();
			}
		}
		
	}
}