closedb.java

实现JSP开发的BBS源码

//package closeDBclass;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

//关闭数据库类
public class closeDB{
    static Statement st=null;
	static Connection con=null;
	static ResultSet rs=null;
	
	public closeDB(){
		
	}
	static public Statement closeDB(Statement st,Connection con){
		try{
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
			st.close();
			con.close();
		}catch(SQLException ex){
			JOptionPane.showMessageDialog(null,"数据库关闭失败!");
		}
	return st;
	}
	static public Statement closeDB(Statement st,Connection con,String databaseName){
		try{
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName="+databaseName+"","sa","5201314");
			st.close();
			con.close();
		}catch(SQLException ex){
			JOptionPane.showMessageDialog(null,"数据库关闭失败!");
		}
	return st;
	}
}