connectiondb.java

来自「java编写小型超市管理系统+数据库.用于小型超市简单的货品进存销」· Java 代码 · 共 61 行

package com.wish;
import java.sql.*;
import javax.swing.JOptionPane;
//连接类，返回一个连接
class ConnectionDB {
	public static Connection getCon()
	{	
		Connection cn=null;
		String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=supermarket";
		String user="sa";
		String pwd="";
		
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			cn=DriverManager.getConnection(url,user,pwd);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			JOptionPane.showMessageDialog(null, "导入SQL包错误");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			JOptionPane.showMessageDialog(null, "配置文件出错！");
		}
		return cn;
	}
	public static void close(Connection n)
	{
		if(n!=null)
		{
			try {
				n.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	public static void close(Statement n)
	{
		if(n!=null)
		{
			try {
				n.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	public static void close(ResultSet n)
	{
		if(n!=null)
		{
			try {
				n.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}