methodclass.java

做太久,忘了什么功能了!好象取款机的功能..冒似...

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() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    Statement stam;
    Connection con;
    //连接方法
    void getConnection(){
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:banktest");
        } 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();
    }
    //时间的方法
    public static String Time () throws SQLException {
            MethodClass obj = new MethodClass();
            ResultSet rs = obj.Query("select convert(smalldatetime,getdate())");
            rs.next();
            return rs.getString(1);
    }
    private void jbInit() throws Exception {
    }
}