10.30

今天Java考试部分代码如下

package bean;

public class Bean {
    private int id;
    private String name;
    private String gaishu;
    private String fangshi;
    private String starttime;
    private String fianltime;
    private String gongyi;

    public void setId(int id) {
        this.id = id;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setGaishu(String gaishu) {
        this.gaishu = gaishu;
    }

    public void setFangshi(String fangshi) {
        this.fangshi = fangshi;
    }

    public void setStarttime(String starttime) {
        this.starttime = starttime;
    }

    public void setFianltime(String fianltime) {
        this.fianltime = fianltime;
    }

    public void setGongyi(String gongyi) {
        this.gongyi = gongyi;
    }

    public int getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public String getGaishu() {
        return gaishu;
    }

    public String getFangshi() {
        return fangshi;
    }

    public String getStarttime() {
        return starttime;
    }

    public String getFianltime() {
        return fianltime;
    }

    public String getGongyi() {
        return gongyi;
    }

    public Bean(int id, String name, String gaishu, String fangshi, String starttime, String fianltime, String gongyi) {
        this.id = id;
        this.name = name;
        this.gaishu = gaishu;
        this.fangshi = fangshi;
        this.starttime = starttime;
        this.fianltime = fianltime;
        this.gongyi = gongyi;
    }

    @Override
    public String toString() {
        return "Bean{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", gaishu='" + gaishu + '\'' +
                ", fangshi='" + fangshi + '\'' +
                ", starttime='" + starttime + '\'' +
                ", fianltime='" + fianltime + '\'' +
                ", gongyi='" + gongyi + '\'' +
                '}';
    }
}

package dao;

import Util.DBUtil;
import bean.Bean;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Dao {
    public boolean add(Bean ten) throws ClassNotFoundException , SQLException
    {
        String sql="insert into test(name,gaishu,fangshi,starttime,finaltime,gongyi)values"
                + "('"ten.getName() + "','" + ten.getGaishu() + "','"+ ten.getStarttime() + "','" + ten.getFianltime() + "','" + ten.getFangshi() + "','" + ten.getGongyi() +  "')";

        Connection conn= DBUtil.getConnection();
        Statement state=null;
        boolean f=false;
        int a = 0;
        try {
            state = conn.createStatement();
            state.executeUpdate(sql);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {

            DBUtil.close(state, conn);
        }
        if(a>0)
            f=true;
        return f;
    }

    public Bean getbyname(String name) throws ClassNotFoundException ,SQLException
    {

        String sql = "select * from test where name ='" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;
        Bean ten = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                int id=rs.getInt("id");

                String name2 = rs.getString("name");
                String gaishu2 = rs.getString("gaishu");
                String fangshi2 = rs.getString("fangshi");
                String starttime2=rs.getString("starttime");
                String finaltime2 = rs.getString("finaltime");
                String gongyi2 =rs.getString("gongyi");


                ten = new Bean(id,name2,gaishu2,fangshi2,starttime2,fangshi2,gongyi2);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return ten;
    }


    //delete
    public boolean delete(String name) throws SQLException, ClassNotFoundException {
        String sql="delete from test where name='" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        int a = 0;
        boolean f = false;
        try {
            state = conn.createStatement();
            a = state.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(state, conn);
        }

        if (a > 0) {
            f = true;
        }
        return f;
    }
    //update
    public boolean update(Bean b)
    {
        Connection con=null;
        PreparedStatement pstmt=null;
        ResultSet rs=null;
        try {
            con=DBUtil.getConnection();
            String sql="update shetuan set name=?,gaishu=?,fangshi=?,starttime=?,finaltime=?,gongyi=? where id=?";
            pstmt=con.prepareStatement(sql);
            pstmt.setString(1, b.getName());
            pstmt.setString(2, b.getFangshi());
            pstmt.setString(3, b.getGaishu());
            pstmt.setString(4, b.getStarttime());
            pstmt.setString(5, b.getFianltime());
            pstmt.setString(6, b.getGongyi());
            pstmt.setInt(7, b.getId());
            pstmt.executeUpdate();
            return true;
        }
        catch (SQLException | ClassNotFoundException e) {
            System.out.println("更新失败");
            e.printStackTrace();
        }
        finally {
            DBUtil.close(rs, pstmt, con);
        }
        return false;
    }
    //查找
    public boolean name(String name) throws SQLException, ClassNotFoundException {
        boolean flag = false;
        String sql = "select name from test where name = '" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                flag = true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }
        return flag;
    }


    public List<Bean> search(String name, String gaishu, String fangshi, String starttime) throws SQLException, ClassNotFoundException {
        String sql = "select * from test where ";


        if (name != "") {
            sql += "name like '%" +name+ "%'";
        }

        if (gaishu != "") {
            sql += "gaishu like '%" +gaishu+ "%'";
        }
        if(fangshi!="") {
            sql+="fangshi like '%"+fangshi+ "%'";
        }

        if(starttime!="") {
            sql+="starttime like '%" +starttime+ "%'";
        }
        List<Bean> list = new ArrayList<>();
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;
        Bean bean = null;
        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                int id =rs.getInt("id");
                String name2 = rs.getString("name");
                String gaishu2 = rs.getString("gaishu");
                String fangshi2 = rs.getString("fangshi");
                String starttime2=rs.getString("starttime");
                String finaltime2 = rs.getString("finaltime");
                String gongyi2 =rs.getString("gongyi");

                bean = new Bean(id,name2,gaishu2,fangshi2,starttime2,fangshi2,gongyi2);

                list.add(bean);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return list;
    }

    public List<Bean> list() throws SQLException, ClassNotFoundException {
        String sql = "select * from test";
        List<Bean> list = new ArrayList<>();
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                Bean bean = null;
                int id=rs.getInt("id");
                String name2 = rs.getString("name");
                String gaishu2 = rs.getString("gaishu");
                String fangshi2 = rs.getString("fangshi");
                String starttime2=rs.getString("starttime");
                String finaltime2 = rs.getString("finaltime");
                String gongyi2 =rs.getString("gongyi");


                bean = new Bean(id,name2,gaishu2,fangshi2,starttime2,fangshi2,gongyi2);

                list.add(bean);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return list;
    }

package service;

import bean.Bean;
import dao.Dao;

import java.sql.SQLException;
import java.util.List;

public class Service {
    Dao tDao=new Dao();
    public boolean add(Bean ten) throws SQLException, ClassNotFoundException {
        boolean f = false;
        if(!tDao.name(ten.getName()))
        {
            tDao.add(ten);
            f=true;
        }
        return f;
    }

    public boolean del(String name) throws SQLException, ClassNotFoundException {
        tDao.delete(name);
        return true;
    }

    public boolean update(Bean ten)
    {
        tDao.update(ten);
        return true;
    }

    public Bean getbyname(String name) throws SQLException, ClassNotFoundException {
        return tDao.getbyname(name);
    }

    public List<Bean> search(String name, String gaishu, String fangshi, String starttime) throws SQLException, ClassNotFoundException {
        return tDao.search(name,gaishu,fangshi,starttime);
    }


    public List<Bean> list() throws SQLException, ClassNotFoundException {
        return tDao.list();
    }
}

}