sqlcontroller.java

银行系统中储蓄模块的实现

package Database;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class SqlController {
    Connection con;
    public SqlController(Connection con) {
        this.con = con;
    }

    public ResultSet  SelectStmt(String aSelectStatement)
    {
        ResultSet rs = null;
        Statement st = null;
        try {
        //实例化一个在con链接上的数据库语句
            st = con.createStatement();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }

        try {
        //执行aStatement这个语句
        //将查询的结果返回给rs对象
            rs = st.executeQuery(aSelectStatement);
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
        return rs;
    }

    public void UpdateStmt(String aUpdateStatement)
    {
        Statement st = null;
        try {
            st = con.createStatement();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }

        try {
        //executeUpdate方法适用于insert/create/delete/drop/update等语句
        st.executeUpdate(aUpdateStatement);
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
    }
}