package com.bbs.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public abstract class BaseDAO {
// SQL Server 2005 中的连接，驱动包有三个msbase.jar，mssqlserver.jar，msutil.jar
private final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private final String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=csu";
// SQL Server 2000 中的连接，驱动包只有一个sqljdbc.jar
//public static final String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//public static final String URL = "jdbc:microsoft:sqlserver://localhost:1433;databasename=csu";
private final String USER = "liky";
private final String PWD = "redhat";
public Connection getConnection() {
Connection con = null;
try {
Class.forName(DRIVER);
con = DriverManager.getConnection(URL, USER, PWD);
} catch (ClassNotFoundException cnfe) {
System.err.println(cnfe.getMessage());
} catch (SQLException sqle) {
System.err.println(sqle.getMessage());
}
return con;
}
}