package com.stuman.dao.imp;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import com.stuman.dao.EnrolDAO;
import com.stuman.dao.hibernate.HibernateUtil;
import com.stuman.domain.Classes;
import com.stuman.domain.Enrol;
import com.stuman.domain.EnrolId;
import com.stuman.domain.Score;
import com.stuman.domain.Student;
public class EnrolDAOImp implements EnrolDAO {
private static Log log = LogFactory.getLog(EnrolDAOImp.class);
public List getEnrol() {
// TODO Auto-generated method enrob
try {
Session s = HibernateUtil.currentSession();
HibernateUtil.beginTransaction();
List results = s.createQuery("from Enrol enro").list();
HibernateUtil.commitTransaction();
HibernateUtil.closeSession();
if (results != null && results.size() > 0) {
return results;
}
} catch (HibernateException e) {
log.fatal(e);
}
return null;
}
public boolean deleteEnrolByID(EnrolId id) {
// TODO Auto-generated method enrob
try {
Session s = HibernateUtil.currentSession();
HibernateUtil.beginTransaction();
String classes_id = ((Classes) id.getClasses()).getId();
String stu_id = ((Student) id.getStudent()).getId();
// System.out.println("in deleteEnrolByID " + classes_id + " "
// + stu_id);
s.createQuery("delete com.stuman.domain.Enrol where class_id = '"
+ classes_id
+ "' and stu_id = '"
+ stu_id
+ "'");
HibernateUtil.commitTransaction();
HibernateUtil.closeSession();
return true;
} catch (HibernateException e) {
log.fatal(e);
}
return false;
}
public Enrol getEnrolByID(EnrolId id) {
// TODO Auto-generated method enrob
try {
Session s = HibernateUtil.currentSession();
HibernateUtil.beginTransaction();
// Enrol enro = (Enrol) s.load(Enrol.class, id);
String classes_id = ((Classes) id.getClasses()).getId();
String stu_id = ((Student) id.getStudent()).getId();
System.out.println("in deleteEnrolByID " + classes_id + " "
+ stu_id);
Enrol enro = (Enrol)s.createQuery("from Enrol where class_id = '"
+ classes_id
+ "' and stu_id = '"
+ stu_id
+ "'").list().get(0);
HibernateUtil.commitTransaction();
HibernateUtil.closeSession();
return enro;
} catch (HibernateException e) {
log.fatal(e);
}
return null;
}
public boolean updateEnrol(Enrol enro) {
// TODO Auto-generated method enrob
try {
Session s = HibernateUtil.currentSession();
HibernateUtil.beginTransaction();
s.update(enro);
// System.out.println("update Enrol id =" + enro.getId());
HibernateUtil.commitTransaction();
HibernateUtil.closeSession();
return true;
} catch (HibernateException e) {
log.fatal(e);
}
return false;
}
public boolean saveEnrol(Enrol enro) {
// TODO Auto-generated method enrob
try {
Session s = HibernateUtil.currentSession();
HibernateUtil.beginTransaction();
// Enrol oldEenro = (Enrol) s.load(Enrol.class, id);
s.saveOrUpdate(enro);
// System.out.println("save Enrol id =" + enrob.getId());
HibernateUtil.commitTransaction();
HibernateUtil.closeSession();
return true;
} catch (HibernateException e) {
log.fatal(e);
}
return false;
}
public boolean addEnrol(String stuid, String classid) throws SQLException {
// TODO Auto-generated method stub
try {
// 获得Session
Session s = HibernateUtil.currentSession();
// 执行操作
Connection conn = s.connection();
Statement sql = conn.createStatement();
System.out.println("insert into enrol ( class_id, stu_id) values('"+classid+"','"+stuid+"')");
sql.execute("insert into enrol ( class_id, stu_id) values('"+classid+"','"+stuid+"')");
sql.close();
// 关闭Session
HibernateUtil.closeSession();
return true;
} catch (HibernateException e) {
log.fatal(e);
}
return false;
}
public List getByStuId(String stuid) throws SQLException {
// TODO Auto-generated method stub
ArrayList results = new ArrayList();
try {
// 获得Session
Session s = HibernateUtil.currentSession();
// 执行操作
Connection conn = s.connection();
Statement sql = conn.createStatement();
ResultSet rs = sql.executeQuery("select name, mark, score from enrol,classes,course where stu_id = '"+stuid+"' and class_id = classes.id and course.id = classes.cour_id");
while (rs.next()) {
Score score = new Score();
score.setCourse(rs.getString(1));
score.setMark(rs.getString(2));
score.setScore(rs.getString(3));
results.add(score);
}
rs.close();
sql.close();
// 关闭Session
HibernateUtil.closeSession();
if (results != null && results.size() > 0) {
return results;
}
} catch (HibernateException e) {
log.fatal(e);
}
return null;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
资源推荐
收起资源包目录
网上书店开发源代码 (288个子文件)
EnrolDAOImp.class 5KB
CourseDAOImp.class 5KB
LoginAction.class 4KB
ListStudent.class 4KB
ListCourseForStu.class 4KB
ListClasses.class 4KB
ListCourse.class 3KB
TeacherDAOImp.class 3KB
StudentDAOImp.class 3KB
AdminDAOImp.class 3KB
ListTeacher.class 3KB
ClassesDAOImp.class 3KB
ListScore.class 3KB
Student.class 3KB
StudentForm.class 3KB
HibernateUtil.class 3KB
ClassesForm.class 3KB
CourseForm.class 2KB
AddClasses.class 2KB
AddStudent.class 2KB
EditClasses.class 2KB
AddTeacher.class 2KB
EditStudent.class 2KB
EditCourse.class 2KB
TeacherForm.class 2KB
EditStudent2.class 2KB
EditTeacher.class 2KB
ListCourseIdAndName.class 2KB
SetEncodingFilter.class 2KB
Classes.class 2KB
AddCourse.class 2KB
SetCharacterEncodingFilter.class 2KB
Course.class 2KB
DAOFactory.class 2KB
CourseForStu.class 2KB
CloseSessionFilter.class 2KB
RegCourse.class 2KB
Enrol.class 2KB
DeleteStudent.class 2KB
DeleteClasses.class 2KB
DeleteTeacher.class 2KB
DeleteCourse.class 2KB
Teacher.class 2KB
LoginForm.class 1KB
EnrolId.class 1KB
DAOConfig.class 1KB
HibernateDAOFactory.class 1KB
Admin.class 1KB
Score.class 899B
EnrolDAO.class 545B
CourseDAO.class 470B
ClassesDAO.class 364B
TeacherDAO.class 364B
StudentDAO.class 364B
AdminDAO.class 346B
DAOFactory.class 293B
.classpath 5KB
stylesheet.css 18KB
Thumbs.db 90KB
Thumbs.db 26KB
Entries 1KB
Entries 856B
Entries 767B
Entries 750B
Entries 701B
Entries 438B
Entries 414B
Entries 414B
Entries 404B
Entries 404B
Entries 360B
Entries 247B
Entries 109B
Entries 72B
Entries 66B
Entries 65B
Entries 63B
Entries 56B
Entries 48B
Entries 45B
Entries 39B
Entries 29B
Entries 26B
Entries 14B
2-6.gif 6KB
1-1.gif 6KB
2-4.gif 5KB
2-5.gif 5KB
2-3.gif 5KB
2-1.gif 5KB
s08.gif 4KB
s09.gif 3KB
admin_logo.gif 3KB
xong4.gif 3KB
xong9.gif 3KB
xong5.gif 3KB
title.gif 3KB
xong1.gif 3KB
xong8.gif 3KB
xong7.gif 3KB
共 288 条
- 1
- 2
- 3
lf1985421
- 粉丝: 7
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0