connectserver.java

来自「用java刚刚写了不久的学生管理系统」· Java 代码 · 共 50 行

//作者：沈阳
//时间：2008年11月6日
import java.sql.*;
import javax.swing.*;
/*------------------------------------ConnectServer--------------------------------*/
class ConnectServer {	
	static Connection con = null;	
	//---------------------------------------conn-----------------------------------------
	public static boolean conn(String url,String username,String password){
		try{//安装数据库驱动程序
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");	
		}
		catch(Exception e){
			e.printStackTrace();
			return false;		
		}		
		try{//建立和数据库的连接
			con = DriverManager.getConnection(url,username,password);	
			System.out.println("***********************");
		}
		catch(SQLException e){
			e.printStackTrace();
			return false;		
		}
		return true;
	}//end of conn
	//----------------------------------------close-----------------------------------------
	public static boolean close(){
		try{
			con.close();
			con = null;
		//	JOptionPane.showMessageDialog(null,"数据库关闭成功！");
		}	
		catch(SQLException esql){
			JOptionPane.showMessageDialog(null,"数据库关闭失败！");
			return false;	
		}
		return true;
	}//end of close
	//------------------------------------mainLink-----------------------------------------
	public static void mainLink(){		//only for test
		if(!ConnectServer.conn("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DBStudent","sa","sql"))
     	{  
         	JOptionPane.showMessageDialog(null,"数据库连接不成功!");
         	System.exit(0);
      	}
      	System.out.println("--------------------------------");
	}//end of mainLink	
}//end of class ConnectServer