我正在创建一个java web应用程序,它应该从数据库中获取数据并显示在网页上,我想提供添加和删除功能来添加和删除数据库中的条目。我已经与mysql数据库建立了连接,并设法将数据加载到对象的数组列表中。invoice类保存数据。我想知道如何使用此arraylist填充html表。我可以做些什么来添加功能。
public class invoice {
private String customer_name;
private String Customer_no;
private String invoiceId;
private double invoice_amt;
private String due_date;
private String predicted_dt;
private String notes;
public String getCustomer_name() {
return customer_name;
}
public void setCustomer_name(String customer_name) {
this.customer_name = customer_name;
}
public String getCustomer_no() {
return Customer_no;
}
public void setCustomer_no(String customer_no) {
Customer_no = customer_no;
}
public String getInvoiceId() {
return invoiceId;
}
public void setInvoiceId(String invoiceId) {
this.invoiceId = invoiceId;
}
public double getInvoice_amt() {
return invoice_amt;
}
public void setInvoice_amt(double invoice_amt) {
this.invoice_amt = invoice_amt;
}
public String getDue_date() {
return due_date;
}
public void setDue_date(String due_date) {
this.due_date = due_date;
}
public String getPredicted_dt() {
return predicted_dt;
}
public void setPredicted_dt(String predicted_dt) {
this.predicted_dt = predicted_dt;
}
public String getNotes() {
return notes;
}
public void setNotes(String notes) {
this.notes = notes;
}
}
这是我的数据对象。它应该是表中的一行。
import java.sql.*;
import java.util.ArrayList;
public class GetData extends invoice {
public static void main(String args[]){
try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con=DriverManager.getConnection(
"jdbc:mysql://localhost:3307/maindata","root","root");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select name_customer, cust_number,invoice_id,due_in_date,pred_clear_date from mytable");
ArrayList<invoice> a = new ArrayList<invoice>();
while(rs.next())
{
invoice temp = new invoice();
temp.setCustomer_name(rs.getString(1));
temp.setCustomer_no(rs.getString(2));
temp.setInvoiceId(rs.getString(3));
temp.setDue_date(rs.getString(4));
temp.setPredicted_dt(rs.getString(5));
temp.setNotes(null);
a.add(temp);
}
con.close();
}catch(Exception e){ System.out.println(e);}
}
}
此类正在将数据获取到数组列表中。
暂无答案!
目前还没有任何答案,快来回答吧!