通过JAVA语句向数据库中插入一行记录
INSERT INTO person(pid,name,age,birthday,address)VALUES(1,'张三',30,'1987-11-15','北京');
需要判断每个pid,name,age,birthday,address都不为空是才能执行插入操作
如果不用多个if嵌套,只用一个if如何判断?
INSERT INTO person(pid,name,age,birthday,address)VALUES(1,'张三',30,'1987-11-15','北京');
需要判断每个pid,name,age,birthday,address都不为空是才能执行插入操作
如果不用多个if嵌套,只用一个if如何判断?
//有个参数为空的处理
}
楼主要做什么呢??单独判断不好么?你不用框架么??
String pid = jtextfield1.getText().trim();
String name = jtextfield2.getText().trim();
String age = jtextfield3.getText().trim();
String birthday = jtextfield4.getText().trim();
String address = jtextfield5.getText().trim();
if (!pid.equals("")) {
if (!name.equals("")) {
if (!age.equals("")) {
if (!birthday.equals("")) {
if (!address.equals("")) {
if (pid.matches("\\d++")) {
if (age.matches("\\d++")) {
if (birthday
.matches("\\d{4}-\\d{2}-\\d{2}")) {
int i1 = Integer.parseInt(birthday
.substring(0, 4));
int i2 = Integer.parseInt(birthday
.substring(5, 7));
int i3 = Integer.parseInt(birthday
.substring(8, 10));
if (i1 <= 2100 && i2 <= 12 && i3 <= 31) {
sql = "INSERT INTO person(pid,name,age,birthday,address) VALUES ("
+ pid
+ ",'"
+ name
+ "',"
+ age
+ ",TO_DATE('"
+ birthday
+ "','yyyy-mm-dd'),'" + address + "')";
System.out.println(sql);
} else {
JOptionPane
.showMessageDialog(jframe,
"日期格式错误哦..(格式:yyyy-MM-dd)");
}
}
} else {
JOptionPane.showMessageDialog(jframe,
"年龄为数字哦..");
}
} else {
JOptionPane.showMessageDialog(jframe,
"PID为数字哦..");
}
} else {
JOptionPane.showMessageDialog(jframe, "地址不能为空哦..");
}
} else {
JOptionPane.showMessageDialog(jframe, "出生日期不能为空哦..");
}
} else {
JOptionPane.showMessageDialog(jframe, "年龄不能为空哦..");
}
} else {
JOptionPane.showMessageDialog(jframe, "姓名不能为空哦..");
}
} else {
JOptionPane.showMessageDialog(jframe, "编号不能为空哦..");
}
return sql;
}
save()
}
sql = "INSERT INTO person(pid,name,age,birthday,address) VALUES ("
+ pid
+ ",'"
+ name
+ "',"
+ age
+ ",TO_DATE('"
+ birthday
+ "','yyyy-mm-dd'),'" + address + "')";}