《网上书店信息管理系统的设计与实现》 第16页 共34页 +
\
public ArrayList getSellerOrder(){
ArrayList list = new ArrayList(); conn = Connect.getConnection(); try {
statement = conn.createStatement();
String sql = \
resultSet = statement.executeQuery(sql); while(resultSet.next()){ }
Order order = new Order(); Goods goods = new Goods(); Seller seller = new Seller();
order.setId(resultSet.getInt(\order.setNum(resultSet.getInt(\order.setGoods_id(resultSet.getInt(\order.setBuyer_id(resultSet.getString(\goods.setId(resultSet.getInt(\goods.setPrice(resultSet.getShort(\goods.setPrice(resultSet.getInt(\goods.setDiscount(resultSet.getInt(\goods.setName(resultSet.getString(\seller.setName(resultSet.getString(\seller.setAddress(resultSet.getString(\order.setSeller(seller); order.setGoods(goods);
list.add(order);
} catch (SQLException e) {
《网上书店信息管理系统的设计与实现》 第17页 共34页 }
package com.shoeShop.dao;
import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;
import com.shoeShop.db.Connect;
}
public static void main(String[] args) { }
OrderDao dao = new OrderDao(); dao.getOrder();
// TODO Auto-generated catch block e.printStackTrace();
}finally{ } return list;
try {
resultSet.close(); statement.close(); conn.close();
} catch (SQLException e) { }
// TODO Auto-generated catch block e.printStackTrace();
《网上书店信息管理系统的设计与实现》 第18页 共34页 import com.shoeShop.entity.Seller;
public class SellerDao {
private static Connection conn; private static Statement statement; private static ResultSet resultSet; //插入数据，用于注册
public int insertSeller(Seller seller){
int flag = 0;
conn = Connect.getConnection(); try {
statement = conn.createStatement(); String
sql
=
\
into
seller
values('\
}
//通过用户名和密码查询，用于登录
public static Seller getSeller(String name,String pwd){
conn = Connect.getConnection(); Seller seller = new Seller(); try {
statement = conn.createStatement();
flag = statement.executeUpdate(sql); statement.close(); conn.close();
} catch (SQLException e) { }
// TODO Auto-generated catch block e.printStackTrace();
return flag;
《网上书店信息管理系统的设计与实现》 第19页 共34页
String sql = \* from seller where seller_id='\and pwd =
'\ // // // // // // // }
public static void main(String[] args) { }
SellerDao dao = new SellerDao();
System.out.println(dao.getSeller(\蒋斌\Seller seller = new Seller(); seller.setId(\
seller.setName(\长理专卖\seller.setPwd(\seller.setAddress(\湖南长沙\dao.insertSeller(seller); }
resultSet = statement.executeQuery(sql); while(resultSet.next()){ }
resultSet.close(); statement.close(); conn.close();
seller.setId(resultSet.getString(\seller.setName(resultSet.getString(\seller.setPwd(resultSet.getString(\seller.setAddress(resultSet.getString(\
} catch (SQLException e) { }
// TODO Auto-generated catch block e.printStackTrace();
return seller;
《网上书店信息管理系统的设计与实现》 第20页 共34页
package com.shoeShop.entity; /**
*功能：商家实体类 * @author：蒋斌 *2012-9-19下午4:17:40 */
public class Buyer {
private String id; private String name;