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 报错怎么解决啊