java如何连接SQLserver数据库?

注意：在使用这个类的时候，先将对应数据库的驱动包（JAR包），复制进项目的WebRoot文件夹下的WEB-INF文件夹下的lib文件夹下，切记必须要对应的JAR包，否则无法使用数据库的

import java.sql.*

public class BaseDAO {

private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"//注意：此驱动是SQL2005及以上版本的导入驱动包连接字符串

private static final String CONNECTION = "jdbc:sqlserver://localhost:1433databaseName=Employee"//数据库连接字符串，databaseName就是你要连接的数据库名，

private static final String NAME = "sa" //数据库用户名

private static final String PWD = "sa" //数据库密码

public static Connection GetConnection() {

Connection con = null

try {

Class.forName(DRIVER)

con = DriverManager.getConnection(CONNECTION, NAME, PWD)

} catch (Exception e) {

// TODO: handle exception

e.printStackTrace()

}

return con

}

public static void close(ResultSet rs, PreparedStatement ps, Connection con) {

try {

if (null != rs) {

rs.close()

}

if (null != ps) {

ps.close()

}

if (null != con) {

con.close()

}

} catch (Exception e) {

e.printStackTrace()

}

}

}

写个JDBC连接类、获取一个连接就行了！

public class JdbcUtil {

/** 配置文件路径 */

private final static String FILEDIR = "/config.properties"

/** 获取driverName键值 */

private final static String driverName = "jdbc.driverName"

/** 获取url键值 */

private final static String url = "jdbc.url"

/** 获取driverName键值 */

private final static String username = "jdbc.userName"

/** 获取url键值 */

private final static String password = "jdbc.password"

private static JdbcOperate jdbcUtil = new JdbcUtil()

private JdbcUtil(){}

public static JdbcUtil getInstance() {

return jdbcUtil

}

/**

* 创建数据库连接

* @author *** 2012-4-9 下午05:43:08

* @return Connction 数据库连接对象

*/

@SuppressWarnings("finally")

public Connection getConnection() {

Connection conn = null

try {

//加载驱动程序

Class.forName(getDriverName()).newInstance()

//建立连接

conn = DriverManager.getConnection(getUrl(),getUserName(),getPassword())

} catch (Exception e) {

e.printStackTrace()

} finally {

return conn

}

}

｝

---