jdbconnection.java~5~

来自「《struts应用开发完全手册》中的源代码及安装指导」· JAVA~5~ 代码 · 共 85 行

package com.dao;

import java.sql.*;

public class JDBConnection {
    private final String dbDriver = "net.sourceforge.jtds.jdbc.Driver"; //加载数据库驱动
    private final String url =
            "jdbc:jtds:sqlserver://localhost:1433/db_upDownLoad";

    private final String userName = "sa";
    private final String password = "";
    private Connection con = null;

    public JDBConnection() {
        try {
            Class.forName(dbDriver).newInstance(); //加载数据库驱动
        } catch (Exception ex) {
            System.out.println("数据库加载失败");
        }
    }

//创建数据库连接
    public boolean creatConnection() {
        try {
            con = DriverManager.getConnection(url, userName, password);
            con.setAutoCommit(true);

        } catch (SQLException e) {

        }
        return true;
    }

//对数据库的增加、修改和删除的操作
    public boolean executeUpdate(String sql) {

        if (con == null) {
            creatConnection();
        }
        try {
            Statement stmt = con.createStatement();
            int iCount = stmt.executeUpdate(sql);
            System.out.println("操作成功，所影响的记录数为" + String.valueOf(iCount));
        } catch (SQLException e) {

        }
        return true;
    }

//对数据库的查询操作
    public ResultSet executeQuery(String sql) {
        ResultSet rs;
        try {
            if (con == null) {
                creatConnection();
            }
            Statement stmt = con.createStatement();
            try {
                rs = stmt.executeQuery(sql);
            } catch (SQLException e) {

                return null;
            }
        } catch (SQLException e) {

            return null;
        }
        return rs;
    }

//关闭数据库的操作
    public void closeConnection() {
        if (con != null) {
            try {
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                con = null;
            }
        }
    }

}