最近敲了敲struts+jsp的增删改查 欧克~话不多说 -------->
准备工作:导入所需要的jar包、struts.xml、配置web.xml
1、分包分模块
创建 dao层 service层 pojo和utils包 当然 不要忘记最重要的Action层
2、创建实体类,在这我创建的是 Student类 ,给他get/set方法,toString方法,有参构造和无参构造(可不添加)
public class Student {
private Integer id;
private String name;
private Integer age;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
@Override
public String toString() {
return "Student [id=" + id + ", name=" + name + ", age=" + age + "]";
}
public Student(Integer id, String name, Integer age) {
super();
this.id = id;
this.name = name;
this.age = age;
}
public Student() {
super();
// TODO Auto-generated constructor stub
}
}
3、在dao层创建一个接口以及他的实现类
public interface StudentDaoI {
List<Student> findList();
Student findById(Integer id);
void UpdateStudent(Student student);
void AddStudent(Student student);
void Delate(Integer id);
}
public class StudentDaoImpl implements StudentDaoI{
@Override
public List<Student> findList() {
String sql="select * from student ";
List<Student> list=new ArrayList<Student>();
Connection connection = JDBCUtil.getConnection();
PreparedStatement pst=null;
ResultSet rs=null;
try {
pst = connection.prepareStatement(sql);
rs = pst.executeQ