dbconnetion.java

jiava中简单的基础的jsp增删改查适合处学者

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package db;

import java.sql.*;
/**
 *
 * @author Administrator
 */
public class DBConnetion {

    Connection conn = null;
    ResultSet rs = null;
    Statement stm = null;
    //连接方法
    private Connection getConn() {
        try {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection("jdbc:odbc:test");

        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return conn;
    }
    //查询方法
    public ResultSet selectQeary(String sql) {

        try {
            conn = this.getConn();
            stm = conn.createStatement();
            rs = stm.executeQuery(sql);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return rs;
    }
    //更新方法
    public int updateQeary(String sql) {
        int num = 0;
        try {
            conn = this.getConn();
            stm = conn.createStatement();
            num = stm.executeUpdate(sql);
        } catch (Exception ex) {
            ex.printStackTrace();
        }finally{
            this.close();
        }
        return num;
    }
    //关闭
    public void close(){
        try{
            stm.close();
            conn.close();
        }catch(Exception ex){
            ex.printStackTrace();
        }
    }
}