chargemanager.java

这是中国移动的一个管理系统

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

import com.mobile.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 *
 * @author st
 */
public class ChargeManager {

    private ChargeManager() {
    }
    private static ChargeManager manager = null;

    public static ChargeManager getInstance() {
        if (manager == null) {
            manager = new ChargeManager();
        }
        return manager;
    }

    //.........................................................
    //更新  A D 10
    public boolean updateCharge(String code, double charge) {
        Connection conn = null;
        PreparedStatement stmt = null;
        int rs = -1;

        String sql = " update tcharge set charge= ? where charge_code = ?";

        try {
            conn = DBUtil.getConnection();
            stmt = conn.prepareStatement(sql);
            stmt.setDouble(1, charge);
            stmt.setString(2, code);
            rs = stmt.executeUpdate();

            if (rs == 0) {
                return false;
            } else {
                return true;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        } finally {
            DBUtil.close(null, stmt, conn);
        }
    }

    public String getCharges() {
        String message = "";

        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        String sql = "select *  from  tcharge ";

        try {
            conn = DBUtil.getConnection();
            stmt = conn.prepareStatement(sql);
            rs = stmt.executeQuery();
            while (rs.next()) {
                message += rs.getString(1) + " : ";
                message += rs.getString(2) + " : ";
                message += rs.getString(3) + " : ";
                message += "\r\n";
            }



        } catch (SQLException ex) {
            ex.printStackTrace();

        } finally {
            DBUtil.close(rs, stmt, conn);
        }
        return message;
    }
//   public static void main(String[] args){
//       String is =  ChargeManager.getInstance().getCharges();
//       System.out.println(is);
//   }
}