c065fff99d0a001c1ab6bb783faf21cc

一个自行开发的网上商店一个自行开发的网上商店一个自行开发的网上商店

package com.database;

import java.sql.*;
import javax.swing.JOptionPane;

public class DBconn{
	
	Connection con=null;
	String DRIVER_CLASS ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
 	static String DATABASE_URL ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sportsDB";
	public Connection getConnect()
	{
		try
		{
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		}
		catch(ClassNotFoundException ex)
		{
			JOptionPane.showMessageDialog(null, "数据库驱动出错!");
		}
		try
		{
			//con=DriverManager.getConnection("jdbc:odbc:test","","");
			con=DriverManager.getConnection(DATABASE_URL, "sa", "");
		}catch(SQLException e)
		{
			JOptionPane.showMessageDialog(null, "数据库连接出错!");
		}
		return con;
	}
}