connectdb.java

来自「实现JSP开发的BBS源码」· Java 代码 · 共 47 行

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

//连接数据库类
public class connectDB{
    static Statement st=null;
	static Connection con=null;
	static ResultSet rs=null;
	static String databaseName=null;
	
	
	public connectDB(){
	}
	
	static public Statement conDB(){
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		}catch(ClassNotFoundException e){
			JOptionPane.showMessageDialog(null,"数据库加载失败!");
		}
		try{
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","yukechao","5201314");
			st=con.createStatement();
		}catch(SQLException ex){
			JOptionPane.showMessageDialog(null,"数据库连接失败!");
		}
	return st;
	}
	static public Statement conDB(String databaseName){
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		}catch(ClassNotFoundException e){
			JOptionPane.showMessageDialog(null,"数据库加载失败!");
		}
		try{
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName="+databaseName+"","sa","5201314");
			st=con.createStatement();
		}catch(SQLException ex){
			JOptionPane.showMessageDialog(null,"数据库连接失败!");
		}
	return st;
	}
}