dbconnection.java

商品管理系统

package com.accp.struts.Bean;

import java.sql.*;
public class DBConnection {
	
	public  static Connection getConnection(){
		Connection conn = null;
        String url = "jdbc:microsoft:sqlserver://";
        String serverName = "localhost";
        String portName = "1433";
        String databaseName = "shops";
        String userName = "sa";
        String password = "sa";
        String URL = url + serverName + ":" + portName + ";databaseName="+databaseName + ";";
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            conn = DriverManager.getConnection(URL,userName,password);
        }
        catch(Exception e){
            e.printStackTrace();
        }
        return conn;
	}

}