package demo.dao.impl;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.UUID;
import org.apache.struts2.ServletActionContext;
import demo.dao.IComputerDAO;
import demo.jdbc.MyConnection;
import demo.model.Computer;
public class ComputerDAO implements IComputerDAO{
private Connection connection = MyConnection.getConnection();
private PreparedStatement pstmt=null;
private ResultSet rs;
private File upload;
private String uploadFileName;
public File getUpload() {
return upload;
}
public void setUpload(File upload) {
this.upload = upload;
}
public String getUploadFileName() {
return uploadFileName;
}
public void setUploadFileName(String uploadFileName) {
this.uploadFileName = uploadFileName;
}
@Override
public List<Computer> find() {
// TODO Auto-generated method stub
String sql = "select * from info_computer";
List<Computer>computerData = new ArrayList<Computer>();
try{
pstmt = connection.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
Computer computer = new Computer();
computer.setId(rs.getInt(1));
computer.setBrand(rs.getString(2));
computer.setVersion(rs.getString(3));
computer.setPrice(rs.getString(4));
computer.setCtype(rs.getString(5));
computer.setScreensize(rs.getString(6));
computer.setCpu(rs.getString(7));
computer.setGraphics(rs.getString(8));
computer.setMemory(rs.getString(9));
computer.setHardDisk(rs.getString(10));
computer.setColor(rs.getString(11));
//computer.setImageFileName(rs.getString(12));
computerData.add(computer);
}
rs.close();
pstmt.close();
}catch(SQLException e){
e.printStackTrace();
}
return computerData;
}
@Override
public void insertOK(Computer computer)throws Exception {
// TODO Auto-generated method stub
InputStream is = new FileInputStream(computer.getTpbin());
String path = ServletActionContext.getServletContext().getRealPath("/img/");
System.out.println(computer.getTpbinFileName());
System.out.println(computer.getTpbinContentType());
String est = computer.getTpbinFileName().substring(computer.getTpbinFileName().lastIndexOf("."));
UUID uuid = UUID.randomUUID();
String saveFileName = uuid + est;
System.out.println(path + saveFileName);
OutputStream os = new FileOutputStream(path + saveFileName);
byte buffer[] = new byte[1024];
int count = 0;
while((count=is.read(buffer))>0){
os.write(buffer,0,count);
}
is.close();
os.close();
String sql = "insert into info_computer(brand,version,price,ctype,screensize,cpu,graphics,memory,hardDisk,color,tp) "
+ "values(?,?,?,?,?,?,?,?,?,?,?)";
try{
pstmt = connection.prepareStatement(sql);
pstmt.setString(1, computer.getBrand());
pstmt.setString(2, computer.getVersion());
pstmt.setString(3, computer.getPrice());
pstmt.setString(4, computer.getCtype());
pstmt.setString(5, computer.getScreensize());
pstmt.setString(6, computer.getCpu());
pstmt.setString(7, computer.getGraphics());
pstmt.setString(8, computer.getMemory());
pstmt.setString(9, computer.getHardDisk());
pstmt.setString(10, computer.getColor());
pstmt.setString(11,saveFileName);
pstmt.executeUpdate();
pstmt.close();
}catch(SQLException e){
e.printStackTrace();
}
}
@Override
public void updateOK(Computer computer) {
// TODO Auto-generated method stub
String sql = "update info_computer set brand=?,version=?,price=?,ctype=?,"
+ "screensize=?,cpu=?,graphics=?,memory=?,hardDisk=?,color=?,tp=? where id=?";
try{
pstmt=connection.prepareStatement(sql);
pstmt.setString(1, computer.getBrand());
pstmt.setString(2, computer.getVersion());
pstmt.setString(3, computer.getPrice());
pstmt.setString(4, computer.getCtype());
pstmt.setString(5, computer.getScreensize());
pstmt.setString(6, computer.getCpu());
pstmt.setString(7, computer.getGraphics());
pstmt.setString(8, computer.getMemory());
pstmt.setString(9, computer.getHardDisk());
pstmt.setString(10, computer.getColor());
pstmt.setString(11, computer.getTp());
pstmt.setInt(12, computer.getId());
pstmt.executeUpdate();
pstmt.close();
}catch(SQLException e){
e.printStackTrace();
}
}
@Override
public void delete(Integer id) {
// TODO Auto-generated method stub
String sql = "delete from info_computer where id=?";
try{
pstmt = connection.prepareStatement(sql);
pstmt.setInt(1, id);
pstmt.executeUpdate();
pstmt.close();
}catch(SQLException e){
e.printStackTrace();
}
}
@Override
public List<Computer> selectID(Integer id) {
// TODO Auto-generated method stub
String sql = "select * from info_computer where id=" + id;
List<Computer>computerData = new ArrayList<Computer>();
try{
pstmt = connection.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
Computer computer = new Computer();
computer.setId(rs.getInt(1));
computer.setBrand(rs.getString(2));
computer.setVersion(rs.getString(3));
computer.setPrice(rs.getString(4));
computer.setCtype(rs.getString(5));
computer.setScreensize(rs.getString(6));
computer.setCpu(rs.getString(7));
computer.setGraphics(rs.getString(8));
computer.setMemory(rs.getString(9));
computer.setHardDisk(rs.getString(10));
computer.setColor(rs.getString(11));
computer.setTp(rs.getString(12));
computerData.add(computer);
}
rs.close();
pstmt.close();
}catch(SQLException e){
e.printStackTrace();
}
return computerData;
}
@Override
public List<Computer> selectKeywords(String keywords) {
// TODO Auto-generated method stub
String sql = "select * from info_computer where brand like '%"+keywords+"%'";
List<Computer>computerData = new ArrayList<Computer>();
try{
pstmt = connection.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
Computer computer = new Computer();
computer.setId(rs.getInt(1));
computer.setBrand(rs.getString(2));
computer.setVersion(rs.getString(3));
computer.setPrice(rs.getString(4));
computer.setCtype(rs.getString(5));
computer.setScreensize(rs.getString(6));
computer.setCpu(rs.getString(7));
computer.setGraphics(rs.getString(8));
computer.setMemory(rs.getString(9));
computer.setHardDisk(rs.getString(10));
computer.setColor(rs.getString(11));
computer.setTp(rs.getString(12));
computerData.add(computer);
}
rs.close();
pstmt.close();
}catch(SQLException e){
e.printStackTrace();
}
return computerData;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
利用Struts2+MVC Dao+mysql做的一个电脑配置信息管理系统(增,删,改,查)
共88个文件
jar:28个
java:10个
class:10个
需积分: 9 7 下载量 173 浏览量
2018-02-06
23:10:08
上传
评论
收藏 11.72MB RAR 举报
温馨提示
代码写的很详细,具体实现了用户登录、管理员登录、注册、增、删、改、按条件模糊查询、注销、文件上传等功能、适合javaWEB入门。
资源推荐
资源详情
资源评论
收起资源包目录
ComputerManage.rar (88个子文件)
ComputerManage
.project 1KB
.settings
.jsdtscope 564B
org.eclipse.core.resources.prefs 119B
org.eclipse.wst.common.component 501B
org.eclipse.jdt.core.prefs 364B
org.eclipse.wst.common.project.facet.core.xml 398B
org.eclipse.wst.jsdt.ui.superType.container 49B
org.eclipse.wst.jsdt.ui.superType.name 6B
WebRoot
login.jsp 956B
css
bootstrap.min.css 124KB
style.css 3KB
style2.css 489B
WEB-INF
web.xml 832B
lib
commons-lang-2.4.jar 256KB
commons-fileupload-1.3.3.jar 69KB
commons-beanutils-1.9.2.jar 228KB
commons-io-2.5.jar 204KB
xstream-1.4.10.jar 576KB
log4j-api-2.8.2.jar 223KB
commons-collections-3.2.2.jar 575KB
asm-5.2.jar 52KB
jackson-core-2.6.1.jar 253KB
struts2-convention-plugin-2.5.13.jar 85KB
ezmorph-1.0.6.jar 84KB
javassist-3.20.0-GA.jar 733KB
struts2-config-browser-plugin-2.5.13.jar 45KB
freemarker-2.3.23.jar 1.29MB
json-lib-2.3-jdk15.jar 148KB
sqljdbc42.jar 871KB
ognl-3.1.15.jar 230KB
xmlpull-1.1.3.1.jar 7KB
asm-tree-5.2.jar 29KB
commons-logging-1.1.3.jar 61KB
log4j-core-2.8.2.jar 1.34MB
xpp3_min-1.1.4c.jar 24KB
mysql-connector-java-5.1.44-bin.jar 976KB
commons-lang3-3.6.jar 483KB
jackson-databind-2.6.1.jar 1.11MB
asm-commons-5.2.jar 46KB
struts2-core-2.5.13.jar 1.54MB
jackson-annotations-2.6.0.jar 46KB
classes
struts.xml 3KB
demo
jdbc
MyConnection.class 1KB
dao
IUserDAO.class 212B
impl
ComputerDAO.class 7KB
UserDAO.class 2KB
IComputerDAO.class 633B
action
DemoUpload.class 2KB
ComputerAction.class 4KB
UserAction.class 3KB
model
User.class 1KB
Computer.class 3KB
index.jsp 834B
META-INF
MANIFEST.MF 39B
outLogin.jsp 442B
register.jsp 1KB
error.jsp 336B
update.jsp 1KB
img
5.png 8KB
img-1.png 182KB
ChMkJ1jvPBeIZAyHAAecsDksMBEAAbougGBBgIAB5zI274.jpg 22KB
2.jpg 284KB
lunbo3.jpg 48KB
lunbo2.jpg 57KB
1.jpg 3KB
失败.jpg 54KB
lunbo1.jpg 61KB
6.png 1KB
2.png 607KB
5.JPG 41KB
main.jsp 5KB
insertInfo.jsp 1KB
js
bootstrap.min.js.map 155KB
jquery-3.2.1.min.js 85KB
bootstrap.min.js 49KB
popper.min.js 19KB
src
struts.xml 3KB
demo
jdbc
MyConnection.java 817B
dao
IComputerDAO.java 512B
impl
UserDAO.java 2KB
ComputerDAO.java 7KB
IUserDAO.java 156B
action
UserAction.java 3KB
DemoUpload.java 1KB
ComputerAction.java 3KB
model
Computer.java 3KB
User.java 951B
.classpath 810B
共 88 条
- 1
资源评论
axing_ox
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功