databaseconnect.java

模拟图书馆管理系统 实现了各种图书馆管理功能

import java.sql.*;

import javax.swing.JOptionPane;
public class DataBaseConnect {
 
 public static void connectTest(String url,String user,String password){
	 //String sqlStr = "select CustomerID, CompanyName, ContactName from Customers";
	 try{
		 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		 Connection connection = DriverManager.getConnection(url,user,password); 
		 Statement statement = connection.createStatement();
		/* ResultSet resultSet = statement.executeQuery(sqlStr); 
		 while(resultSet.next()) { 
			 System.out.print(resultSet.getString("CustomerID") + " "); 
			 System.out.print(resultSet.getString("CompanyName") + " "); 
			 System.out.println(resultSet.getString("ContactName")); 
			 }
		 resultSet.close(); */
		 JOptionPane.showMessageDialog(null, "测试连接成功","成功",JOptionPane.INFORMATION_MESSAGE);
		 statement.close(); 
		 connection.close(); 
	 }catch(Exception e) { 
		 e.printStackTrace(); 
		 JOptionPane.showMessageDialog(null, "测试连接失败", "失败", JOptionPane.ERROR_MESSAGE);
	 } 
 }
 
 public static Connection connect(String url,String user,String password){
	 try{
		 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		 Connection connection = DriverManager.getConnection(url,user,password); 
		 return connection;
	 }catch(Exception e) { 
		 e.printStackTrace(); 
		 return null;
	 } 
 }
}