java怎样将table里面的数据保存到数据库_java – 如何将已编辑的JTable数据保存到数据库？...

首先抱歉我的英语不好.我会尽力了解你的问题.

我想要的只是在点击“保存”按钮时保存用户在JTable中输入的新数据.

我正在从数据库的前两列中检索学生ID,名称,并且我在第三列中添加了当前日期,并且Absent / Present作为可编辑的第四列.我有以下代码从数据库中检索数据.

**Attendance.java** :

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

package shreesai;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.text.SimpleDateFormat;

import java.util.Vector;

/**

*

* @author Admin

*/

public class Attendance{

Connection con = Connectdatabase.ConnecrDb();

java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());

SimpleDateFormat fromUser = new SimpleDateFormat("dd/MM/yyyy");

String d1 = fromUser.format(sqlDate);

String d = d1.toString();

public Vector getEmployee()throws Exception

{

Vector> employeeVector = new Vector>();

PreparedStatement pre = con.prepareStatement("select studentid,name from student");

ResultSet rs = pre.executeQuery();

while(rs.next())

{

Vector employee = new Vector();

employee.add(rs.getString(1)); //Empid

employee.add(rs.getString(2));//name

employee.add(d);

employeeVector.add(employee);

}

if(con!=null)

con.close();

rs.close();

pre.close();

return employeeVector;

}

}

**出勤率GUI.java：**

/*

* To change this template, choose Tools | Templates

* and open the template in the