通用jdbc链接-mysql

java 代码

package com.com.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConn {

    private Connection conn = null;

    Statement statement = null;

    ResultSet rs = null;

    public DBConn() {
        try {
            Class.forName("com.mysql.jdbc.Driver");// 加载驱动程序
            conn = DriverManager.getConnection(
                    "jdbc:mysql://localhost/actions", "admin", "111111");
            statement = conn.createStatement();
        } catch (Exception e) {
            e.printStackTrace();
            conn = null;
        }
    }

    public DBConn(String dbname) {
        try {
            Class.forName("com.mysql.jdbc.Driver");// 加载驱动程序
            String url = "jdbc:mysql://localhost/" + dbname;
            conn = DriverManager.getConnection(url, "admin", "111111");
            statement = conn.createStatement();
        } catch (Exception e) {
            e.printStackTrace();
            conn = null;
        }
    }

    public void update(String sql) {
        try {
            statement.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public ResultSet query(String sql) {
        ResultSet rs = null;
        try {
            rs = statement.executeQuery(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return rs;
    }

    public void close() {
        try {
            if (rs != null) {
                rs.close();
                rs = null;
            }

            if (statement != null) {
                statement.close();
                statement = null;
            }

            if (conn != null) {
                conn.close();
                conn = null;
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

分享到：

SQLyog v4.0.2 企业特别版 | JIMI的学习

• 2007-05-28 09:00
• 浏览 3593
• 评论(1)
• 论坛回复 / 浏览 (0 / 2339)
• 分类:企业架构
• 查看更多

评论

1 楼 yyjn12 2007-05-28  

不错,挺好的.学习!