效果展示图:
目录结构
BookDao.java
package com.jike.dao;
import java.sql.*;
import java.util.HashMap;
import com.jike.vo.Book;
public class BookDao {
public HashMap getAllBook() throws ClassNotFoundException, SQLException{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/a","root","666");
String sql="select * from book";
PreparedStatement ps=conn.prepareStatement(sql);
ResultSet rs=ps.executeQuery();
HashMap hm=new HashMap();
while(rs.next()){
Book book=new Book();
book.setBookno(rs.getString(1));
book.setBookname(rs.getString(2));
book.setBookprice(rs.getFloat(3));
hm.put(book.getBookno(), book);
}
ps.close();
conn.close();
return hm;
}
}
SessionListener.java
package com.jike.listener;
import java.util.HashMap;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpSessionEvent;
import javax.servlet.http.HttpSessionListener;
public class SessionListener implements HttpSessionListener{
@Override
public void sessionCreated(HttpSessionEvent event) {
HttpSession session=event.getSession();
// ﳵ
HashMap books=new HashMap();
session.setAttribute("books", books);
session.setAttribute("money", 0F);
}
@Override
public void sessionDestroyed(HttpSessionEvent se) {
// TODO Auto-generated method stub
}
}
AddServlet.java
package com.jike.servlet;
import java.io.IOException;
import java.util.HashMap;
import javax.servlet.Ser