package ma.dao;
import ma.entity.Commodity;
import ma.utils.JDBCUtils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class CommodityDao {
public static CommodityDao brandDao = null;
private CommodityDao(){
}
public static CommodityDao getInstance() {
if(brandDao==null) {
synchronized (CommodityDao.class) {
if(brandDao == null) {
brandDao= new CommodityDao();
}
}
}
return brandDao;
}
//----------查询所有
public List<Commodity> selectAllCommodity() {
//JDBC 6个步骤
Connection conn = null;
PreparedStatement prepared = null;
ResultSet resultSet = null;
List<Commodity> commodityList = new ArrayList<>();
try {
conn = JDBCUtils.getConnection();
//查询操作
String sql = "select * from commodity";
prepared = conn.prepareStatement(sql);
resultSet = prepared.executeQuery();
while (resultSet.next()) {
//commodity s = new commodity();
Commodity c = new Commodity();
c.setId(resultSet.getInt("id"));
c.setName(resultSet.getString("name"));
c.setType(resultSet.getString("type"));
c.setOdm(resultSet.getString("odm"));
c.setDate(resultSet.getString("date"));
c.setPrice(resultSet.getDouble("price"));
c.setNum(resultSet.getInt("num"));
c.setDiscount(resultSet.getString("discount"));
//commodityList.add(s);
commodityList.add(c);
}
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
JDBCUtils.close(resultSet, prepared, conn);
}
return commodityList;
}
//数据库增加
public Integer addcommodity(Commodity commodity) {
//JDBC 6个步骤
Connection conn = null;
PreparedStatement prepared = null;
ResultSet resultSet = null;
List<Commodity> brandList = new ArrayList<>();
try {
conn = JDBCUtils.getConnection();
//查询操作
String sql = "insert into commodity(id,name,type,odm,date,price,num,discount) values (?,?,?,?,?,?,?,?)";
PreparedStatement preparedStatement = conn.prepareStatement(sql);
//给值
preparedStatement.setInt(1, commodity.getId());
preparedStatement.setString(2, commodity.getName());
preparedStatement.setString(3, commodity.getType());
preparedStatement.setString(4, commodity.getOdm());
preparedStatement.setString(5, commodity.getDate());
preparedStatement.setDouble(6, commodity.getPrice());
preparedStatement.setInt(7, commodity.getNum());
preparedStatement.setString(8, commodity.getDiscount());
int i = preparedStatement.executeUpdate();
return i;
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
JDBCUtils.close(resultSet, prepared, conn);
}
}
//i为要删除的id
public void deleteCommodity(int i) {
Connection conn = null;
PreparedStatement prepared = null;
ResultSet resultSet = null;
try {
conn = JDBCUtils.getConnection();
//删除操作
String sql = "delete from commodity where id = ?";
PreparedStatement preparedStatement = conn.prepareStatement(sql);
//给sql语句赋值
preparedStatement.setInt(1, i);
int count = preparedStatement.executeUpdate();
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
JDBCUtils.close(resultSet, prepared, conn);
}
}
//修改数据
public Boolean updateCommodity(Commodity commodity) {
Connection connection = null;
PreparedStatement prepared = null;
Integer row = null;
try {
connection = JDBCUtils.getConnection();
String sql = " update commodity set name = ?, type = ?, odm = ?, date = ?,price = ?,num = ?,discount = ? where id = ?";
prepared = connection.prepareStatement(sql);
prepared.setString(1, commodity.getName());
prepared.setString(2, commodity.getType());
prepared.setString(3, commodity.getOdm());
prepared.setString(4, commodity.getDate());
prepared.setDouble(5, commodity.getPrice());
prepared.setInt(6, commodity.getNum());
prepared.setString(7, commodity.getDiscount());
prepared.setInt(8, commodity.getId());
row = prepared.executeUpdate();
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
try {
prepared.close();
connection.close();
} catch (Exception e) {
throw new RuntimeException(e);
}
}
return row > 0;
}
// 根据准考证号查询
public Commodity examQuery(String id) {
Connection conn = null;
PreparedStatement prepared = null;
ResultSet resultSet = null;
Commodity c = null;
try {
conn = JDBCUtils.getConnection();
//查询操作
String sql = "select * from commodity where id = ?";
prepared = conn.prepareStatement(sql);
prepared.setString(1, id);
resultSet = prepared.executeQuery();
if (resultSet.next()) {
c = new Commodity();
c.setId(resultSet.getInt("id"));
c.setName(resultSet.getString("name"));
c.setType(resultSet.getString("type"));
c.setOdm(resultSet.getString("odm"));
c.setDate(resultSet.getString("date"));
c.setPrice(resultSet.getDouble("price"));
c.setNum(resultSet.getInt("num"));
c.setDiscount(resultSet.getString("discount"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
JDBCUtils.close(resultSet, prepared, conn);
}
return c;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
大二实训项目,超市商品管理系统,javaweb+html+css+sql (123个子文件)
CommodityDao.class 6KB
CommodityDao.class 6KB
Commodity.class 3KB
Commodity.class 3KB
UserDao.class 3KB
UserDao.class 3KB
CommodityAdd.class 2KB
CommodityAdd.class 2KB
CommodityUpdate.class 2KB
CommodityUpdate.class 2KB
JDBCUtils.class 2KB
JDBCUtils.class 2KB
CommodityDelete.class 2KB
CommodityDelete.class 2KB
useradd.class 2KB
useradd.class 2KB
userlogin.class 2KB
userlogin.class 2KB
CommodityQueryAll.class 2KB
CommodityQueryAll.class 2KB
CommodityIdQueryOne.class 2KB
CommodityIdQueryOne.class 2KB
User.class 1KB
User.class 1KB
CharacterEncodingFilter.class 1KB
CharacterEncodingFilter.class 1KB
index.css 1KB
index.css 1KB
queryall.css 664B
queryall.css 664B
common.css 451B
common.css 451B
.gitignore 184B
commodityadd.html 6KB
commodityadd.html 6KB
login.html 3KB
login.html 3KB
error.html 3KB
error.html 3KB
commodityUpdate.html 3KB
commodityUpdate.html 3KB
commoditydelete.html 2KB
commoditydelete.html 2KB
commodityIdquery.html 1KB
commodityIdquery.html 1KB
zhuce.html 758B
zhuce.html 758B
SupermarketSystem.iml 2KB
mysql-connector-java-8.0.29.jar 2.4MB
mysql-connector-java-8.0.29.jar 2.4MB
mysql-connector-java-8.0.29.jar 2.4MB
lombok-1.18.26.jar 1.88MB
lombok-1.18.26.jar 1.88MB
lombok-1.18.26.jar 1.88MB
druid-1.0.9.jar 1.76MB
druid-1.0.9.jar 1.76MB
druid-1.0.9.jar 1.76MB
servlet-api.jar 278KB
servlet-api.jar 278KB
servlet-api.jar 278KB
taglibs-standard-impl-1.2.5.jar 202KB
taglibs-standard-impl-1.2.5.jar 202KB
taglibs-standard-impl-1.2.5.jar 202KB
el-api.jar 86KB
el-api.jar 86KB
el-api.jar 86KB
jsp-api.jar 62KB
jsp-api.jar 62KB
jsp-api.jar 62KB
taglibs-standard-compat-1.2.5.jar 52KB
taglibs-standard-compat-1.2.5.jar 52KB
taglibs-standard-compat-1.2.5.jar 52KB
taglibs-standard-spec-1.2.5.jar 39KB
taglibs-standard-spec-1.2.5.jar 39KB
taglibs-standard-spec-1.2.5.jar 39KB
CommodityDao.java 7KB
Commodity.java 3KB
UserDao.java 2KB
JDBCUtils.java 2KB
CommodityUpdate.java 2KB
CommodityAdd.java 2KB
userlogin.java 1KB
CommodityDelete.java 1KB
User.java 1KB
useradd.java 1KB
CommodityQueryAll.java 955B
CommodityIdQueryOne.java 861B
CharacterEncodingFilter.java 776B
index.jsp 3KB
index.jsp 3KB
commodityidone.jsp 2KB
commodityidone.jsp 2KB
druid.properties 243B
druid.properties 243B
druid.properties 243B
commodity.sql 2KB
user.sql 987B
login.webp 34KB
login.webp 34KB
bj0.webp 26KB
共 123 条
- 1
- 2
资源评论
m0_73040413
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功