package dao;
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 util.JDBCUtil;
import model.student;
public class studentDAO {
// 查询所有
public List<student> quertyDao(){
JDBCUtil jdbc = new JDBCUtil();
Connection conn = jdbc.getConnection();
List<student> list= new ArrayList<student>();
try {
PreparedStatement pst = conn.prepareStatement("select * from t_student");
ResultSet rs = pst.executeQuery();
while(rs.next()){
int id = rs.getInt(1);
String name = rs.getString(2);
int java = rs.getInt(3);
int python = rs.getInt(4);
int javaScript = rs.getInt(5);
student stu = new student(id, name, java, python, javaScript);
list.add(stu);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}
//查询单个
public student quertyTwo(String id){
JDBCUtil jdbc = new JDBCUtil();
Connection conn = jdbc.getConnection();
student stu = null;
try {
PreparedStatement pst= conn.prepareStatement("select * from t_student where id=?");
pst.setInt(1,Integer.parseInt(id));
ResultSet rs= pst.executeQuery();
rs.next();
stu = new student(rs.getInt(1), rs.getString(2), rs.getInt(3), rs.getInt(4), rs.getInt(5));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return stu;
}
// 修改
public boolean modify(String java,String python,String javaScript,int id){
JDBCUtil jdbc = new JDBCUtil();
Connection conn = jdbc.getConnection();
try {
PreparedStatement pst = conn.prepareStatement("Update t_student set java=?,python=?,javaScript=? where id=?");
pst.setString(1, java);
pst.setString(2, python);
pst.setString(3, javaScript);
pst.setInt(4, id);
int i= pst.executeUpdate();
if (i>0) {
return true;
} else {
return false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return false;
}
// 添加
public boolean addStuDao(String name, String java,String python,String javaScript){
JDBCUtil jdbc = new JDBCUtil();
Connection conn = jdbc.getConnection();
try {
PreparedStatement pst = conn.prepareStatement("insert into t_student values(?,?,?,?)");
pst.setString(1,name);
pst.setInt(2,Integer.parseInt(java));
pst.setInt(3,Integer.parseInt(python));
pst.setInt(4,Integer.parseInt(javaScript));
int i = pst.executeUpdate();
if (i>0) {
return true;
} else {
return false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return false;
}
// 删除
public boolean delStuDao(String id){
JDBCUtil jdbc = new JDBCUtil();
Connection conn = jdbc.getConnection();
try {
PreparedStatement pst = conn.prepareStatement("delete from t_student where id=?");
pst.setInt(1, Integer.parseInt(id));
int i = pst.executeUpdate();
if (i>0) {
return true;
} else {
return false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return false;
}
}
jsp连接SQLserver数据库实现增删改查.这是一个完整的项目
4星 · 超过85%的资源 需积分: 49 8 浏览量
2019-01-08
13:48:28
上传
评论 31
收藏 463KB ZIP 举报
慕慕慕慕公子
- 粉丝: 14
- 资源: 20
最新资源
- Win64OpenSSL-3-3-0.exe
- 课高分程设计-基于C++实现的民航飞行与地图简易管理系统-南京航空航天大学
- 航天器遥测数据故障检测系统python源码+文档说明+数据库(课程设计)
- 北京航空航天大学操作系统课设+ppt+实验报告
- 基于Vue+Echarts实现风力发电机中传感器的数据展示监控可视化系统+源代码+文档说明(高分课程设计)
- 基于单片机的风力发电机转速控制源码
- 基于C++实现的风力发电气动平衡监测系统+源代码+测量数据(高分课程设计)
- 毕业设计- 基于STM32F103C8T6 单片机,物联网技术的太阳能发电装置+源代码+文档说明+架构图+界面截图
- 基于 LSTM(长短期记忆)(即改进的循环神经网络)预测风力发电厂中风力涡轮机产生的功率+源代码+文档说明
- 基于stm32f103+空心杯电机+oled按键+运动算法
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈