步骤如下:1、拷贝数据库连接驱动到lib目录2、代码如下: package com.lwm.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class BaseDao { //数据库驱动 private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //数据库的连接地址 private static final String URL = "jdbc:sqlserver://127.0.0.1;database=MyBlogHome"; //连接数据库的用户名 private static final String UID = "sa"; //连接数据库的密码 private static final String PWD = "123456"; protected Connection connection; protected PreparedStatement statement; protected ResultSet result; /** * 返回数据库连接对象 * @return */ public Connection getConnection(){ try { Class.forName(DRIVER); connection = DriverManager.getConnection(URL,UID,PWD); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return connection; } /** * 关闭全部连接 * @param connection * @param statement * @param result */ public void closeAll(Connection connection,PreparedStatement statement,ResultSet result){ if (result != null){ try { result.close(); result = null; } catch (SQLException e) { e.printStackTrace(); } } if (statement != null){ try { statement.close(); statement = null; } catch (SQLException e) { e.printStackTrace(); } } try { if (connection != null && !connection.isClosed()){ connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } }