求助 这个idea报错怎么解决啊

Question

package dao;

import pojo.User;

public interface UserDao {
    //登录操作
    public User login(String name, String pwd);

    //删除操作
    public boolean delete(int id);

    //注册操作
    public User register(int id,String name,String pwd,String name2,String age;String sex;String hobby;String birthday);

    //更新操作
    public User update(int id,String name,String pwd);
}




import utils.DBUtils;

import java.sql.SQLException;

public class UserDaoImpl implements UserDao {

    QueryRunner runner=new QueryRunner(DBUtils.getDataSource());
    @Override
    public User login(String name, String pwd) {
        try {
            User user=runner.query("select * from user1 where name=? and pwd=?",new BeanHandler<>(User.class),name,pwd);
            return user;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    @Override
    public boolean delete(int id) {
        try {
            int num=runner.update("delete from user1 where id=?", id);
            System.out.println("删除成功"+num);
            return true;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }


    @Override
    public User register(int id, String name, String pwd, String name2, String age,String sex,String hobby,String birthday) {
        try {
            int num = runner.update("insert into user1(id,name,pwd,name2,age,sex,hobby,birthday)values(?,?,?)", id,name,pwd,name2,age,sex,hobby,birthday);
            System.out.println("添加"+num);
            User user=new User(id,name,pwd,name2,age,sex,hobby,birthday);
            return user;
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }


    @Override
    public User update(int id, String name, String pwd) {
        try {
            int num = runner.update("update user1 set name=?,pwd=? where id=?", name,pwd,id);
            System.out.println("更新"+num);
            User user=new User(id,name,pwd);
            return user;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
}



package pojo;

public class User {
    private int id;
    private String name;
    private String pwd;
    private String name2;
    private String age;
    private String sex;
    private String hobby;
    private String birthday;

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                ", name2='" + name2 + '\'' +
                ", age='" + age + '\'' +
                ", sex='" + sex + '\'' +
                ", hobby='" + hobby + '\'' +
                ", birthday='" + birthday + '\'' +
                '}';
    }

    public String getName2() {
        return name2;
    }

    public void setName2(String name2) {
        this.name2 = name2;
    }

    public String getAge() {
        return age;
    }

    public void setAge(String age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getHobby() {
        return hobby;
    }

    public void setHobby(String hobby) {
        this.hobby = hobby;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public User(int id, String name, String pwd, String name2, String age, String sex, String hobby, String birthday) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
        this.name2 = name2;
        this.age = age;
        this.sex = sex;
        this.hobby = hobby;
        this.birthday = birthday;
    }

    public User(int id, String name, String pwd) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
    }

    public User() {
    }

    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 getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

}

Dao接口 注册操作 sex hobby birthday 报错怎么解决啊

Answer 1

你的这个报错原因我已经看出来了，是你的接口方法参数中不应该包含分号。

public User register(int id,String name,String pwd,String name2,String age;String sex;String hobby;String birthday);

仔细看看上面这行代码。

以后多注意Caused By xxxx 开头的，那几行是关键报错信息，一般来说，是异常抛出的根本原因。

另外在Java中接口方法默认就是public abstract 的，不需要显式的指定public.

完全可以写成

public interface UserDao {
    //登录操作
    User login(String name, String pwd);
 
    //删除操作
    boolean delete(int id);
 
    //注册操作
    User register(int id,String name,String pwd,String name2,String age,String sex,String hobby,String birthday);
 
    //更新操作
    User update(int id,String name,String pwd);
}