package Goods.Dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import Goods.JavaBean.GoodsBean;
import Common.*;
public class IGoodsDao {
public GoodsBean getOneGoods(String sql)
{
try
{
Connection conn = getConnection();
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery(sql);
GoodsBean goodsBean = new GoodsBean();
if(rs.next())
{
goodsBean.setId(rs.getString("Id"));
goodsBean.setGname(rs.getString("Gname"));
goodsBean.setContent(rs.getString("Content"));
goodsBean.setPrice(rs.getString("Price"));
goodsBean.setPic_goods(rs.getString("Pic_goods"));
goodsBean.setSnum(rs.getString("Snum"));
}
return goodsBean;
}
catch(Exception e)
{
return null;
}
}
public ArrayList<GoodsBean> getMoreGoods(String sql)
{
ArrayList<GoodsBean> res = new ArrayList<GoodsBean>();
try
{
Connection conn = getConnection();
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery(sql);
while(rs.next())
{
GoodsBean goodsBean = new GoodsBean();
goodsBean.setId(rs.getString("Id"));
goodsBean.setGname(rs.getString("Gname"));
goodsBean.setContent(rs.getString("Content"));
goodsBean.setPrice(rs.getString("Price"));
goodsBean.setPic_goods(rs.getString("Pic_goods"));
goodsBean.setSnum(rs.getString("Snum"));
res.add(goodsBean);
}
rs.close();
statement.close();
conn.close();
return res;
}
catch(SQLException e)
{
e.printStackTrace();
}
return res;
}
public boolean saveGoods(GoodsBean goodsBean)
{
String sql = "insert into tbl_goods(Gname,Content,Price,Pic_goods,Snum)"+
"values('"+goodsBean.getGname()+"'," +
"'"+goodsBean.getContent()+"','"+goodsBean.getPrice()+"','"+goodsBean.getPic_goods()+"','"+goodsBean.getSnum()+"')";
Database database = new Database();
boolean res = database.execute(sql);
return res;
}
public boolean deleteGoods(GoodsBean goodsBean)
{
String sql = "delete from tbl_goods where Id = '"+goodsBean.getId()+"'";
Database database = new Database();
boolean res = database.execute(sql);
return res;
}
public Connection getConnection() {
Connection conn=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/petwebsite?useUnicode=true&characterEncoding=UTF-8","root","123456");
}
catch(Exception e)
{
conn = null;
}
return conn;
}
public boolean add(GoodsBean goodsBean) {
try{
Connection conn = getConnection();
Statement statement = conn.createStatement();
String sql = "insert into tbl_goods(Gname,Content,Price,Pic_goods,Snum) values('"+goodsBean.getGname()+"','"+goodsBean.getContent()+"','"+goodsBean.getPrice()+"','"+goodsBean.getPic_goods()+"','"+goodsBean.getSnum()+"')";
statement.execute(sql);
statement.close();
conn.close();
return true;
}
catch(Exception e)
{
e.printStackTrace();
return false;
}
}
public boolean delete(String sql){
try
{
Connection conn = getConnection();
Statement statement = conn.createStatement();
statement.execute(sql);
statement.close();
conn.close();
return true;
}
catch(Exception e)
{
return false;
}
}
public boolean change(GoodsBean goodsBean)
{
try{
Connection conn = getConnection();
Statement statement = conn.createStatement();
String sql = "update tbl_goods set Gname = '"+goodsBean.getGname()+"',Price = '"+goodsBean.getPrice()+"' ,Content = '"+goodsBean.getContent()+"',Pic_goods = '"+goodsBean.getPic_goods()+"',Snum ='"+goodsBean.getSnum()+"' where Id = '"+goodsBean.getId()+"'";
statement.execute(sql);
statement.close();
conn.close();
return true;
}
catch(Exception e)
{
e.printStackTrace();
return false;
}
}
}
萌宠之宠物网站关于狗猫的 （163个子文件） 
IGoodsDao.class 5KB addPetShopServlet.class 5KB addUserServlet.class 4KB changeUserServlet.class 4KB changeUserServlet.class 4KB changePetShopServlet.class 4KB addUserServlet.class 4KB addPetServlet.class 4KB changePetServlet.class 4KB addGoodsServlet.class 4KB changeGoodsServlet.class 4KB ShopDao.class 4KB IUserDao.class 4KB addCategoryServlet.class 4KB IUserDao.class 4KB IUserDao.class 4KB loginPetShopServlet.class 3KB PetDAO.class 3KB loginUserServlet.class 3KB loginUserServlet.class 3KB CategoryDAO.class 3KB addCommentServlet.class 3KB CommentDao.class 3KB registerPetShopServlet.class 2KB deleteCommentServlet.class 2KB registerUserServlet.class 2KB registerUserServlet.class 2KB deleteUserServlet.class 2KB deleteUserServlet.class 2KB deleteGoodsServlet.class 2KB UserBean.class 2KB ShopBean.class 2KB UserBean.class 2KB Database.class 2KB deletePetServlet.class 2KB ExitLogin.class 1KB GoodsBean.class 1KB PetBean.class 1KB CommentBean.class 1KB CategoryBean.class 1KB GoodsDao.class 533B UserDao.class 469B ICategoryDAO.class 429B PetShopDao.class 394B IPetDAO.class 393B UserDao.class 379B UserDao.class 379B Comment.class 359B .classpath 699B org.eclipse.wst.common.component 468B org.eclipse.wst.jsdt.ui.superType.container 49B main.css 7KB style.css 7KB addPet.css 2KB showComment.css 2KB changePetShop.css 2KB addPetShop.css 2KB mainListStyles.css 1KB showCategory.css 1KB showUser.css 1KB showPet.css 1KB showPetShop.css 1KB showGoods.css 1KB showAllPetShop.css 1KB loginPetShop.css 766B registerPetShop.css 764B bgstretcher.css 491B
mysql-connector-java-5.1.7-bin.jar 693KB jspsmartupload.jar 12KB IGoodsDao.java 4KB ShopDao.java 3KB IUserDao.java 3KB addPetShopServlet.java 3KB changeUserServlet.java 3KB addUserServlet.java 3KB changePetShopServlet.java 3KB changePetServlet.java 3KB addPetServlet.java 3KB PetDAO.java 3KB CategoryDAO.java 2KB changeGoodsServlet.java 2KB addCategoryServlet.java 2KB addGoodsServlet.java 2KB CommentDao.java 2KB deleteCommentServlet.java 2KB loginPetShopServlet.java 2KB loginUserServlet.java 2KB addCommentServlet.java 2KB registerPetShopServlet.java 2KB registerUserServlet.java 2KB deleteGoodsServlet.java 1KB deleteUserServlet.java 1KB ShopBean.java 1KB UserBean.java 1KB deletePetServlet.java 1KB Database.java 1KB ExitLogin.java 989B GoodsBean.java 983B PetBean.java 862B CommentBean.java 813B共 163 条
- 1
- 2
资源评论
