methodclass.java~1~

来自「做太久,忘了什么功能了!好象取款机的功能..冒似...」· JAVA~1~ 代码 · 共 59 行

package bankmanager;

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.ResultSet;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */

public class MethodClass {
    public MethodClass() {
    }
    Statement stam;
    Connection con;
    //连接方法
    void getConnection(){
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:netbar");
        } catch (Exception ex) {
        }
    }
    //查询方法
    public ResultSet Query(String sql){
        this.getConnection();
        ResultSet rs = null;
        try {
            stam = con.createStatement();
            rs = stam.executeQuery(sql);
        } catch (SQLException ex) {
            ex.getMessage();
        }
        return rs;
    }
    //更新方法
    public void Update(String sql){
        this.getConnection();
        try {
        stam = con.createStatement();
        stam.executeUpdate(sql);
        } catch (SQLException ex) {
            System.out.println(ex);
        }
    }
    //关闭方法
    public void Close() throws SQLException {
        stam.close();
        con.close();
    }
}