代码解惑!求解……
button_today.addMouseListener(new MouseAdapter() {
public void mouseClicked(MouseEvent e1) {
// if (e1.getClickCount() == 1) {
jta.setEditable(false);
String st = null;
String strText = null;
j = Integer.parseInt(jta.getName());
k = j - (day_week - 1);
if (k == 1 || k == 2 || k == 3 || k == 4 || k == 5
|| k == 6 || k == 7 || k == 8 || k == 9) {
st = str + "-" + "0" + k;
// strText取得的是点击保存后,不管是修改过还是未修改过的文本
strText = jta.getText().substring(1);
} else {
st = str + "-" + k;
strText = jta.getText().substring(2);
}
System.out.println("保存或修改过的数据: " + strText);
java.util.Calendar calendar = java.util.Calendar
.getInstance();
calendar.setTime(new Date());
int m = calendar.get(Calendar.MONTH) + 1;
int d = calendar.get(Calendar.DATE);
int h = calendar.get(Calendar.HOUR_OF_DAY);
int mi = calendar.get(Calendar.MINUTE);
int s = calendar.get(Calendar.SECOND);
String sy = String.valueOf(calendar
.get(Calendar.YEAR));
String sm = m < 10 ? "0" + m : String.valueOf(m);
String sd = d < 10 ? "0" + d : String.valueOf(d);
String sh = h < 10 ? "0" + h : String.valueOf(h);
String smi = mi < 10 ? "0" + mi : String
.valueOf(mi);
String ss = s < 10 ? "0" + s : String.valueOf(s);
final String se = "EB" + sy + sm + sd + sh + smi
+ ss;
if (strText != null && strA.equals("") == true) {
// 执行insert语句
try {
db// commentdate取的是选择保存的那个日期
.cun("insert into t_day_comment("
+ "id,orgid,orgname,employeeid,employee,status,commentdate,apwork)"
+ " values('"
+ se
+ "','EB200612141166096392000000ORGAAAAAAAAA16','集团公司·信息化管理中心',"
+ "'EB200612141166096392000000000AAAAAAAA902','于耀','0','"
+ st + "','" + strText
+ "')");
db.closs();
} catch (SQLException ew) {
// TODO Auto-generated catch block
ew.printStackTrace();
}
} else if (strA != null
&& strText.equals(strA) == false) {
// 执行update语句
try {
db
.update("update t_day_comment set apwork = '"
+ strText
+ "' where "
+ "employeeid = 'EB200612141166096392000000000AAAAAAAA902' "
+ "and commentdate = '"
+ st + "'");
db.closs();
} catch (SQLException ee) {
// TODO Auto-generated catch block
ee.printStackTrace();
}
}
// }
}
});
上面是我写的程序中一段代码,在这个按钮的监听事件中,不知道为什么,代码就是进不了数据库储存的那个if判断中,老是进的是修改的那个if中。还有就是这段代码会在第一次执行完毕后,再重头又执行一次,有时候2次,有时候三次。。为什么???高手帮忙解惑下啊。。谢谢!!!