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 108 浏览量
2019-01-08
13:48:28
上传
评论 31
收藏 463KB ZIP 举报
慕慕慕慕公子
- 粉丝: 12
- 资源: 20
最新资源
- main.c
- Unity 创建快捷方式自动启动
- 一分钟一条原创视频,蹭热点撸收益,条条爆款,狂撸各大平台,轻松日入1000+-教程网盘链接提取码下载 .txt
- 51单片机实现万年历,包括闹钟的设置与秒表功能(汇编)
- STM32单片机FPGA毕设电路原理论文报告铁合金电炉单片机电力监控系统的研究
- STM32单片机FPGA毕设电路原理论文报告贴片元件封装机的智能控制系统设计
- STM32单片机FPGA毕设电路原理论文报告体育高考投篮自动测试系统的设计与实现
- STM32单片机FPGA毕设电路原理论文报告提高放疗精度的单片机控制方法
- C++ matplot学习及demo实操
- STM32单片机FPGA毕设电路原理论文报告提高单晶炉加热电源控制电路精度的研究
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈