connectdb.java

实现JSP开发的BBS源码

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;
	
	public connectDB(){
	}
	
	static public Statement conDB(){
		try{
			Class.forName("org.postgresql.Driver");
		}catch(ClassNotFoundException e){
			JOptionPane.showMessageDialog(null,"数据库加载失败!");
		}
		try{
			con=DriverManager.getConnection("jdbc:postgresql:BSMS","yukechao","123456");
			st=con.createStatement();
		}catch(SQLException ex){
			JOptionPane.showMessageDialog(null,"数据库连接失败!");
		}
	return st;
	}
}