package com.djg.sms.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.djg.sms.dao.IStudentDao;
import com.djg.sms.domain.Student;
import com.djg.sms.util.JDBCUtil;
public class StudentDaoJDBCImpl implements IStudentDao {
@Override
public List<Student> findAll() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<Student> stuList = null;
try {
conn = JDBCUtil.getConnection();
String sql = "select * from t_student";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
//遍历结果集
if(rs != null){
boolean flag = true;
while(rs.next()){
if(flag){
stuList = new ArrayList<Student>();
flag = false;
}
Student s = new Student();
s.setSno(rs.getInt("sno"));
s.setName(rs.getString("name"));
s.setMyclass(rs.getString("myclass"));
s.setScore(rs.getDouble("score"));
stuList.add(s);
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return stuList;
}
@Override
public Student findById(int id) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
Student student = null;
try {
conn = JDBCUtil.getConnection();
String sql = "select * from t_student where sno = ?";
ps = conn.prepareStatement(sql);
ps.setInt(1, id);
rs = ps.executeQuery();
//遍历结果集
if(rs != null){
while(rs.next()){
student = new Student();
student.setSno(rs.getInt("sno"));
student.setName(rs.getString("name"));
student.setMyclass(rs.getString("myclass"));
student.setScore(rs.getDouble("score"));
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return student;
}
@Override
public int add(Student s) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
int n = 0;
try {
conn = JDBCUtil.getConnection();
String sql = "insert into t_student (name,myclass,score) values(?,?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1, s.getName());
ps.setString(2, s.getMyclass());
ps.setDouble(3, s.getScore());
n = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
return n;
}
@Override
public int deleteById(int id) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
int n = 0;
try {
conn = JDBCUtil.getConnection();
String sql = "delete from t_student where sno = ?";
ps = conn.prepareStatement(sql);
ps.setInt(1, id);
n = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
return n;
}
@Override
public int modify(int id, Student s) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
int n = 0;
try {
conn = JDBCUtil.getConnection();
String sql = "update t_student set name=?,myclass=?,score=? where sno=?";
ps = conn.prepareStatement(sql);
ps.setString(1, s.getName());
ps.setString(2, s.getMyclass());
ps.setDouble(3, s.getScore());
ps.setInt(4, id);
n = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
return n;
}
@Override
public int findTotalCount() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
int n = 0;
try {
conn = JDBCUtil.getConnection();
String sql = "select count(*) as totalcount from t_student";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
if(rs != null){
while(rs.next()){
n = rs.getInt("totalcount");
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return n;
}
@Override
public List<Student> findOnePage(int pageIndex, int pageSize) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<Student> stuList = null;
//计算分页相关参数
//变量startRecordNo 存储的是当前分页第一条记录的前一个位置
int startRecordNo = (pageIndex - 1) * pageSize;
try {
conn = JDBCUtil.getConnection();
String sql = "select * from t_student limit ?,?";
ps = conn.prepareStatement(sql);
ps.setInt(1, startRecordNo);
ps.setInt(2, pageSize);
rs = ps.executeQuery();
//遍历结果集
if(rs != null){
boolean flag = true;
while(rs.next()){
if(flag){
stuList = new ArrayList<Student>();
flag = false;
}
Student s = new Student();
s.setSno(rs.getInt("sno"));
s.setName(rs.getString("name"));
s.setMyclass(rs.getString("myclass"));
s.setScore(rs.getDouble("score"));
stuList.add(s);
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return stuList;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
sms_0.6.rar_java_mightmut_southern21q
共60个文件
class:18个
java:18个
jsp:7个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 149 浏览量
2022-09-23
20:25:50
上传
评论
收藏 1.12MB RAR 举报
温馨提示
学生管理系统,比较适合大学生使用,是一些较简单的代码,通俗易懂,简单明了。
资源推荐
资源详情
资源评论
收起资源包目录
sms_0.6.rar (60个子文件)
sms_0.6
WebContent
META-INF
MANIFEST.MF 39B
WEB-INF
web.xml 2KB
lib
mysql-connector-java-5.1.13-bin.jar 750KB
taglibs-standard-impl-1.2.5.jar 202KB
taglibs-standard-jstlel-1.2.5.jar 159KB
taglibs-standard-compat-1.2.5.jar 52KB
taglibs-standard-spec-1.2.5.jar 39KB
login.jsp 1KB
test.jsp 448B
main
main.jsp 2KB
modify.jsp 2KB
data2excel.jsp 6KB
addStu.jsp 1KB
sql
sms_java16_new.sql 5KB
sms_java16.sql 4KB
logout.jsp 450B
.settings
org.eclipse.wst.jsdt.ui.superType.name 6B
org.eclipse.wst.common.project.facet.core.xml 345B
org.eclipse.wst.common.component 473B
org.eclipse.wst.jsdt.ui.superType.container 49B
.jsdtscope 567B
org.eclipse.jdt.core.prefs 364B
src
com
djg
sms
dao
IStudentDao.java 439B
impl
StudentDaoJDBCImpl.java 5KB
UserDaoJDBCImpl.java 1016B
IUserDao.java 138B
filter
PermissionFilter.java 1KB
CharacterEncodingFilter.java 1KB
domain
User.java 798B
Student.java 989B
test
StudentDaoTest.java 2KB
UserDaoTest.java 359B
servlet
StudentAddServlet.java 1KB
StudentDeleteServlet.java 936B
StudentModifyServlet.java 1KB
ValidateCodeServlet.java 3KB
StudentListServlet.java 2KB
LoginServlet.java 2KB
util
JDBCUtil.java 1KB
PageBean.java 2KB
.project 1KB
.classpath 919B
build
classes
com
djg
sms
dao
IUserDao.class 182B
IStudentDao.class 547B
impl
StudentDaoJDBCImpl.class 5KB
UserDaoJDBCImpl.class 2KB
filter
CharacterEncodingFilter.class 2KB
PermissionFilter.class 2KB
domain
User.class 1KB
Student.class 2KB
test
StudentDaoTest.class 3KB
UserDaoTest.class 852B
servlet
ValidateCodeServlet.class 3KB
StudentListServlet.class 2KB
StudentDeleteServlet.class 1KB
LoginServlet.class 3KB
StudentModifyServlet.class 2KB
StudentAddServlet.class 2KB
util
PageBean.class 3KB
JDBCUtil.class 3KB
共 60 条
- 1
资源评论
alvarocfc
- 粉丝: 105
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- VR开发的概要介绍与分析
- 自动驾驶定位系列教程七:点云畸变补偿.pdf
- HM2302D-VB一款N-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- HM2302B-VB一款N-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- springboot学生考勤管理系统
- HM2302A-VB一款N-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- HM2301-VB一款P-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- 数据可视化的概要介绍与分析
- HM2301E-VB一款P-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- HM2301D-VB一款P-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功