首先大家先看一下我的思维导图,理解一下思路
首先创建好数据库表(脚本)
create table goods ( gid int primary key, --商品编号 gname varchar2(30) not null, --商品名称 gprice number default(0) not null, --商品单价 ginfo varchar2(1000), --商品描述信息 gface varchar2 (100) --商品图片路径 ) select * from Goods commit insert into goods values(1,'mp31',100,'mp31','images/1.jpg') ; insert into goods values(2,'mp32',1200,'mp32','images/2.jpg') ; insert into goods values(3,'mp33',100,'mp33','images/3.jpg') ; insert into goods values(4,'mp34',1600,'mp34','images/4.jpg') ; insert into goods values(5,'mp35',1500,'mp35','images/5.jpg') ; insert into goods values(6,'mp36',1400,'mp36','images/6.jpg') ; insert into goods values(7,'mp37',1700,'mp37','images/7.jpg') ; insert into goods values(8,'mp38',1300,'mp38','images/8.jpg') ; insert into goods values(9,'mp39',1500,'mp39','images/9.jpg') ; insert into goods values(10,'mp310',1600,'mp310','images/10.jpg') ; insert into goods values(11,'mp311',1600,'mp311','images/11.jpg');
再创建好需要的包和类
我们需要创建util包中的DBHelper类,dao包中的GoodsDao类,entity包中的Goods,OrderItem,因为这个为session版本,所有订单不需要连接数据库,也就不需要dao类
DBHelper类:
user:用户名
upwd:密码
导包语句:jdbc:oracle:thin:@localhost:1521:数据库名
package com.zking.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DBHelper {
private static String cname = "oracle.jdbc.driver.OracleDriver";
private static String user = "scott";
private static String upwd = "tiger";
private static String url = "jdbc:oracle:thin:@localhost:1521:T277";
//注册驱动类
static {
try {
Class.forName(cname);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//连接数据库
/**
* 连接数据库
* @return
*/
public static Connection getCon() {
Connection con = null;
try {
con = DriverManager.getConnection(url, user, upwd);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
/**
* 关闭连接
* @param con
* @param ps
* @param rs
*/
public static void closeDb(Connection con,PreparedStatement ps,ResultSet rs) {
try {
if(con!=null) {
con.close();
}
if(ps!=null) {
ps.close();
}
if(rs!=null) {
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
实体类:Goods
gid:商品编号
gname:商品名称
gprice:商品价格