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;
    }
}

 

posted @ 2024-03-19 00:30  cvjj  阅读(14)  评论(0)    收藏  举报