Java - 最基本的JDBC连接
这是一个最基本的JDBC连接类，忘记怎么写的朋友可以拿来当回忆，呵呵

package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class BaseDao {public static final String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";public static final String url = "jdbc:sqlserver://127.0.0.1:1433;database=ebook";public static final String uid = "sa";public static final String pwd = "123456";/** * 创建连接对象 * @return */public Connection getConnection(){Connection connection = null;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();}}/** * 执行增、删、改操作 * @param sql * @param param * @return */public int executeQuery(String sql,String[] param){Connection connection = null;PreparedStatement statement = null;int num = 0;try {connection = this.getConnection();statement = connection.prepareStatement(sql);for (int i = 0 ; i < param.length ; i++){statement.setString(i+1, param[i]);}num = statement.executeUpdate();} catch (SQLException e) {e.printStackTrace();} finally {this.closeAll(connection, statement, null);}return num;}}