struts2与Oracle的增删改查

首先看看整个工程：


1.导入我们需要的jar包，上面图里有！！！
2.在web.xml文件中配置过滤器

写实体类，我这里用到了两个实体类，bookuser和book，bookuser是验证登录用的，book就是我们要操作的数据，我们在数据库里需要建两张表：book和bookuser，这里就不写建表语言了。
bookuser.java
package com.it.entry;

public class BookUser {
private int id;
private String name;
private String password;
private int age;
private int sex;
private String nickname;
private int usertype;
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 getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public int getSex() {
return sex;
}
public void setSex(int sex) {
this.sex = sex;
}
public String getNickname() {
return nickname;
}
public void setNickname(String nickname) {
this.nickname = nickname;
}
public int getUsertype() {
return usertype;
}
public void setUsertype(int usertype) {
this.usertype = usertype;
}

}
book.java
package com.it.entry;

import java.util.Date;

public class Book {
private int id;
private String name;
private String author;
private String publish;
private Date publishdate;
private int page;
private double price;
private String content;
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 getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getPublish() {
return publish;
}
public void setPublish(String publish) {
this.publish = publish;
}
public Date getPublishdate() {
return publishdate;
}
public void setPublishdate(Date publishdate) {
this.publishdate = publishdate;
}
public int getPage() {
return page;
}
public void setPage(int page) {
this.page = page;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public Book( String name, String author, String publish,
Date publishdate, int page, double price, String content) {
super();

    this.name = name;
    this.author = author;
    this.publish = publish;
    this.publishdate = publishdate;
    this.page = page;
    this.price = price;
    this.content = content;
}
public Book() {
    super();
    // TODO Auto-generated constructor stub
}
@Override
public String toString() {
    return "Book [id=" + id + ", name=" + name + ", author=" + author
            + ", publish=" + publish + ", publishdate=" + publishdate
            + ", page=" + page + ", price=" + price + ", content="
            + content + "]";
}

}

dao层：
bookdao:

bookuserdao:
前面说了bookuser是用来验证登录的，id和密码是登录的帐号和密码，所以bookuserdao里面只写了用id查找的方法

这里就不用service方法，用一个工厂类来实现，如下图：

实现dao层类：
bookuserdaoimpl:

bookdaoimpl:

连接数据库：
第二张图片最后注释的可以用来测试数据库有没有连接上！！！！


接下写action：
bookuseraction():
package com.it.action;
import com.it.dao.BookFactory;
import com.it.dao.BookUserDao;
import com.it.entry.BookUser;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

public class BookUserAction extends ActionSupport implements ModelDriven {
private static final long serialVersionUID = 1L;
BookUser bookuser=new BookUser();
BookUserDao userdao=BookFactory.getBookUserDao();
public BookUser getBookUser(){
return bookuser;}
public void setBookUser(BookUser bookuser){
this.bookuser=bookuser;}
@Override
public BookUser getModel() {
return bookuser;}
public String login(){
System.out.println(“login”);
System.out.println(bookuser.getId()+”“+bookuser.getPassword());
String result=null;
try {if(userdao.findById(bookuser.getId())!= null){
if(userdao.findById(bookuser.getId()).getId()==bookuser.getId()&&(bookuser.getPassword().equals(
userdao.findById(bookuser.getId()).getPassword()))){
result=SUCCESS;
System.out.println(“success”);
}else{
result=INPUT;}}else{
result=INPUT;}
} catch (Exception e) {
e.printStackTrace();}
return result; }}

bookaction（对图书信息进行操作）:
package com.it.action;

import java.util.List;

import com.it.dao.BookDao;
import com.it.dao.BookFactory;
import com.it.entry.Book;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

public class BookAction extends ActionSupport implements ModelDriven {
private static final long serialVersionUID = 1L;
Book book=new Book();
BookDao bookdao=BookFactory.getBookDao();
public Book getBook(){
return book;
}
public void setBook(Book book){
this.book=book;
}

@Override
public Book getModel() {
    return book;
} 

public List<Book> booklist;
public List<Book> getBooklist() {
    return booklist;
}
public void setBooklist(List<Book> booklist) {
    this.booklist = booklist;
}   
public String show(){
    try {
        booklist=bookdao.findAll();
        System.out.println("show");
    } catch (Exception e) {
        e.printStackTrace();
    }
    return "show";
}
public String insert(){
    String s=null;
    try {
        if(bookdao.insert(book)){
            booklist=bookdao.findAll();
            return s="show";