src/com/demo/dao/impl/WeixiuDAOImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.demo.dao.impl;

import com.demo.util.Util;
import com.demo.dao.WeixiuDAO;
import com.demo.vo.Weixiu;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 维修模块的DAO层（数据层）的具体实现类，对WeixiuDAO接口中定义的增删改查等抽象方法作出具体的功能实现
 */
public class WeixiuDAOImpl implements WeixiuDAO {

    //@Override
    public void add(Weixiu vo) {
        String sql = "insert into `t_weixiu` (`weixiu_no`,`weixiu_name`,`weixiu_guzhang`,`weixiu_feiyong`,`weixiu_date`,`weixiu_ren`,`weixiu_phone`,`weixiu_status`,`weixiu_text`) values(?,?,?,?,?,?,?,?,?)";
        try {
            Connection c = Util.getConnection();
            PreparedStatement ps = c.prepareStatement(sql);
            
            ps.setString(1, vo.getWeixiuNo());
            ps.setString(2, vo.getWeixiuName());
            ps.setString(3, vo.getWeixiuGuzhang());
            ps.setString(4, vo.getWeixiuFeiyong());
            ps.setString(5, vo.getWeixiuDate());
            ps.setString(6, vo.getWeixiuRen());
            ps.setString(7, vo.getWeixiuPhone());
            ps.setString(8, vo.getWeixiuStatus());
            ps.setString(9, vo.getWeixiuText());
            ps.execute();
            ps.close();
            c.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    //@Override
    public void update(Weixiu vo) {
        String sql = "update `t_weixiu` set `weixiu_no` = ? ,`weixiu_name` = ? ,`weixiu_guzhang` = ? ,`weixiu_feiyong` = ? ,`weixiu_date` = ? ,`weixiu_ren` = ? ,`weixiu_phone` = ? ,`weixiu_status` = ? ,`weixiu_text` = ?  where `id` = ?";
        try {
            Connection c = Util.getConnection();
            PreparedStatement ps = c.prepareStatement(sql);
            
            ps.setString(1, vo.getWeixiuNo());
            ps.setString(2, vo.getWeixiuName());
            ps.setString(3, vo.getWeixiuGuzhang());
            ps.setString(4, vo.getWeixiuFeiyong());
            ps.setString(5, vo.getWeixiuDate());
            ps.setString(6, vo.getWeixiuRen());
            ps.setString(7, vo.getWeixiuPhone());
            ps.setString(8, vo.getWeixiuStatus());