一、创建DBHelper
创建src然后在src的内部创建依次创建dao,model,servie,servlet,util几个包然后再在util内部创建DBHerpr
在内部写上下面这些代码用来连接数据库和关闭服务
private static final String URL="jdbc:oracle:thin:@localhost:1521:orcl";
private static final String CNAME="oracle.jdbc.driver.OracleDriver";
//只有在类被加载到内存中的时候,执行一次
static {
try {
Class.forName(CNAME);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getCon() {
Connection con=null;
try {
con=DriverManager.getConnection(URL, "scott", "tiger");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void myClose(Connection con,PreparedStatement ps,ResultSet rs) {
try {
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
二、在数据库创建表
可用代码建可用鼠标建立
鼠标建立
代码建立
CREATE TABLE t_module (
id integer DEFAULT NULL,
pid integer DEFAULT NULL,
text VARCHAR(150) DEFAULT NULL,
icon VARCHAR(90) DEFAULT NULL,
url VARCHAR(180) DEFAULT NULL,
sort integer DEFAULT NULL
);INSERT INTO t_module VALUES (20, -1, '订单管理', NULL, '', 2);
INSERT INTO t_module VALUES (2001, 20, '订单管理', NULL, '/orderList.jsp', 6);
INSERT INTO t_module VALUES (2002, 20, '订单统计', NULL, '/orderStatistics.jsp', 7);
INSERT INTO t_module VALUES (21, -1, '系统管理', NULL, '', 3);
INSERT INTO t_module VALUES (2101, 21, '用户管理', NULL, 'jsp/system/userManage.jsp', 8);
INSERT INTO t_module VALUES (2102, 21, '权限管理', NULL, 'jsp/system/authManage.jsp', 10);
INSERT INTO t_module VALUES (2103, 21, '字典管理', NULL, '/dictList.jsp', 11);
INSERT INTO t_module VALUES (22, -1, '书本管理', NULL, '', 1);
INSERT INTO t_module VALUES (2201, 22, '新增书本', NULL, 'jsp/book/addBook.jsp', 4);
INSERT INTO t_module VALUES (2202, 22, '书本管理', NULL, 'jsp/book/bookList.jsp', 5);
三、创建一个实体类
private Integer id;//null
private Integer pid;
private String text;
private String icon;
private String url;
private int sort;
private List<Module> children = new ArrayList<Module>();
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getPid() {
return pid;
}
public void setPid(Integer pid) {
this.pid = pid;
}
public String getText() {
return text;
}
public void setText(String text) {
this.text = text;
}
public String getIcon() {
return icon;
}
public void setIcon(String icon) {
this.icon = icon;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public int getSort() {
return sort;
}
public void setSort(int sort) {
this.sort = sort;
}
public List<Module> getChildren() {
return children;
}
public void setChildren(List<Module> children) {
this.children = children;
}
四.创建一个接口和一个普通类(数据库访问层)
modeldao记得要继承IModeldao
在接口内写一个 List<Model > listModel(int pid);
五.创建一个接口和一个普通类(biz用来调用数据库访问层)
在接口内写一个 List<Model > listModel(int pid);然后就是modelservice部分
private com.zking.dao.IModuleDao dao = new com.zking.dao.ModuleDao();
@Override
public List<Module> listModel(int pid) {
List<Module> list = dao.listModel(pid);
for(Module m: list) {
if(m.getUrl() == null || "".equals(m.getUrl().trim())) {
m.setChildren(listModel(m.getId()));
}
}
return list;
}
public static void main(String[] args) {
IModuleService service = new ModuleService();
List<Module> list = service.listModel(-1);
list.forEach(t->System.out.println(t));
}
六.写一个实现类(业务逻辑层)
@WebServlet("/moduleServlet")
public class ModelServlet extends HttpServlet {
private IModuleService service = new ModuleService();
public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
doPost(req, resp);
}
public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("application/json; charset=utf-8");
List<Module> list = service.listModel(-1);
PrintWriter out = resp.getWriter();
//将list对象转换为JSON格式
String str = JSON.toJSONString(list);
out.write(str);
out.flush();
out.close();
}
}
最后回到index界面(效果展示界面)将url:ctx+后面的改成你写的业务逻辑层即可‘/modelservlet’
调与被调的关系要理清