本文章要实现的功能如下:
1.主页点击添加按钮,可跳转到添加页面,进行图书的添加
2.点击删除链接,可将对应的图书删除
3.主页点击修改按钮,可跳转到修改页面,进行图书信息的修改
4.主页搜索栏输入要搜索的图书,可跳转到显示图书详细信息的页面
一、要实现这些功能所需要的接口及实现类
BookDao:
boolean add(Book book);
boolean delete(String name);
boolean update(Book book);
Book SearchByName(String name);
BookDaoImp:
@Override
public boolean add(Book book) {
// TODO Auto-generated method stub
boolean flag=false;
DBCon dbcon=new DBCon();
cn=dbcon.getConnection();
String sql="insert into books(name,price,num,type) values(?,?,?,?)";
try {
psm=cn.prepareStatement(sql);
psm.setString(1, book.getName());
psm.setString(2, book.getPrice());
psm.setString(3, book.getNum());
psm.setString(4, book.getType());
psm.executeUpdate();
flag=true;
cn.close();
psm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
@Override
public boolean delete(String name) {
// TODO Auto-generated method stub
boolean flag=false;
DBCon dbcon=new DBCon();
cn=dbcon.getConnection();
String sql="delete from books where name=?";
try {
psm=cn.prepareStatement(sql);
psm.setString(1, name);
if(psm.executeUpdate()!=0) {
flag=true;
}
cn.close();
psm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
@Override
public boolean update(Book book) {
// TODO Auto-generated method stub
boolean flag=false;
DBCon dbcon=new DBCon();
cn=dbcon.getConnection();
String sql="update books set price=?,num=?,type=? where name=?";
try {
psm=cn.prepareStatement(sql);
psm.setString(1, book.getPrice());
psm.setString(2, book.getNum());
psm.setString(3, book.getType());
psm.setString(4, book.getName());
if(psm.executeUpdate()!=0) {
flag=true;
}
cn.close();
psm.close(