以上为效果图
以下为代码部分
public interface IUserImpl {
// 定义方法
public List<Student> seleAll(String name);
// 查询 通过某些字段进行查询
// Student selectName(String name);
// 添加信息
public int add(Student student);
// 删除方法
public int delete(int id);
public Student selectId(int id);
public int update(Student student);
}
public class UserDao implements IUserImpl {
@Override
public List<Student> seleAll(String name) {
List<Student> list = new ArrayList<Student>();
Connection conn = DBUtil.getConnection();
String sql = "";
try {
if (name != null) {
sql = "select * from student where name like '%" + name + "%'";
} else {
sql = "select * from student";
}
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
Student s = new Student();
s.setId(rs.getInt("id"));
s.setName(rs.getString("name"));
s.setAge(rs.getInt("age"));
s.setPhone(rs.getString("phone"));
s.setSchool(rs.getString("school"));
s.setClassName(rs.getString("classname"));
list.add(s);
}
} catch (Exception e) {
// TODO: handle exception
}
return list; // 返回值 切记
}
@Override
public int add(Student student) {
Connection conn = DBUtil.getConnection();
int n = 0;
try {
// 对应数据库五个值
String sql = "insert into student values(?,?,?,?,?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, student.getId());
ps.setString(2, student.getName());
ps.setInt(3, student.getAge());
ps.setString(4, student.getPhone());
ps.setString(5, student.getSchool());
ps.setString(6, student.ge