jdbconnection.java

基于struts框架制作

package com.tool;

import java.sql.*;

public class JDBConnection {
  private String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //数据库的驱动
  private String url = "jdbc:sqlserver://localhost:1433;databasename=db_shopping"; //URL地址
  public Connection connection = null;
  public JDBConnection() {
    try {
      Class.forName(dbDriver); //加载数据库驱动
      connection = DriverManager.getConnection(url, "sa","123456"); //加载数据库
     
    }
    catch (Exception ex) {
    	ex.printStackTrace();
      System.out.println("数据库加载失败");
    }
  }

}