最基本的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;
- }
- }