manager.java~1~

来自「新闻管理系统」· JAVA~1~ 代码 · 共 29 行

package newsset;
import java.sql.*;
public class Manager extends DBBean {
    public int Sum() {
        String sql = "select count(*) as sum from shop ";
        int sum = 0;
        ResultSet rs = null;
        System.out.println(sql);
        rs=this.executeQuery(sql);
        try {
            if (rs.next()) {
                sum = rs.getInt(1);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return sum;
    }

    public ResultSet selectAll() {
        ResultSet rs = null;
        String sql="select * from shop";
        rs=this.executeQuery(sql);

        return rs;
    }

}