2024.3.15
第九天
所花时间:2小时
代码量:400+
博客量:1
了解到的知识点:今天是计划调剂的dao层
package db; import bean.Jihua; import java.sql.*; import java.util.ArrayList; public class JihuaDao { public int adduser(Jihua bean) { int i = 0; Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; try { con = DB.getConn(); String sql = "insert into tb_user.jihua(zhuanye, number, zongfen, zhengzhi, yingyu, shuxue, time) values(?,?,?,?,?,?,?)"; pstmt = con.prepareStatement(sql); pstmt.setString(1, bean.getZhuanye()); pstmt.setInt(2, bean.getNumber()); pstmt.setInt(3, bean.getZongfen()); pstmt.setInt(4, bean.getZhengzhi()); pstmt.setInt(5, bean.getYingyu()); pstmt.setInt(6, bean.getShuxue()); pstmt.setString(7, bean.getTime()); i = pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { DB.close(rs, pstmt, con); } return i; } public ArrayList<Jihua> getall() { ArrayList<Jihua> list = new ArrayList<>(); Connection con = null; Statement state = null; ResultSet rs = null; try { con = DB.getConn(); String sql = "select * from tb_user.jihua"; state = con.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { Jihua bean = new Jihua(); bean.setZhuanye(rs.getString("zhuanye")); bean.setNumber(rs.getInt("number")); bean.setZongfen(rs.getInt("zongfen")); bean.setZhengzhi(rs.getInt("zhengzhi")); bean.setYingyu(rs.getInt("yingyu")); bean.setShuxue(rs.getInt("shuxue")); bean.setTime(rs.getString("time")); list.add(bean); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } DB.close(rs, state, con); return list; } public Jihua SearchByName(String zhuanye) { // TODO Auto-generated method stub Connection con = null; Statement state = null; ResultSet rs = null; Jihua bean = new Jihua(); try { con = DB.getConn(); String sql = "select * from tb_user.jihua where zhuanye='" + zhuanye + "'"; state = con.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { bean.setZhuanye(rs.getString("zhuanye")); bean.setNumber(rs.getInt("number")); bean.setZongfen(rs.getInt("zongfen")); bean.setZhengzhi(rs.getInt("sizheng")); bean.setYingyu(rs.getInt("yingyu")); bean.setShuxue(rs.getInt("shuxue")); bean.setTime(rs.getString("time")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } DB.close(rs, state, con); return bean; } // public int update(Jihua bean) { // // TODO Auto-generated method stub // int i = 0; // Connection con = null; // ResultSet rs = null; // PreparedStatement pstmt = null; // try { // con = DB.getConn(); // String sql = "update tb_user.jihua set zhuanye=?,zongfen=?,zhengzhi=? ,yingyu=? ,shuxue=? ,time=?where zhuanye=?"; // pstmt = con.prepareStatement(sql); // bean.setName(rs.getString("name")); // bean.setId(rs.getString("id")); // bean.setZhuanye(rs.getString("zhuanye")); // bean.setZongfen(rs.getString("zongfen")); // bean.setSizhang(rs.getString("sizheng")); // bean.setYingyu(rs.getString("yingyu")); // bean.setShuxue(rs.getString("shuxue")); // bean.setZonghe(rs.getString("zonghe")); // bean.setJieguo(rs.getString("jieguo")); // i = pstmt.executeUpdate(); // } catch (SQLException e) { // e.printStackTrace(); // } finally { // DB.close(rs, pstmt, con); // } // return i; // } // public int del(String id) { // Connection con = null; // ResultSet rs = null; // PreparedStatement pstmt = null; // int i = 0; // try { // con = DB.getConn(); // String sql = "delete from tb_user.tiaoji where id='" + id + "'"; // pstmt = con.prepareStatement(sql); // i = pstmt.executeUpdate(); // } catch (SQLException e) { // e.printStackTrace(); // } finally { // DB.close(rs, pstmt, con); // } // return i; // } public ArrayList<Jihua> select(String content, String way) { ArrayList<Jihua> list = new ArrayList<>(); Connection con = null; Statement state = null; ResultSet rs = null; String sql = "select * from tb_user.jihua"; if (content != "" && "1".equals(way)) { sql += " where name='" + content + "'"; } else if (content != "" && "2".equals(way)) { sql += " where id like'%" + content + "%'"; } else if (content != "" && "3".equals(way)) { sql += " where zongfen='" + content + "'"; } else { sql = "select * from tb_user.tiaoji"; } try { con = DB.getConn(); state = con.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { Jihua bean = new Jihua(); bean.setZhuanye(rs.getString("name")); bean.setZongfen(rs.getInt("id")); bean.setZhengzhi(rs.getInt("zhengzhi")); bean.setYingyu(rs.getInt("yingyu")); bean.setShuxue(rs.getInt("shuxue")); bean.setTime(rs.getString("time")); list.add(bean); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } DB.close(rs, state, con); return list; } }