JavaBean连接MySQL,想改为连接msspl

来源:百度知道 编辑:UC知道 时间:2024/05/16 03:05:11
package ajax.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;

public class DBUtils {
private static final String OPTION_FILE_NAME = "ajax_db";

private static String drivers;

private static String url;

private static String user;

private static String password;
static {
ResourceBundle res = ResourceBundle.getBundle(OPTION_FILE_NAME);
drivers = res.getString("DRIVERS").trim();
url = res.getString("URL").trim();
user = res.getString("USER").trim();
password = res.getString("PASSWORD").trim();
}

public static Connection getConnection() throws SQLException {
Connection conn = null;
try {
Class.forName(drivers).newInstance();
c

MSSQL和MYSQL没有分别,只要改下连接字符串就可以了。
//1、连接SqlServer2000
//private String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//private String url="jdbc:microsoft:sqlserver://localhost:1433";

user =
password =

有分别吗
改驱动