一.数据库代码
--用户表
create table shop_user(
id number primary key,
account varchar2(30) not null,
password varchar2(30) not null
);
insert into shop_user values(1,'xxx','xxx123');
--商品表
create table shop_goods(
id number primary key,
name varchar2(30) not null,
price number default 0.0,--价格
info varchar2(200) default '三五产品' not null--简介
);
commit
注意一定要commit提交,因为有可能拿不到数据。
二.项目代码
导入美化包,jar包
User.java代码
package com.zking.pojo;
public class User {
private Integer id;
private String account;
private String password;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getAccount() {
return account;
}
public void setAccount(String account) {
this.account = account;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public User(Integer id, String account, String password) {
super();
this.id = id;
this.account = account;
this.password = password;
}
public User() {
super();
// TODO Auto-generated constructor stub
}
}
Goods.java代码
package com.zking.pojo;
public class Goods {
private Integer id;
private String name;
private Integer price;
private String info;
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 getPrice() {
return price;
}
public void setPrice(Integer price) {
this.price = price;
}
public String getInfo() {
return info;
}
public void setInfo(String info) {
this.info = info;
}
public Goods(Integer id, String name, Integer price, String info) {
super();
this.id = id;
this.name = name;
this.price = price;
this.info = info;
}
public Goods() {
super();
// TODO Auto-generated constructor stub
}
@Override
public String toString() {
return "Goods [id=" + id + ", name=" + name + ", price=" + price + ", info=" + info + "]";
}
}
DBHelper.java代码
package com.zking.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBHelper {
//加载驱动
static{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//定义链接字符串
private static final String URL="jdbc:oracle:thin:@localhost:1521:orcl";
//获得链接
public static Connection getCon() {
try {
return DriverManager.getConnection(URL,"scott","sa123");
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
//关闭资源
public static void close(Connection con,PreparedStatement ps, ResultSet rs) {
try {
if (con!=null&&!con.isClosed()) {
con.close();
}if (ps!=null) {
ps.close();
}
if (rs!=null) {
rs.close();
}
}catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
System.out.print(DBHelper.getCon());
}
}
IUserDao.java接口代码
User login(User user);
IGoodsDao.java接口代码
//查询所有
List<Goods> getAll();
//查询单个
Goods getOne(Integer id);
UserDaolmpl.java代码
package com.zking.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.zking.dao.IUserDao;
import com.zking.pojo.User;
import com.zking.util.DBHelper;
public class UserDaoImpl implements IUserDao{
private Connection con;
private PreparedStatement ps;
private ResultSet rs;
@Override
public User login(User user) {
try {
con=DBHelper.getCon();
ps=con.prepareStatement("select * from shop_user where account=?");
ps.setString(1, user.getAccount());
rs=ps.executeQuery();
if(rs.next()) {
User u=new User();
u.setId(rs.getInt(1));
u.setAccount(rs.getString(2));
u.setPassword(rs.getString(3));
return u;
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBHelper.close(con, ps, rs);
}
return null;
}
}
GoodsDaolmpl.java代码
package com.zking.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.zking.dao.IGoodsDao;
import com.zking.pojo.Goods;
import com.zking.pojo.User;
import com.zking.util.DBHelper;
public class GoodsDaolmpl implements IGoodsDao{
private Connection con;
private PreparedStatement ps;
private ResultSet rs;
@Override
public List<Goods> getAll() {
List<Goods> list = new ArrayList<Goods>();
try {
con=DBHelper.getCon();
ps=con.prepareStatement("select * from shop_goods");
rs=ps.executeQuery();
while(rs.next()) {
Goods goods=new Goods();
goods.setId(rs.getInt(1));
goods.setName(rs.getString(2));
goods.setPrice(rs.getInt(3));
goods.setInfo(rs.getString(4));
list.add(goods);
}
return list;
} catch (Exception e) {
e.printStackTrace();
}finally {
DBHelper.close(con, ps, rs);
}
return list;
}
@Override
public Goods getOne(Integer id) {
try {
con = DBHelper.getCon();
ps = con.prepareStatement("select * from shop_goods where id=?");
ps.setInt(1, id);
rs = ps.executeQuery();
if (rs.next()) {
Goods goods = new Goods();
goods.setId(rs.getInt(1));
goods.setName(rs.getString(2));
goods.setPrice(rs.getInt(3));
goods.setInfo(rs.getString(4));
return goods;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBHelper.close(con, ps, rs);
}
return null;
}
}
IGoodsBiz.java代码
//查询所有
List<Goods> getAll();
//查询单个
Goods getOne(Integer id);
IUserBiz.java代码
User login(User user);
GoodsBizlmpl.java代码
package com.zking.biz.impl;
import java.util.List;
import com.zking.biz.IGoodsBiz;
import com.zking.dao.IGoodsDao;
import com.zking.dao.impl.GoodsDaolmpl;
import com.zking.pojo.Goods;
public class GoodsBizlmpl implements IGoodsBiz{
private IGoodsDao goodsDao=new GoodsDaolmpl();
@Override
public List<Goods> getAll() {
return goodsDao.getAll();
}
@Override
public Goods getOne(Integer id) {
return goodsDao.getOne(id);
}
}
UserBizlmpl.java代码
package com.zking.biz.impl;
import com.zking.biz.IUserBiz;
import com.zking.dao.IUserDao;
import com.zking.dao.impl.UserDaoImpl;
import com.zking.pojo.User;
public class UserBizImpl implements IUserBiz{
private IUserDao userDao=new UserDaoImpl();
@Override
public User login(User user) {
User u=userDao.login(user);
if(u!=null) {
if(u.getPassword().equals(user.getPassword())) {
return u;
}
}
return null;
}
}
CarItem.java代码
package com.zking.vo;
import com.zking.pojo.Goods;
public class CarItem extends Goods{
private Integer count;//数量
private Integer sum;//总价
private Goods goods;//对应的商品
public Integer getCount() {
return count;
}
public void setCount(Integer count) {
this.count = count;
}
public Integer getSum() {
return sum;
}
public void setSum(Integer sum) {
this.sum = sum;
}
public Goods getGoods() {
return goods;
}
public void setGoods(Goods goods) {
this.goods = goods;
}
public CarItem(Integer id, String name, Integer price, String info, Integer count, Integer sum, Goods goods) {
super(id, name, price, info);
this.count = count;
this.sum = sum;
this.goods = goods;
}
public CarItem() {
super();
// TODO Auto-generated constructor stub
}
}
web.xml代码
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" id="WebApp_ID" version="4.0">
<display-name>Web14</display-name>
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
</web-app>
记得修改了xml代码后一定要重启服务器
登陆界面代码(login.java)
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>Document</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/css/bootstrap.css">
<script src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
<script src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/bootstrap.js"></script>
<style>
* {
outline: none !important;
}
html,
body {
background: #1abe9c;
}
form {
width: 300px;
background: #ebeff2;
box-shadow: 0px 0px 50px rgba(0, 0, 0, .5);
border-radius: 5px;
padding: 20px;
position: absolute;
left: 50%;
top: 50%;
transform: translate(-50%, -50%);
}
.btn-group {
width: 100%;
}
.btn-group button {
width: 50%;
}
</style>
</head>
<body>
<form action="dologin.jsp" method="post">
<h3 class="text-center" style="text-shadow: 2px 2px 1px #ed3f3f;">欢迎光临嘿嘿嘿超市</h3>
<div class="form-group">
<input name="account" type="text" class="form-control" placeholder="请输入您的用户名">
</div>
<div class="form-group">
<input name="password" type="password" class="form-control" placeholder="请输入您的密码">
</div>
<div class="btn-group">
<button type="submit" class="btn btn-primary">登录</button>
<button type="button" class="btn btn-danger" οnclick='location=href="regiest.html"'>没有账号?</button>
</div>
</form>
</body></html>