anggota.java

this is a java source code file.. download and enjoy of it...

/*
 * Buku.java
 *
 * Created on April 12, 2007, 1:25 AM
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package inc;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author mamat-dev
 */
public class Anggota {

   private String query;
    
    /** Creates a new instance of Buku */
    public Anggota() {
    }
    
    public boolean insertAnggota(String member_name, String member_address, String member_status) {
        boolean status = false;
        MsAcces anggota = new MsAcces();
        try {
            anggota.getConnection();
            Statement st = anggota.getStatement();
            st.executeUpdate("insert into member (member_name,member_address,member_status_id) values('"+member_name+"','"+member_address+"',"+member_status+")");
            anggota.closeStatement();
            anggota.closeConnection();            
            status = true;
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return status;
    }
    
    public boolean deleteAnggota(String member_id){
        boolean status = false;
        MsAcces anggota = new MsAcces();
        try {
            anggota.getConnection();
            Statement st = anggota.getStatement();
            st.executeUpdate("delete from member where member_id = "+member_id+"");
            anggota.closeStatement();
            anggota.closeConnection();
            status = true;
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
        return status;
    }
    
    public boolean updateAnggota(String member_id, String member_name, String member_address,
            String member_status_id){
        boolean status = false;
        MsAcces anggota = new MsAcces();
        try {
            anggota.getConnection();
            Statement st = anggota.getStatement();
            st.executeUpdate("update member set member_name = '"+member_name
                    +"', member_address='"+member_address+"', member_status_id="+
                    member_status_id+" where member_id ="+member_id);
            anggota.closeStatement();
            anggota.closeConnection();
            status = true;
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
        return status;
    }
    
    public ResultSet selectAnggota(String query){
        ResultSet rs = null;
        MsAcces anggota = new MsAcces();
        
        try {
            anggota.getConnection();
            Statement st = anggota.getStatement();
            rs = st.executeQuery(query);
            
            return rs;
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return rs;
    }
    
    public int getRow(String query){
        MsAcces anggota = new MsAcces();
        int row = 0;
        
        try {
            anggota.getConnection();
            Statement st = anggota.getStatement();
            ResultSet rs = st.executeQuery(query);         
            
            while(rs.next()){
                row++;
            }
            return row;
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return row;
    }
    
    public String getStatus(String statusId){
        String status =null;
        MsAcces anggota = new MsAcces();
        try {
            anggota.getConnection();
            Statement st = anggota.getStatement();
            ResultSet rs = st.executeQuery("select member_description from member_status where member_status_id = "+statusId);
            while(rs.next()){
                return rs.getString(1);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
        return status;
    }
    
    public void updateStatusAnggota(String memberId, String statusId){
        MsAcces anggota = new MsAcces();
        try {
            anggota.getConnection();
            Statement st = anggota.getStatement();
            st.executeUpdate("update member set member_status_id ="+statusId+" where member_id="+memberId);
            anggota.closeStatement();
            anggota.closeConnection();
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
    }
}