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
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 =
有分别吗
改驱动