package dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import model.PageBean;
import model.Score;
import model.ScoreCou;
import model.ScoreSum;
import dao.ScoreDao;
import db.DBCon;
public class ScoreDaoImpl implements ScoreDao {
private Score score = null;
private ScoreCou scoreCou = null;
private PageBean pageBean = null;
private ScoreSum scoreSum = null;
private DBCon dbCon = new DBCon();
public int addScore(Score score) {
String sql = "insert into score(stu_num,stu_name,stu_class,course_name,score_grade,major) values('"
+ score.getStuNum()
+ "','"
+ score.getStuName()
+ "','"
+ score.getStuClass()
+ "','"
+ score.getCourseName()
+ "',"
+ score.getScoreGrade() + ",'" + score.getMajor() + "')";
int rs = dbCon.query(sql);
return rs;
}
public int deleteScore(int scoreID) {
String sql = "delete from score where score_id=" + scoreID;
int rs = dbCon.query(sql);
return rs;
}
public int editCos(Score score) {
String sql = "update score set stu_num='" + score.getStuNum()
+ "',stu_name='" + score.getStuName() + "',stu_class='"
+ score.getStuClass() + "',course_name='"
+ score.getCourseName() + "',score_grade="
+ score.getScoreGrade() + ",major='" + score.getMajor()
+ "' where score_id=" + score.getScoreID();
int rs = dbCon.query(sql);
return rs;
}
public List findAll() {
List<Score> list = new ArrayList<Score>();
String sql = "select * from score";
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreID = rs.getInt("score_id");
String stuNum = rs.getString("stu_num");
String stuName = rs.getString("stu_name");
String stuClass = rs.getString("stu_class");
String courseName = rs.getString("course_name");
double scoreGrade = rs.getDouble("score_grade");
String major = rs.getString("major");
Score score = new Score(scoreID, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List findOne(String stuNum) {
List<ScoreCou> list = new ArrayList<ScoreCou>();
String sql = "select score.course_name,course_credit,course_hours,course_teacher,major,coursedate,score_grade "
+ "from score,course where score.course_name=course.course_name and stu_num='"
+ stuNum + "'";
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
String courseName = rs.getString("course_name");
int courseCredit = rs.getInt("course_credit");
int courseHours = rs.getInt("course_hours");
String courseTea = rs.getString("course_teacher");
String major = rs.getString("major");
Date courseDate = rs.getDate("coursedate");
double scoreGrade = rs.getDouble("score_grade");
ScoreCou scoreCou = new ScoreCou(courseName, courseCredit,
courseHours, courseTea, major, courseDate, scoreGrade);
list.add(scoreCou);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List selectScore(int scoreID) {
List<Score> list = new ArrayList<Score>();
String sql = "select * from score where score_id=" + scoreID;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreid = rs.getInt("score_id");
String stuNum = rs.getString("stu_num");
String stuName = rs.getString("stu_name");
String stuClass = rs.getString("stu_class");
String courseName = rs.getString("course_name");
double scoreGrade = rs.getDouble("score_grade");
String major = rs.getString("major");
Score score = new Score(scoreid, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public Score selectScoreInfo(Score scor) {
String sql = "select * from score where stu_num='" + scor.getStuNum()
+ "' and course_name='" + scor.getCourseName() + "'";
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreid = rs.getInt("score_id");
String stuNum = rs.getString("stu_num");
String stuName = rs.getString("stu_name");
String stuClass = rs.getString("stu_class");
String courseName = rs.getString("course_name");
double scoreGrade = rs.getDouble("score_grade");
String major = rs.getString("major");
score = new Score(scoreid, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
}
} catch (SQLException e) {
e.printStackTrace();
}
return score;
}
public PageBean scoreListPage(int pageNo, int pageCount, String stuNum) {
int totalCount = 0;
List<ScoreCou> list = new ArrayList<ScoreCou>();
String sql = "select score.course_name,course_credit,course_hours,course_teacher,major,coursedate,score_grade "
+ "from score,course where score.course_name=course.course_name and stu_num='"
+ stuNum
+ "' limit "
+ ((pageNo - 1) * pageCount)
+ ","
+ pageCount;
String sqlCount = "select count(*) from score,course where score.course_name=course.course_name and stu_num='"
+ stuNum + "'";
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
String courseName = rs.getString("course_name");
int courseCredit = rs.getInt("course_credit");
int courseHours = rs.getInt("course_hours");
String courseTea = rs.getString("course_teacher");
String major = rs.getString("major");
Date courseDate = rs.getDate("coursedate");
double scoreGrade = rs.getDouble("score_grade");
ScoreCou scoreCou = new ScoreCou(courseName, courseCredit,
courseHours, courseTea, major, courseDate, scoreGrade);
list.add(scoreCou);
}
rs = dbCon.find(sqlCount);
while (rs.next()) {
totalCount = rs.getInt(1);
}
pageBean = new PageBean(list, totalCount, pageNo, pageCount);
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
return pageBean;
}
public PageBean scoreListPage(int pageNo, int pageCount) {
int totalCount = 0;
List<Score> list = new ArrayList<Score>();
String sql = "select * from score limit " + ((pageNo - 1) * pageCount)
+ "," + pageCount;
String sqlCount = "select count(*) from score";
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreID = rs.getInt("score_id");
String stuNum = rs.getString("stu_num");
String stuName = rs.getString("stu_name");
String stuClass = rs.getString("stu_class");
String courseName = rs.getString("course_name");
double scoreGrade = rs.getDouble("score_grade");
String major = rs.getString("major");
score = new Score(scoreID, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
rs = dbCon.find(sqlCount);
while (rs.next()) {
totalCount = rs.getInt(1);
}
pageBean = new PageBean(list, totalCount, pageNo, pageCount);
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
return pageBean;
}
public List findStuOne(String stuNum, String courseName) {
List<ScoreCou> list = new ArrayList<ScoreCou>();
String sql = "select score.course_name,course_credit,course_hours,course_teacher,major,coursedate,score_grade "
+ "from score,course where score.course_name=course.course_name and stu_num='"
+ stuNum + "' and course.course_name='" + courseName + "'";
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
String coursename = rs.getString("course_name");
int courseCredit = rs.getInt("course_credit");
int courseHours = rs.getInt("course_hours");
String courseTea = rs.getString("course_teacher");
String major = rs.getString("major");
Date courseDate = r
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
系统环境:Windows10 开发工具:Eclipse4.8.0 / MyEclipse2014 / IDEA 编码集:UTF-8 Java版本:JDK 1.8 服务器:tomcat 8.0 数据库:MySQL 5.5 系统采用技术:Servlet+jsp+mysql+jQuery+bootstrap+面向接口编程
资源推荐
资源详情
资源评论
收起资源包目录
基于Servlet+jsp+mysql开发javaWeb学生成绩管理系统.rar (340个子文件)
,CKEDITOR.tools.htmlEncode(e._[ 1KB
_div style= 1KB
ScoreDaoImpl.class 11KB
ServletUploadFile.class 6KB
CourseDaoImpl.class 5KB
StudentDaoImpl.class 5KB
TeacherDaoImpl.class 5KB
UserDaoImpl.class 4KB
ServletDownloadFile.class 4KB
ServletaddTeacher.class 3KB
ServletaddStudent.class 3KB
ScoreServiceImpl.class 3KB
ServletRegistersStudent.class 3KB
ServletaddCourse.class 3KB
ServletLogin.class 3KB
DBCon.class 3KB
ServletEditCos.class 2KB
Teacher.class 2KB
ServletListFile.class 2KB
Student.class 2KB
ServletaddScore.class 2KB
ServletTeaSearchScore.class 2KB
ServletSearchScore.class 2KB
ServletTeaStuScore.class 2KB
ServletEditStudentInfo.class 2KB
ServletEditTeacherInfo.class 2KB
ServletEditScore.class 2KB
EmpBiz.class 2KB
ServletEditTea.class 2KB
ServletEditStu.class 2KB
ServletFindStu.class 2KB
Score.class 2KB
ServletFindStudentScore.class 2KB
User.class 2KB
ServletEditPwd.class 2KB
ScoreCou.class 2KB
Course.class 2KB
LoginFilter.class 2KB
ServletEditUser.class 2KB
ScoreSum.class 2KB
ServletStuSumList.class 2KB
ServletInfo.class 2KB
PageServlet.class 2KB
ServletFindAllStu.class 2KB
ServletFindAllScore.class 2KB
ServletTeaAllCos.class 2KB
ServletSelectStudentInfo.class 2KB
ServletFindAllCos.class 2KB
ServletOneStudentScore.class 2KB
ServletStuSum.class 2KB
ServletselectPwd.class 2KB
ServletStudentInfo.class 2KB
ServletPwd.class 2KB
UsRole.class 2KB
ServletSelectCos.class 2KB
ServletselectTeacherInfo.class 2KB
ServletTeacherInfo.class 2KB
ServletSelectTea.class 2KB
ServletSelectStu.class 2KB
ServletRegisterStu.class 2KB
PageBean.class 2KB
EncodingFilter.class 2KB
ServletSelectScore.class 2KB
ServletDeleteCos.class 2KB
ServletSelectUser.class 2KB
ServletDeleteTea.class 2KB
ServletDeleteStu.class 2KB
ServletDeleteScore.class 2KB
CourseServiceImpl.class 2KB
ServletFindAllTea.class 1KB
ServletFindAllUser.class 1KB
ServletStuAllScore.class 1KB
StudentServiceImpl.class 1KB
TeacherServiceImpl.class 1KB
Servletlogout.class 1KB
UserServiceImpl.class 1KB
Role.class 1KB
ScoreService.class 778B
ScoreDao.class 722B
CourseService.class 398B
CourseDao.class 386B
TeacherService.class 358B
StudentService.class 358B
TeacherDao.class 346B
StudentDao.class 346B
UserService.class 314B
UserDao.class 302B
.classpath 1KB
org.eclipse.wst.common.component 559B
org.eclipse.wst.jsdt.ui.superType.container 49B
bootstrap.min.css 107KB
style.default.css 80KB
animate.min.css 50KB
font-awesome.1.css 39KB
font-awesome.css 26KB
font-awesome.min.css 20KB
prettyPhoto.css 20KB
jquery-ui-1.10.3.css 19KB
select2.css 19KB
animate.delay.css 12KB
共 340 条
- 1
- 2
- 3
- 4
资源评论
暂时没想好名字001
- 粉丝: 26
- 资源: 159
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 老照片修复教程(带资料),再也不用去照相馆修复了!-教程网盘链接提取码下载 .txt
- STM32单片机FPGA毕设电路原理论文报告一种建立单片机应用系统菜单的新方法
- 诊所医院超常规运营管理思维,课程+直播+社群+连麦+实操-教程网盘链接提取码下载 .txt
- STM32单片机FPGA毕设电路原理论文报告一种简单方法实现基于STC89C52RC单片机的频率计
- STM32单片机FPGA毕设电路原理论文报告一种基于低功耗单片机的抗干扰电源
- Linux知识体系复习
- STM32单片机FPGA毕设电路原理论文报告一种基于等效采样技术的高速数据采集系统
- 东华深度学习课后习题全部
- STM32单片机FPGA毕设电路原理论文报告一种基于单片机系统的无线遥控技术
- STM32单片机FPGA毕设电路原理论文报告一种基于单片机及CPLD测试平台的设计与实现
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功