Add Serial No In output

[saran87]

Hi,this is my query..i want serial no..so what i write in the query for getting sl no
query = "SELECT Invoiceno, InvoiceDate, TotalAmount FROM tblInvoice WHERE InvoiceDate BETWEEN ? AND ? ";

statement2 = connection2.prepareStatement(query);

statement2.setString(1 , fromDates);

statement2.setString(2 , toDates);

resultset = statement2.executeQuery();

while(resultset.next())


invoiceList1.add(resultset.getString(1));
invoiceDateList1.add(resultset.getString(2));
invoiceAmtList1.add(resultset.getString(3));
Thanks In Advance.........

[travishein]

not sure what you mean by serial number ?

for jdbc, why not read each row into an array of beans, instead of arrays of individual properties ?

for example, create an InvoiceItem bean

public class InvoiceItem {
	String invoiceNumber;
	String invoiceDate;  // TODO: maybe use a Date ?
	String totalAmount;  // TODO: maybe use a Double? 
	
	public void setInvoiceNumber(String invoiceNumber) { this.invoiceNumber = invoiceNumber; }
	public String getInvoiceNumber() { return this.getInvoiceNumber; }
	
	public void setInvoiceDate(String invoiceDate) { this.invoiceDate = invoiceDate; }
	public String getInvoiceDate() { return this.getInvoiceDate; }

	public void setInvoiceAmount(String invoiceAmount) { this.invoiceAmount = invoiceAmount; }
	public String getInvoiceAmount() { return this.getInvoiceAmount; }
	
}

and then this method becomes

public List<InvoiceItem> getInvoiceItems(Connection con, String fromDate, String toDate) throws SQLException {
	List<InvoiceItem> results = new ArrayList<InvoiceItem>
	PreparedStatement stmt = null;
	ResultSet resultSet = null;
	try {
		String query = "SELECT Invoiceno, InvoiceDate, TotalAmount FROM tblInvoice WHERE InvoiceDate BETWEEN ? AND ? ";
		
		stmt = con.prepareStatement(query);
		stmt.setString(1, fromDate);
		stmt.setString(2, toDate);

		resultset = stmt.executeQuery();

		while(resultset.next()) {
			InvoiceItem item = new InvoiceItem();
			item.setInvoiceNumber(resultSet.getString("Invoiceno"));
			item.setInvoiceDate(resultSet.getString("InvoiceDate"));
			item.setTotalAmount(resultSet.getString("TotalAmount"));
		
			items.add(item);
		}
	}
	finally {
		if (resultSet != null) {
			try {
				resultSet.close();
			} catch (SQLException ex) { }
		}
		if (stmt != null) {
			try {
				stmt.close();
			} catch (SQLException ex) { }
		}
	}
       return items;
}

[raqman]

Hi.
As I know, RAQ Report can help users to add serial number automatically.
Maybe you can have a try.
Regards,
raqman.