db.java

数据库连接源代码

package lyovercome.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DB
{
	public Connection getConn()
	{
		Connection conn=null;
		try
		{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		
		}
		catch (ClassNotFoundException e)
		{
			System.out.println("驱动加载失败");
		}
		try
		{
			conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;database=shopping;user=admin;password=123");
			//conn=DriverManager.getConnection("jdbc:odbc:shop");
		}
		catch (SQLException e)
		{
		}
		return conn;
	}
	/*public static void main(String[] args)
	{
		DB db=new DB();
		Connection conn=db.getConn();
		System.out.println(conn);
	}*/

};