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;
}
}
sms_0.1.rar_family8x8_java_www.sms 1188.com
版权申诉
108 浏览量
2022-09-24
23:40:05
上传
评论
收藏 729KB RAR 举报
朱moyimi
- 粉丝: 61
- 资源: 1万+
最新资源
- ZEND解密dezender12
- sony 索尼IMX334摄像头模组电路板AD版硬件PCB图(6层板).zip
- 基于flask和echarts融合交易策略的bitfinex可视化微服务.zip
- 包含了wvp-assist.tar wvp-talk.tar zlmediakit.tar .
- 3r4efgh53wgrf43tw
- 2024新版Java基础从入门到精通全套视频+资料下载
- Spring AI大模型视频教程+ChatGPT视频教程+OpenAI大模型视频教程(资料+视频教程)
- ABB工业机器人教程PDF版本
- 123321123323211
- 三相桥式全桥整流电路MATALB Simulink仿真文件
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈