public static void showTable() {
Vector<String> rowHeader = new Vector<String>();
rowHeader.add("serviceID");
rowHeader.add("serviceName");
rowHeader.add("serviceAmount");
DefaultTableModel model = new DefaultTableModel(rowHeader, 0);
table.setModel(model);
ConnectData ds = new ConnectData();
ds.connect();
String newSQL = "SELECT * FROM Service";
try {
ResultSet rs = ds.ExcuteQuery(newSQL);
Vector<String> rowData;
if (rs != null)
while (rs.next()) {
rowData = new Vector<String>();
rowData.add(rs.getString("serviceID"));
rowData.add(rs.getString("serviceName"));
rowData.add(rs.getString("serviceAmount"));
model.addRow(rowData);
}
rs.close();
ds.dispose();
} catch (Exception ex) {
System.out.println("Error : " + ex);
}
}
public boolean updateRecord() {
ConnectData ds = new ConnectData();
ds.connect();
int id = Integer.parseInt(txt_ID.getText());
String name = txt_Name.getText();
String amount = txt_Amount.getText();
String sql_insert =
"Update Service Set serviceID="
+ id
+ ",serviceName='"
+ name
+ "',serviceAmount='"
+ amount
+ "' where serviceID="
+ id;
if (ds.queryExcuteUpdate(sql_insert)) {
JOptionPane.showMessageDialog(null, "Successfull");
showTable();
} else JOptionPane.showMessageDialog(null, "fail");
try {
ds.dispose();
return true;
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
return false;
}
public int addReservationDetail() {
int reID = -1;
String sql = "INSERT into ReservationDetail values(null, " + resID + ", " + roomID + ")";
conn = new ConnectData();
conn.connect();
reID = conn.queryExcuteUpdateGenerateKey(sql);
return reID;
}
public boolean deleteRecord() {
ConnectData ds = new ConnectData();
ds.connect();
String ID = txt_ID.getText();
String sql_insert = "delete from Service where serviceID='" + ID + "'";
if (ds.queryExcuteUpdate(sql_insert)) {
JOptionPane.showMessageDialog(null, "delete Successfull");
showTable();
} else JOptionPane.showMessageDialog(null, "delete fail");
try {
ds.dispose();
return true;
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
return false;
}
public boolean addRecord() {
// TODO Auto-generated method stub
ConnectData ds = new ConnectData();
ds.connect();
// int id= Integer.parseInt(txt_ID.getText());
String name = txt_Name.getText();
String amount = txt_Amount.getText();
String sql_insert = "insert into Service values(" + null + ",'" + name + "','" + amount + "')";
if (ds.queryExcuteUpdate(sql_insert)) {
JOptionPane.showMessageDialog(null, "Successfull");
showTable();
} else JOptionPane.showMessageDialog(null, "fail");
try {
ds.dispose();
return true;
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
return false;
}