/**
*  Title  財務管理系統
*  @author: trowa
*  Company: http://www.upol.cn
*  Copyright: Copyright (c) 2004
*  @version 1.0
*  費用類型的增加、刪除、修改
*/

package caiwu;
import java.sql.*;

public class PayerControl extends Payer{
    public ResultSet rs;

/*
* 修改費用類型名稱
*/
public void editpayer(){
DBConnect dbc = null;
        try{
                dbc = new DBConnect();
                dbc.prepareStatement("UPDATE payer SET name=? WHERE id=?");
                dbc.setBytes(1,Name.getBytes("GB2312"));
                dbc.setInt(2,Id);
                dbc.executeUpdate();
        }catch(Exception e){
                e.printStackTrace();
        }
        finally{
        try{
                dbc.close();
        }catch(Exception e){
                e.printStackTrace();
                }
        }
}

/*
* 刪除欄目
*/
public void delpayer(){
        DBConnect dbc = null;
        try{
                dbc = new DBConnect();
                dbc.prepareStatement("delete from payer WHERE id=?");
                dbc.setInt(1,Id);
                dbc.executeUpdate();
        }catch(Exception e){
                e.printStackTrace();
        }
        finally{
        try{
                dbc.close();
        }catch(Exception e){
                e.printStackTrace();
                }
        }
}

/*
* 添加新的欄目
*/
public void addpayer(){
DBConnect dbc = null;
        try{
                dbc  = new DBConnect();
                dbc.prepareStatement("INSERT INTO payer ( name ) VALUES ( ? )");
                dbc.setBytes(1,Name.getBytes("GB2312"));
                dbc.executeUpdate();
        }catch(Exception e){
                System.err.println(e);
        }finally{
        try{
                dbc.close();
        }catch(Exception e){
                e.printStackTrace();
                }
        }
}

//結束
    public PayerControl() {
    }
}