添加不进数据库 也不报错
dao层是package com.wf.teaching.dao.impl;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.SessionFactory;
import com.wf.teaching.dao.GradeDao;
import com.wf.teaching.entity.Grade;
public class GradeDaoImpl implements GradeDao {
SessionFactory sessionFactory;
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
public boolean addGrade(Grade grade) {
// TODO Auto-generated method stub
try {
sessionFactory.getCurrentSession().save(grade);
return true;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}
public void deleteGrade(Grade grade) {
// TODO Auto-generated method stub
sessionFactory.getCurrentSession().delete(grade);
}
public List<Grade> getList() {
// TODO Auto-generated method stub
List<Grade> list = sessionFactory.getCurrentSession().createQuery("from Grade").list();
return list;
// return sessionFactory.getCurrentSession().createQuery(
// "from Grade order by school").list();
}
public boolean updateGrade(Grade grade) {
// TODO Auto-generated method stub
try {
sessionFactory.getCurrentSession().update(grade);
return true;
} catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}
public Grade getGrade(int id) {
// TODO Auto-generated method stub
return (Grade) sessionFactory.getCurrentSession().get(Grade.class, id);
}
public List<Grade> getListByKeyWord(String keyword) {
// TODO Auto-generated method stub
String hql = " from Grade";
if (keyword.equals("stuName")) {
hql += "order by stuName";
} else if (keyword.equals("achievement")) {
hql += "order by achievement";
}
return sessionFactory.getCurrentSession().createQuery(hql).list();
}
public List<Grade> getListbyschool(String school) {
// TODO Auto-generated method stub
String hql = "from Grade where school=? order by examDegree";
return sessionFactory.getCurrentSession().createSQLQuery(hql)
.setString(0, school).list();
}
public String getSchoolName(int id) {
// TODO Auto-generated method stub
String hql = "select name from t_childItem where id=:id";
return (String) sessionFactory.getCurrentSession().createSQLQuery(hql)
.setInteger("id", id).uniqueResult();
}
public void deleteGrade(int id) {
// TODO Auto-generated method stub
Grade gradeId = getGrade(id);
sessionFactory.getCurrentSession().delete(gradeId);
}
}
--------------------编程问答--------------------
biz层是
package com.wf.teaching.biz.impl;
import java.util.List;
import com.wf.teaching.biz.GradeBiz;
import com.wf.teaching.dao.GradeDao;
import com.wf.teaching.entity.Grade;
public class GradeBizImpl implements GradeBiz {
GradeDao gradeDao;
public void setGradeDao(GradeDao gradeDao) {
this.gradeDao = gradeDao;
}
public boolean addGrade(Grade grade) {
// TODO Auto-generated method stub
return gradeDao.addGrade(grade);
}
public boolean addGrade(List<Grade> list) {
// TODO Auto-generated method stub
try {
if (list != null) {
for (int i = 0; i < list.size(); i++) {
Grade gd = list.get(i);
gradeDao.addGrade(gd);
}
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
return true;
}
public boolean deleteGrade(int... id) {
// TODO Auto-generated method stub
try {
for (int i = 0; i < id.length; i++) {
if (id[i] != 0) {
Grade gd = getGrade(id[i]);
gradeDao.deleteGrade(gd);
}
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
return true;
}
public Grade getGrade(int id) {
// TODO Auto-generated method stub
Grade grade = gradeDao.getGrade(id);
return grade;
}
public List<Grade> getList() {
// TODO Auto-generated method stub
List<Grade> c_list = gradeDao.getList();
return c_list;
}
public List<Grade> getListByKeyWord(String keyword) {
// TODO Auto-generated method stub
return gradeDao.getListByKeyWord(keyword);
}
public List<Grade> getListbyschool(String school) {
// TODO Auto-generated method stub
return gradeDao.getListbyschool(school);
}
public String getSchoolName(int id) {
// TODO Auto-generated method stub
return gradeDao.getSchoolName(id);
}
public boolean updateGrade(Grade grade) {
// TODO Auto-generated method stub
try {
gradeDao.updateGrade(grade);
return true;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}
}
--------------------编程问答-------------------- action是
package com.wf.teaching.action;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.wf.dictionary.biz.ChildItemBiz;
import com.wf.dictionary.biz.DataTypeBiz;
import com.wf.dictionary.entity.ChildItem;
import com.wf.dictionary.entity.DataType;
import com.wf.teaching.biz.GradeBiz;
import com.wf.teaching.entity.Grade;
public class GradeAction extends ActionSupport {
private GradeBiz gradeBiz;
private DataTypeBiz dataTypeBiz;
private ChildItemBiz childItemBiz;
private Grade grade;
private String del_ids;
private String keyword1;
private int[] b = null;
public GradeAction() {
super();
// TODO Auto-generated constructor stub
}
public void setGradeBiz(GradeBiz gradeBiz) {
this.gradeBiz = gradeBiz;
}
public void setDataTypeBiz(DataTypeBiz dataTypeBiz) {
this.dataTypeBiz = dataTypeBiz;
}
public void setChildItemBiz(ChildItemBiz childItemBiz) {
this.childItemBiz = childItemBiz;
}
public void setGrade(Grade grade) {
this.grade = grade;
}
public String addGrade() throws Exception {
System.out.println(grade.getId()+grade.getStuName()+"........"+"1111111111111111111111111");
if (grade != null) {
gradeBiz.addGrade(grade);
grade = null;
return "getGradesAchi";
}
return "getGrade";
}
public String sortGrade() {
System.out.println(keyword1+".........");
HttpServletRequest request = ServletActionContext.getRequest();
if (keyword1 != null && !keyword1.equals("")) {
List<Grade> list = gradeBiz.getListByKeyWord(keyword1);
request.setAttribute("list", list);
}
return INPUT;
}
public String deleteGrade() throws Exception {
System.out.println(del_ids+".......");
if (del_ids != "") {
String[] a = del_ids.split("-");
b = new int[a.length];
for (int i = 0; i < a.length; i++) {
if (a[i] != null && a[i] != "") {
b[i] = Integer.parseInt(a[i]);
}
}
}
gradeBiz.deleteGrade(b);
return "getGradesAchi";
}
public String getGrades() throws Exception {
System.out.println("getGrades+>>>>>>>>>>>>>>>>>>>>>>>");
List<Grade> list = gradeBiz.getList();
HttpServletRequest request = ServletActionContext.getRequest();
request.setAttribute("list", list);
DataType dt = dataTypeBiz.getDataType("校区");
if (dt != null) {
List<ChildItem> schools_list = childItemBiz.getList(dt.getId());
request.setAttribute("schools_list", schools_list);
System.out.println(schools_list+"....................");
}
dt = dataTypeBiz.getDataType("班级");
if (dt != null) {
List<ChildItem> class_list = childItemBiz.getList(dt.getId());
request.setAttribute("class_list", class_list);
}
dt = dataTypeBiz.getDataType("学科");
if (dt != null) {
List<ChildItem> subject_list = childItemBiz.getList(dt.getId());
request.setAttribute("subject_list", subject_list);
}
return "getGrade";
}
public String search() {
HttpServletRequest request = ServletActionContext.getRequest();
DataType dt = dataTypeBiz.getDataType("校区");
if (dt != null) {
List<ChildItem> schools_list = childItemBiz.getList(dt.getId());
if (request.getSession().getAttribute("schools_list") != null) {
request.getSession().removeAttribute("schools_list");
}
request.getSession().setAttribute("schools_list", schools_list);
System.out.println(schools_list+"....................");
}
return "getGradesAchi";
}
public String updateGrade() throws Exception {
Grade gd = gradeBiz.getGrade(id);
gd.setSchool(school);
gd.setStuName(stuName);
gd.setStuClass(stuClass);
gd.setClazz(clazz);
gd.setSchool_level(school_level);
gd.setSubject(subject);
gd.setExamDegree(examDegree);
gd.setAchievement(achievement);
gd.setExam_time(exam_time);
System.out.println(gd.getId()+"..........");
if(gradeBiz.updateGrade(gd)){
return "getGradesAchi";
}
return "getGrade";
}
public String fromat(String s) throws Exception {
if(s!=null&&!s.equals("")){
s=java.net.URLDecoder.decode(s,"utf-8");
System.out.println("......................"+s);
}
return INPUT;
}
private int id;
private String school;
private String stuName;
private String stuClass;
private String clazz;
private String school_level;
private String subject;
private String examDegree;
private String achievement;
private String exam_time;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getSchool() {
return school;
}
public void setSchool(String school) {
this.school = school;
}
public String getStuName() {
return stuName;
}
public void setStuName(String stuName) {
this.stuName = stuName;
}
public String getStuClass() {
return stuClass;
}
public void setStuClass(String stuClass) {
this.stuClass = stuClass;
}
public String getClazz() {
return clazz;
}
public void setClazz(String clazz) {
this.clazz = clazz;
}
public String getSchool_level() {
return school_level;
}
public void setSchool_level(String schoolLevel) {
school_level = schoolLevel;
}
public String getSubject() {
return subject;
}
public void setSubject(String subject) {
this.subject = subject;
}
public String getExamDegree() {
return examDegree;
}
public void setExamDegree(String examDegree) {
this.examDegree = examDegree;
}
public String getAchievement() {
return achievement;
}
public void setAchievement(String achievement) {
this.achievement = achievement;
}
public String getExam_time() {
return exam_time;
}
public void setExam_time(String examTime) {
exam_time = examTime;
}
}
j --------------------编程问答-------------------- sp页面是
<script type="text/javascript" language="javascript">
function add_grade(){
var stuName=document.getElementById("stuName").value;
var stuClass=document.getElementById("stuClass").value;
var achievement=document.getElementById("achievement").value;
var exam_time=document.getElementById("exam_time").value;
if(stuName.length==0){
alert("学生姓名不能为空");
return;
}else if(stuClass.length==0){
alert("年级不能为空");
return;
}else if(achievement.length==0){
alert("成绩不能为空");
return;
}else if(exam_time.length==0){
alert("时间不能为空");
return;
}else{
document.form1.action="<%=basePath%>addGrade";
document.form1.submit();
}}
<table border="0" cellpadding="0" cellspacing="0"
style="width: 100%;">
<tr>
<td align="left" style="width: 500px">
<input type="button" name="btnAll" value="全选" id="btnAll"
class="btnBase" />
<input type="button" name="btnOver" value="反选" id="btnOver"
class="btnBase" />
<input type="button" name="btnDel" value="删除所选" id="btnDel"
class="btnBase" />
<input type="button" name="btnAdd" value="添加" id="btnAdd"
class="btnBase" onclick="showDiv('addRaftCourse')" />
<input type="button" name="btnBatchAdd" value="批量添加"
id="btnBatchAdd" class="btnBase" onclick="showDiv('pnlAdd');" />
</td>
<td style="text-align: center">
<input type="button" name="btnSort" value="排序" id="btnSort"
class="btnBase" onclick="showDiv('pnlSort');" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<div>
<form name="form1" method="post" action="<%=basePath%>addGrade"
>
<table class="gvMain" cellspacing="0" rules="all" border="1"
id="sgvFile">
<tr class="gvHeaderWrap">
<th>
</th>
<th>
编号
</th>
<th scope="col">
校区
</th>
<th scope="col">
姓名
</th>
<th scope="col">
年级
</th>
<th scope="col">
班级
</th>
<th scope="col">
学校层次
</th>
<th scope="col">
学科
</th>
<th scope="col">
考试次数
</th>
<th scope="col">
成绩
</th>
<th scope="col">
时间
</th>
<th scope="col">
操作
</th>
</tr>
<tr id="addRaftCourse" class="gvRow" align="center"
style="display: none">
<td>
<span><input id="addinfo" type="checkbox"
name="addinfo" value="" onchange="hideTr()" /> </span>
</td>
<td></td>
<td>
<select name="school" class="text2">
<c:forEach var="gs" items="${schools_list}">
<option value="${gs.name}">
${gs.name }
</option>
</c:forEach>
</select>
</td>
<td>
<input type="text" name="grade.stuName" id="stuName"
class="text1">
</td>
<td>
<input type="text" name="grade.stuClass" id="stuClass"
class="text1" />
</td>
<td>
<select name="grade.clazz" class="text2">
<c:forEach var="gs" items="${class_list}">
<option value="${gs.name }">
${gs.name }
</option>
</c:forEach>
</select>
</td>
<td>
<select name="grade.school_level" class="text2">
<option value="小学">
小学
</option>
<option value="中学">
中学
</option>
<option value="高中">
高中
</option>
</select>
</td>
<td>
<select name="grade.subject" class="text2">
<c:forEach var="gs" items="${subject_list}">
<option value="${gs.name }">
${gs.name }
</option>
</c:forEach>
</select>
</td>
<td>
<select name="grade.examDegree" class="text2">
<option value="第一次考试">
第一次考试
</option>
<option value="第二次考试">
第二次考试
</option>
<option value="第三次考试">
第三次考试
</option>
<option value="第四次考试">
第四次考试
</option>
<option value="第五次考试">
第五次考试
</option>
</select>
</td>
<td>
<input type="text" name="grade.achievement" id="achievement"
class="text1">
</td>
<td>
<input type="text" name="grade.exam_time" id="exam_time"
class="text1">
</td>
<td>
<input type="button" name="btnConfirm" value="确定"
onclick="add_grade();">
</td>
</tr>
<c:forEach var="sa" items="${list}" varStatus="state">
<tr align="center"
<c:if test="${state.count%2==0}"> class="gvAlternatingRow" </c:if>
<c:if test="${state.count%2!=0}"> class="gvRow" </c:if>>
<td>
<span><input id="sgvFile_ctl02_chkDel"
type="checkbox" name="sgvFile$ctl02$chkDel"
value="${sa.id}" /> </span>
</td>
<td>
${state.count }
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.school }" id="${sa.id}school">
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.stuName }"
id="${sa.id}stuName">
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.stuClass }"
id="${sa.id}stuClass">
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.clazz }" id="${sa.id}clazz">
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.school_level}"
id="${sa.id}clazz">
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.subject}" id="${sa.id}clazz">
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.examDegree }"
id="${sa.id}clazz">
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.achievement }"
id="${sa.id}clazz">
</td>
<td>
<input type="text" size="6" ${state.count%2==0 ?"class='o2'
": "class='o1' "} value="${sa.exam_time }"
id="${sa.id}clazz">
</td>
<td>
<a id="btnEdit" href="javascript:update(${sa.id});">[修改]</a>
</td>
</tr>
</c:forEach>
</table>
</form>
</div>
</td>
</tr>
</table>
</div>
</body>
</html>
补充：Java , Java相关
