<table width="100%" class="cont tr_color">
<tr>
<th>学生学号th>
<th>学生姓名th>
<th>专业th>
<th>实习职位th>
<th>实习考核分数th>
<th>实习单位th>
<th>实习地点th>
<th>操作th>
tr>
<c:forEach items="${interns}" var="i">
<tr align="center" class="d">
<td><a href="intern.let?type=details&id=${i.id}">${i.id}a>td>
<td>${i.name}td>
<td>${i.major}td>
<td>${i.job}td>
<td>${i.score}td>
<td>${i.company}td>
<td>${i.address}td>
<td>
<a onclick="return confirm('确认修改');" href="intern.let?type=modifypre&id=${i.id}">修改a>
<a onclick="return confirm('确认删除');" href="intern.let?type=remove&id=${i.id}">删除a>
td>
tr>
c:forEach>
table>
td>
tr>
table>
td>
<td width="2%"> td>
tr>
添加jsp的主代码
<tr>
<td width="2%"> td>
<td width="96%">
<table width="100%">
<tr>
<td colspan="2">
<form action="intern.let?type=add" method="post">
<table width="40%" class="cont">
<tr>
<td width="2%"> td>
<td width="25%">学生学号：td>
<td width="40%"><input type="text" id="id" class="text" name="id" />td>
<td class="err">*学号已存在td>
<td width="2%"> td>
tr>
<tr>
<td width="2%"> td>
<td width="25%">学生姓名：td>
<td width="40%"><input type="text" id="name" class="text" name="name" />td>
<td class="err">*已存在td>
<td width="2%"> td>
tr>
<tr>
<td width="2%"> td>
<td width="25%">专业：td>
<td width="40%"><input type="text" id="major" class="text" name="major" />td>
<td class="err">*已存在td>
<td width="2%"> td>
tr>
<tr>
<td width="2%"> td>
<td width="25%">专业安排：td>
<td width="40%"><input type="text" id="desc" class="text" name="desc" />td>
<td class="err">*已存在td>
<td width="2%"> td>
tr>
<tr>
<td width="2%"> td>
<td width="25%">实习岗位：td>
<td width="40%"><input type="text" id="job" class="text" name="job" />td>
<td class="err">*已存在td>
<td width="2%"> td>
tr>
<tr>
<td width="2%"> td>
<td width="25%">实习考核分数：td>
<td width="40%"><input type="text" id="score" class="text" name="score" />td>
<td class="err">*已存在td>
<td width="2%"> td>
tr>
<tr>
<td width="2%"> td>
<td width="25%">实习单位：td>
<td width="40%"><input type="text" id="company" class="text" name="company" />td>
<td class="err">*已存在td>
<td width="2%"> td>
tr>
<tr>
<td width="2%"> td>
<td width="25%">实习地点：td>
<td width="40%"><input type="text" id="address" class="text" name="address" />td>
<td class="err">*已存在td>
<td width="2%"> td>
tr>
<tr>
<td> td>
<td colspan="3"><input class="btn" type="submit" value="提交" />td>
<td> td>
tr>
table>
form>
td>
tr>
table>
td>
<td width="2%"> td>
tr>
servlet主代码
private void add(HttpServletRequest req, HttpServletResponse resp,PrintWriter out, ServletContext application) {
//1.从表单中获取
long id=Long.parseLong(req.getParameter("id"));
String name = req.getParameter("name");
String major = req.getParameter("major");
String desc = req.getParameter("desc");
String job = req.getParameter("job");
double score=Double.parseDouble(req.getParameter("score"));
String company = req.getParameter("company");
String address = req.getParameter("address");
//2.调用biz的添加方法
int count = internBiz.add(id,name,major,desc,job,score,company,address);
//3.更新application中types
if(count>0){
List interns = internBiz.getAll();
//List types = typeBiz.getAll();
application.setAttribute("interns",interns);
out.println("");
}else{
out.println("");
}
//4.提示结果
}
add方法
public int add(long id, String name, String major, String desc, String job,
double score, String company, String address) {
int count=0;
try {
count=internDao.add(id,name,major,desc,job,score,company,address);
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return count;
}
getall方法
public List getAll(){
try {
return internDao.getAll();
} catch (SQLException throwables) {
throwables.printStackTrace();
return null;
}
}
运行结果及报错内容
1.第一个错
2.第二个错
我想要达到的结果
想能正常运行出结果
|
