1.数据库中表的字段与要给用户展示的字段不一致问题
这个问题可以交给前端页面,在前端页面显示的时候处理,比在其它地方做处理要轻松。
public class Person{
private Integer id;
private String name;
private Integer gender;
private Integer age;
private Integer rank;
private String department;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getGender() {
return gender;
}
public void setGender(Integer gender) {
this.gender = gender;
}
public Integer getAge() {
return age;
}
public Integer getRank() {
return rank;
}
}
可以看到我的实体类和表中字段的类型一致
<table border="1px solid #ccc" cellpadding="0" cellpadding="0" style="margin: 0 auto; border-top: 200px;">
<thead>
<tr>人员列表</tr>
<tr>
<th>编号</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>等级</th>
<th>部门</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<c:forEach var="person" items = "${info}">
<tr>
<td>${person.getId()}</td>
<td>${person.getName()}</td>
<td><c:if test="${person.getGender()==0}">女</c:if><c:if test="${person.getGender()!=0}">男</c:if></td>
<td>${person.getAge()}</td>
<td>${person.getRank()}级</td>
<td>${person.getDepartment()}</td>
<td><a href="#">删除</a></td>
</tr>
</c:forEach>
</tbody>
</table>
<tr><button style="margin-left: 600px; color: forestgreen" onclick="toAdd()">添加人员</button></tr>
前端页面我对数据做了处理,保证了用户效果,这样付出的代价也低。
2.表单提交失效
用button标签提交正常。用input中的 type=“button” 提交如果不加 document.form.submit(); 失效
<button style="color: forestgreen" onclick="toAdd()">添加人员</button>
<script src="../../lib/jquery-3.6.0.min.js"></script>
<script type="text/javascript">
$("table tbody tr:odd").css("background","pink");
$("table tbody tr:even").css("background","forestgreen");
function toAdd() {
location.href="${pageContext.request.contextPath}/person/add.do";
}
</script>
<p><input type="button" value="提交" onclick="toCheck()"></p>
<script src="../../lib/jquery-3.6.0.min.js"></script>
<script>
function toCheck(){
var name = $('#p').val();
if(name.length==0){
confirm("用户名不能为空");
return false;
}
document.form.submit();//加了之后提交成功,获取id=form的表单并提交
// return true;
}
$("form p :odd").css("background","pink");
$("form p :even").css("background","forestgreen");
</script>