软件工程开学第一次测试

package bean;

public class user {
    private  int id;
    private String name;
    private String mima;
    private String phone;
    private String danwei;

    public String getName() {
        return name;
    }

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

    public String getMima() {
        return mima;
    }

    public void setMima(String mima) {
        this.mima = mima;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getDanwei() {
        return danwei;
    }

    public void setDanwei(String danwei) {
        this.danwei = danwei;
    }

    public int getId() {
        return id;
    }

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

package bean;

public class xuqiu {
    private  int id;
    private String people;
    private  String name;
    private  String gaishu;
    private  String leixing;
    private  String moshi;
    private  String touzi;
    private  String data;
    private  String zhuangtai;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public String getGaishu() {
        return gaishu;
    }

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

    public String getLeixing() {
        return leixing;
    }

    public void setLeixing(String leixing) {
        this.leixing = leixing;
    }

    public String getMoshi() {
        return moshi;
    }

    public void setMoshi(String moshi) {
        this.moshi = moshi;
    }

    public String getTouzi() {
        return touzi;
    }

    public void setTouzi(String touzi) {
        this.touzi = touzi;
    }

    public String getPeople() {
        return people;
    }

    public void setPeople(String people) {
        this.people = people;
    }

    public String getData() {
        return data;
    }

    public void setData(String data) {
        this.data = data;
    }

    public String getZhuangtai() {
        return zhuangtai;
    }

    public void setZhuangtai(String zhuangtai) {
        this.zhuangtai = zhuangtai;
    }
}

package dao;

import bean.user;
import bean.xuqiu;
import util.util;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class dao {
    public Connection sjk()
    {
        Connection connect;
        try {
            connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/xuqiuzhengji?&useSSL=false&serverTimezone=UTC","root","123456");
            return connect;
        }catch(Exception e)
        {
            e.printStackTrace();
        }
        return null;
    }


    public boolean queryEmpty(String name,String phone,String danwei,String mima)
    {
        boolean flag=false;
        if(phone==null||"".equals((phone))&&name==null||"".equals(name)&&danwei==null||"".equals(danwei)&&mima==null||"".equals(mima))
        {
            flag=true;
        }
        return flag;
    }
    public Connection sj()
    {
        Connection connect;
        try {
            connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/xuqiuzhengji?&useSSL=false&serverTimezone=UTC","root","123456");
            return connect;
        }catch(Exception e)
        {
            e.printStackTrace();
        }
        return null;
    }


    //查询旧密码是否正确
    public boolean judgemima(String name,String mima)
    {
        boolean flag=false;
        Connection connection=util.getConnection();
        ResultSet rs=null;
        String sql="select * from user where name="+name;
        try {
            Statement statement=connection.createStatement();
            rs=statement.executeQuery(sql);
            if(rs.next()) {
                String mima2 =(rs.getString("mima"));
                if (mima2.equals(mima))
                    flag=true;
            }
            util.close(rs,statement,connection);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        return flag;
    }
    //修改顾客密码
    public void mimaxiugai(String mima)
    {
        try {
            PreparedStatement preparedStatement=null;
            Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/xuqiuzhengji?&useSSL=false&serverTimezone=UTC","root","123456");
            preparedStatement=connect.prepareStatement("Update user set mima=(mima)");
            preparedStatement.setString(2,mima);
            preparedStatement.executeUpdate();
            preparedStatement.execute();
            connect.close();
        }catch(SQLException e){
            e.printStackTrace();
        }
    }

    //录入顾客input()
    public void input(String name,String phone,String danwei,String mima)
    {
        try {
            PreparedStatement preparedStatement=null;
            Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/xuqiuzhengji?&useSSL=false&serverTimezone=UTC","root","123456");
            preparedStatement=connect.prepareStatement("insert into user (name,mima,phone,danwei) values (?,?,?,?)");
            preparedStatement.setString(1,name);
            preparedStatement.setString(2,mima);
            preparedStatement.setString(3,phone);
            preparedStatement.setString(4,danwei);

            preparedStatement.executeUpdate();
            connect.close();
            preparedStatement.close();
        }catch(SQLException e){
            e.printStackTrace();
        }
    }


    //录入需求input2()
    public void input2(String name,String gaishu,String leixing,String moshi,String touzi,String data,String zhuangtai,String people){
        try {
            PreparedStatement preparedStatement=null;
            Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/xuqiuzhengji?&useSSL=false&serverTimezone=UTC","root","123456");
            preparedStatement=connect.prepareStatement("insert into xuqiu (name,gaishu,leixing,moshi,touzi,people,data,zhuangtai) values (?,?,?,?,?,?,?,?)");
            preparedStatement.setString(1,name);
            preparedStatement.setString(2,gaishu);
            preparedStatement.setString(3,leixing);
            preparedStatement.setString(4,moshi);
            preparedStatement.setString(5,touzi);
            preparedStatement.setString(6,people);
            preparedStatement.setString(7,data);
            preparedStatement.setString(8,zhuangtai);

            preparedStatement.executeUpdate();
            connect.close();
            preparedStatement.close();
        }catch(SQLException e){
            e.printStackTrace();
        }
    }
    //显示所有需求信息
    public static xuqiu gerenxuqiu(String name) {
        List<xuqiu> list = new ArrayList<xuqiu>();
        Connection con=util.getConnection();
        ResultSet rs=null;
        String sql="select * from xuqiu where people="+name;
        try {//连接数据库的操作
            Statement statement=con.createStatement();
            rs=statement.executeQuery(sql);
            while (rs.next()) {
                xuqiu x = new xuqiu();
                x.setId(Integer.parseInt(rs.getString("id")));
                x.setName(rs.getString("name"));  ;
                x.setData(rs.getString("data"));
                x.setZhuangtai(rs.getString("zhuangtai"));

                list.add(x);
            }
            util.close(rs, statement, con);
        }catch(Exception e){
            e.printStackTrace();
        }
        return (xuqiu) list;
    }

    //显示用户需求信息
    public static xuqiu getxuqiu(String name) {
        xuqiu x = new xuqiu();
        Connection connection=util.getConnection();
        ResultSet rs=null;
        String sql="select * from xuqiu where name="+name;
        try {
            Statement statement=connection.createStatement();
            rs=statement.executeQuery(sql);
            if(rs.next()) {
                x.setName(rs.getString("name"));  ;
                x.setGaishu(rs.getString("gaishu"));
                x.setLeixing(rs.getString("leixing"));
                x.setMoshi(rs.getString("moshi"));
                x.setTouzi(rs.getString("touzi"));
                x.setData(rs.getString("data"));
                x.setZhuangtai(rs.getString("zhuangtai"));

            }
            util.close(rs,statement,connection);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return x;
    }



    //判断顾客登录信息是否正确judgeguk()
    public int judge(String name,String mima)
    {
        int flag=0;
        try {
            Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/xuqiuzhengji?&useSSL=false&serverTimezone=UTC","root","123456");
            Statement stmt = connect.createStatement();
            ResultSet rs = stmt.executeQuery("select * from user");
            while(rs.next())
            {
                if((name.equals(rs.getString("name")))&& mima.equals(rs.getString("mima")))
                {
                    flag=1;
                }
                else if (name.equals(rs.getString("name"))&& !mima.equals(rs.getString("mima")))
                {
                    flag=2;
                }
            }
            rs.close();
            connect.close();
            stmt.close();
        }catch (SQLException e) {
            e.printStackTrace();
        }
        return  flag;
    }

}

package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class util {

    private static String mysqlname = "xuqiuzhengji";
    private static Connection con;
    private static Statement sta;
    private static ResultSet re;
    private static String coursename = "com.mysql.cj.jdbc.Driver";
    private static String url = "jdbc:mysql://localhost:3306/" + mysqlname + " ?serverTimezone=GMT%2B8";


    public static Connection getConnection() {
        try {
            Class.forName(coursename);
            System.out.println("连接成功");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            con = DriverManager.getConnection(url, "root", "123456");
            System.out.println("LIANJIE");
        } catch (Exception e) {
            e.printStackTrace();
            con = null;
        }
        return con;
    }

    public static void close(Statement state, Connection conn) {
        if (state != null) {
            try {
                state.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public static void close(ResultSet rs, Statement state, Connection conn) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (state != null) {
            try {
                state.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}