Tuesday, 26 February 2013

how to store database record into java object


//this BChequeDiscount is Bean which used for setting value and getting the value
import java.util.*;
import java.sql.*;
import java.io.*;


public class BChequeDiscount
{
    public int Id;
    public String FName;
    public String LName;

    public void setId(int Id)
    {
        this.Id=Id;
    }
    public void setFName(String FName)
    {
            this.FName=FName;
    }
    public void setLName(String LName)
    {
        this.LName=LName;
    }

    public int getId()
    {
        return Id;
    }
    public String getFName()
    {
            return FName;
    }
    public String getLName()
    {
        return LName;
    }

}

/*This class is used the above bean for storing data into the object which is retrive from database and add into the arraylist */

import java.util.*;
import java.sql.*;
import java.io.*;

public class BChequeDiscountDemo
{

    Connection connection;
    String sql="";
    Statement stmt;
    ResultSet rs,rsn;


    public  List<BChequeDiscount> ReadFDB()throws Exception
    {
        try
        {
                      Class.forName("com.mysql.jdbc.Driver").newInstance();
                      connection = DriverManager.getConnection("jdbc:mysql://localhost/univercity","root","");
                      stmt=connection.createStatement();

        }
        catch(SQLException sa)
        {
                        System.out.println("Error loading driver:" + sa.getMessage());
        }

        List<BChequeDiscount> al=new ArrayList<BChequeDiscount>();
        sql="Select *From lecture";
        rs=stmt.executeQuery(sql);
        while(rs.next())
        {
            BChequeDiscount bcd=new BChequeDiscount();

            bcd.setId(rs.getInt("id"));
            bcd.setFName(rs.getString("FName"));
            bcd.setLName(rs.getString("LName"));

            al.add(bcd);
        }
        return al;
    }
    public void ReadList(List<BChequeDiscount> bcd)
    {
        BChequeDiscount rbcd=null;
        Iterator<BChequeDiscount> ite=bcd.iterator();
        while(ite.hasNext())
        {
                     rbcd=ite.next();

                    System.out.println("the id is"+rbcd.getFName());
                    System.out.println("the id is"+rbcd.getId());
                    System.out.println("the id is"+rbcd.getLName());

        }


    }



    public static void main(String args[])throws Exception
    {
        BChequeDiscountDemo bcdd=new BChequeDiscountDemo();
        //This following method read data from database and return arraylist object.
        List<BChequeDiscount> bcd=bcdd.ReadFDB();
        //this following method is read from arraylist object
        bcdd.ReadList(bcd);
    }
}

No comments:

Post a Comment