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);
}
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment