jdbc.java

来自「实现比较简单的网吧计费系统,大家看看看吧」· Java 代码 · 共 76 行

package huabinnetbar;

import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Jdbc {
    private Connection con=null;
        public PreparedStatement stmt=null;
        public ResultSet rs=null;

        public void toConnetion(String odbc){
            try {
                //导入驱动
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                //创建Connection对象连接数据源
                con = DriverManager.getConnection("jdbc:odbc:"+odbc);
            } catch (SQLException ex) {
            } catch (ClassNotFoundException ex) {
                ex.printStackTrace();
            }
        }
        //此方法实现对数据库的查询操作
        public void doSelect(String sql){
            try {
                if (con != null) {
                    stmt = con.prepareStatement(sql);
                    rs = stmt.executeQuery();
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
        //此方法实现对数据库的增.删,改操作
        public int doUpdate(String sql){
            int lines=0;
            try {
                if (con != null) {
                    stmt = con.prepareStatement(sql);
                    lines = stmt.executeUpdate();
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            return lines;
        }
        //关闭数据库的连接正确的释放资源
        public void doClose(){
            try {
                if (rs != null) {
                    rs.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
                if (con != null && !con.isClosed()) {
                    con.close();
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
    }


}