前言
博主使用JavaWeb开发的一款商城项目，可以衍生出其他各种商品销售网站
前台： 书籍查看，分页，购物车，个人信息，登录注册，按类别检索
后台： 用户管理，类别管理，用户管理，订单管理
JavaWeb网上书店运行视频
下面介绍下该项目的实现过程
数据库设计
首先是数据库：
项目目录：
工具类
数据库操作
public class DBUtil {
// 数据库驱动程序
private String driver;
// 数据库连接信息
private String url;
// 连接数据库的用户名
private String username;
// 连接数据库的密码
private String password;
// 连接对象
private Connection con;
// 预编译语句对象
private PreparedStatement pstmt;
// 查询结果分页时，每页显示记录数。
public static final long PAGE_REC_NUM = 8;
public void setDriver(String driver) {
this.driver = driver;
}
public void setUrl(String url) {
this.url = url;
}
public void setUsername(String username) {
this.username = username;
}
public void setPassword(String password) {
this.password = password;
}
public DBUtil() {
driver = "com.mysql.jdbc.Driver";
url = "jdbc:mysql://localhost:3306/good_shop?characterEncoding=utf8&serverTimezone=UTC&useSSL=false"; // 数据库名meal可变
username = "root";
password = "px980305"; // 数据库密码可变
}
// 初始化方法，加载驱动程序，获得数据库的连接对象。
private void init() {
try {
Class.forName(driver);
con = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 数据库操作对象的关闭
private void close() {
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (con != null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
// 为预编译的SQL语句中的占位符?设置值，值被放在字符串数组params中。
private void setParams(String[] params) {
if (params != null) {
for (int i = 0; i < params.length; i++) {
try {
pstmt.setString(i + 1, params[i]);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
// 执行更新类（增删改）的SQL语句，SQL语句中含有占位符。
public int update(String sql, String[] params) {
int result = 0;
init();
try {
pstmt = con.prepareStatement(sql);
setParams(params);
result = pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close();
}
return result;
}
// 执行更新类（增删改）的SQL语句，SQL语句中不含有占位符。
public int update(String sql) {
return update(sql, null);
}
// 执行返回多条记录的查询操作，结果被封装到List中。
public List<Map<String, String>> getList(String sql, String[] params) {
List<Map<String, String>> list = null;
init();
try {
pstmt = con.prepareStatement(sql);
setParams(params);
ResultSet rs = pstmt.executeQuery();
list = getListFromRS(rs);
rs.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
close();
}
return list;
}
public List<Map<String, String>> getList(String sql) {
return getList(sql, null);
}
// 执行返回至多一条记录的查询操作，结果被封装到Map中。
public Map<String, String> getMap(String sql, String[] params) {
Map<String, String> m = null;
List<Map<String, String>> l = getList(sql, params);
if (l != null && l.size() != 0) {
m = (Map<String, String>) (l.get(0));
}
return m;
}
public Map<String, String> getMap(String sql) {
return getMap(sql, null);
}
// 将结果集中的内容封装到List中
private List<Map<String, String>> getListFromRS(ResultSet rs) throws SQLException {
List<Map<String, String>> list = new ArrayList<Map<String, String>>();
ResultSetMetaData rsmd = rs.getMetaData();
while (rs.next()) {
Map<String, String> m = new HashMap<String, String>();
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
String colName = rsmd.getColumnLabel(i);
String s = rs.getString(colName);
if (s != null) {
m.put(colName, s);
}
}
list.add(m);
}
return list;
}
// 查询结果分页时，返回分页信息的Map，包括总页数，每页记录数和当前页中的记录。
public Map<String, Object> getPage(String sql, String[] params, String curPage) {
Map<String, Object> page = new HashMap<String, Object>();
String newSql = sql + " limit " + (Long.parseLong(curPage) - 1) * PAGE_REC_NUM + "," + PAGE_REC_NUM;
List<Map<String, String>> pageList = getList(newSql, params);
sql = sql.toLowerCase();
String countSql = "";
if (sql.indexOf("group") >= 0) {
countSql = "select count(*) as tempNum from (" + sql + ") as temp";
} else {
countSql = "select count(*) as tempNum " + sql.substring(sql.indexOf("from"));
}
String count_s = (String) getMap(countSql, params).get("tempNum");
long count = Long.parseLong(count_s);
long totalPage = 0;
if (count % PAGE_REC_NUM == 0)
totalPage = count / PAGE_REC_NUM;
else
totalPage = count / PAGE_REC_NUM + 1;
page.put("list", pageList);
page.put("totalPage", totalPage);
page.put("curpage", curPage);
page.put("recNum", PAGE_REC_NUM);
return page;
}
public Map<String, Object> getPage(String sql, String curPage) {
return getPage(sql, null, curPage);
}
}
文件下载与图片上传
package util;
import java.io.File;
import java.io.IOException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.Part;
public class FileUploadUtil {
// 上传单一文件
public static String uploadSingleFile(Part part, HttpServletRequest request) {
String path = null;
String fileName = getFileName(part);
if (!fileName.equals("")) {
// 得到上传文件的文件扩展名
String fileExtName = getFileExtName(part);
String newFileName = System.currentTimeMillis() + fileExtName;
// 得到上传文件保存路径的服务器端硬盘物理路径
String savePath = request.getServletContext().getRealPath("/img");
File f = new File(savePath);
if (!f.exists()) {
f.mkdirs();
}
// 文件上传
try {
part.write(savePath + File.separator + newFileName);
path = "img/" + newFileName;
} catch (IOException e) {
e.printStackTrace();
}
}
return path;
}
/**
* 根据请求头解析出文件名 请求头的格式：火狐和google浏览器下：form-data; name="file";
* filename="snmp4j--api.zip" IE浏览器下：form-data; name="file";
* filename="E:\snmp4j--api.zip"
*
* @param header 请求头
* @return 文件名
*/
public static String getFileName(Part part) {
/**
* String[] tempArr1 = header.split(";");代码执行完之后，在不同的浏览器下，tempArr1数组里面的内容稍有区别
* 火狐或者google浏览器下：tempArr1={form-data,name="file",filename="snmp4j--api.zip"}
* IE浏览器下：tempArr1={form-data,name="file",filename="E:\snmp4j--api.zip"}
*/
String header = part.getHeader("content-disposition");
String[] tempArr1 = header.split(";");
/**
* 火狐或者google浏览器下：tempArr2={filename,"snmp4j--api.zip"}
* IE浏览器下：tempArr2={filename,"E:\snmp4j--api.zip"}
*/
String[] tempArr2 = tempArr1[2].split("=");
// 获取文件名，兼容各种浏览器的写法
String fileName = tempArr2[1].substring(tempArr2[1].lastIndexOf("\\") + 1).replaceAll("\"", "");
return fileName;
}
public static String getFileExtName(Part part) {
String fileName = getFileName(part);
if(fileName.equals("")) {
return "";
}else {
return fileName.substring(fileName.lastIndexOf("."));
}
}
}
时间格式转换
public class Times {
public String getTime(){
Long timeStamp = System.currentTimeMillis(); //获取当前时间戳
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String time = sdf.format(new Date(Long.parseLong(String.valueOf(timeStamp))));
return time;
}
}
Controller控制器（servlet)
管理员获取所有商品的servlet
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
String gname=request.getParameter("gname");
if(gname==""){
gname="";
}
String curpage=request.getParameter("curpage");
if(curpage==""){
curpage="1";
}
Map<String, Object> cars=gs.getGoodsPage(gname, curpage);
request.setAttribute("goods", cars);
request.getRequestDispatcher("/admin/good_list.jsp").forward(request, response);
}
商品数据库操作 service和dao结合了
public class GoodService {
DBUtil db=new DBUtil();
public List<Map<String,String>> getGoods(String gname){
String sql = "select goods.id id,goods.gname gname,goods.price price ,types.typename typename,goods.image image from goods inner join types on types.id=goods.typeid where goods.gname like '%"+gname+"%' order by id";
return db.getList(sql);
}
public Map<String, Object> getGoodsPage(String gname,String curpage,String uid){
String sql = "select goods.id id,goods.gname gname,goods.price price ,types.typename typename,goods.image image from goods inner join types on types.id=goods.typeid where goods.gname like '%"+gname+"%' and goods.uid=? ";
String[] params = new String[]{uid};
return db.getPage(sql, params, curpage);
}
public Map<String, Object> getGoodsPage(String gname,String curpage){
String sql = "select goods.id id,goods.gname gname,goods.price price ,types.typename typename,goods.image image from goods inner join types on types.id=goods.typeid where goods.gname like '%"+gname+"%' ";
return db.getPage(sql, null, curpage);
}
public List<Map<String,String>> getGoodsByType(String type){
String sql = "select goods.id id,goods.gname gname,goods.price price ,goods.info info,types.typename typename,goods.image image from goods inner join types on types.id=goods.typeid where types.typename like '%"+type+"%' ";
return db.getList(sql);
}
public int addGood(Good good) {
// 带占位符的sql语句
String sql = "insert into goods(gname,price,image,typeid,uid,info) values(?,?,?,?,?,?)";
String[] params = new String[]{good.getGname(),good.getPrice(),good.getImage(),good.getTypeid(),good.getUid(),good.getInfo()};
// 得到预编译的语句对象
return db.update(sql, params);
}
public int delGood(String id) {
String sql = "delete from goods where id=?";
String[] params= {id};
return db.update(sql,params);
}
public int update(Good good) {
String sql= "update goods set gname=?,price=?,image=?,typeid=? where id=?";
String[] params= {good.getGname(),good.getPrice(),good.getImage(),good.getTypeid(),String.valueOf(good.getId())};
return db.update(sql,params);
}
public Good getGoodById(String id){
String sql = "select goods.id id,goods.gname gname,goods.price price ,goods.info info,goods.uid uid,types.typename typename,goods.image image from goods inner join types on types.id=goods.typeid where goods.id=? order by id";
String[] params = {id};
Map<String,String> g=db.getMap(sql, params);
Good good=new Good();
if(g!=null){
good.setId(Integer.valueOf(id));
good.setGname(g.get("gname"));
good.setImage(g.get("image"));
good.setPrice(g.get("price"));
good.setInfo(g.get("info"));
good.setUid(g.get("uid"));
good.setTypename(g.get("typename"));
}else{
good=null;
}
return good;
}
}
前端显示所有商品
<c:forEach items="${requestScope.goods.list }" var="good">
<tr>
<td style="width:80px;height:70px"><img src="${basePath}/${good.image }" style="width:60px;height:50px"></td>
<td>${good.gname }</td>
<td>${good.price }元</td>
<td>${good.typename }</td>
<td><a href="${basePath}/GoodGetById?id=${good.id }"><button type="button" class="btn btn-success">编辑</button></a>
<a href="${basePath}/GoodDelServlet?id=${good.id }"><button type="button" class="btn btn-danger">删除</button></a>
</td>
</tr>
</c:forEach>
以下是项目界面展示
452
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
