本文共 6708 字，大约阅读时间需要 22 分钟。

1.框架搭建- ->导包- ->配置web.xml- - >测试数据库- ->测试dao包

2.创建动态标签

3.页面刷新小图标

项目名/WebContent/css/icon.css

//添加一个新的属性$('#tabs').tabs({tools:[{	//图片路径名	iconCls:'icon-arrow-refresh',	handler:function(){		//tab在制定范围找获取选择的选项卡面板。		var tab =$('#tabs').tabs("getSelected");		//判断是否为空		if(tab){			//找到iframe标签			var iframe = $("iframe",tab);			//找iframe里面的src路劲			var src = $(iframe).attr("src");			$(iframe).attr("src",src);		}	}}]});

4.叶节点选项卡

<%@ page language="java" contentType="text/html; charset=utf-8"    pageEncoding="utf-8"%><%@include file="/common/head.jsp"%>
          
      
   
      
       
   
    	
    
     
   
          
       
   
		
    
			
     		
    
    
   
   

5.展示结果

5.后台对学生表的（增删改查），通用分页

----- StudentDao:

package com.zking.test.dao;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 com.zking.test.entity.Student;import com.zking.test.util.DBAccess;import com.zking.test.util.PageBean;import com.zking.test.util.StringUtils;public class StudentDao extends BaseDAO
   
     {Connection conn = null;PreparedStatement stmt = null;ResultSet rs = null;public void addStu(Student student) {	String sql="INSERT INTO student(sid,sname,sage,ssex)VALUES(?,?,?,?)";	try {		conn = DBAccess.getConnection();		stmt = conn.prepareCall(sql);		stmt.setString(1, student.getId());		stmt.setString(2, student.getSname());		stmt.setDate(3, student.getSage());		stmt.setString(4, student.getSsex());		stmt.executeUpdate();	} catch (Exception e) {		throw new RuntimeException(e);	}finally {		DBAccess.close(conn, stmt, rs);	}}public void updeStu(Student student) {	String sql="update student set sname=?,sage=?,ssex=? where sid=?";	try {		conn = DBAccess.getConnection();		stmt = conn.prepareCall(sql);		stmt.setString(1, student.getSname());		stmt.setDate(2, student.getSage());		stmt.setString(3, student.getSsex());		stmt.setString(4, student.getId());		stmt.executeUpdate();	} catch (Exception e) {		throw new RuntimeException(e);	}finally {		DBAccess.close(conn, stmt, rs);	}	}public void deleStu(Student student) {	String sql="delete from student where sid=?";	try {		conn = DBAccess.getConnection();		stmt = conn.prepareCall(sql);		stmt.setString(1, student.getId());		stmt.executeUpdate();	} catch (Exception e) {		throw new RuntimeException(e);	}finally {		DBAccess.close(conn, stmt, rs);	}}public Student Student(Student student) {	Student s=null;		String sql="select * from  student where sid=?";	try {		conn = DBAccess.getConnection();		stmt = conn.prepareCall(sql);		stmt.setString(1, student.getId());		rs = stmt.executeQuery();		if(rs.next()) {			s=new Student();			s.setId(rs.getString(1));			s.setSname(rs.getString(2));			s.setSage(rs.getDate(3));			s.setSsex(rs.getString(4));		}		return s;	} catch (Exception e) {		throw new RuntimeException(e);	}finally {		DBAccess.close(conn, stmt, rs);	}	}public List
    
      listStu(Student student,PageBean pageBean) {	String sql="select * from  student where 1=1";	if(StringUtils.isNotBlank(student.getSname())) {		sql += " and sname like '%" + student.getSname().trim() + "%'";	}	sql+=" order by sid";	return this.executeQuery(sql, pageBean, new Callback
     
      () {				@Override		public List
      
        foreach(ResultSet rs)				throws SQLException {			List
       
         list =new ArrayList
        
         (); Student s= null; while(rs.next()) { s=new Student(); s.setId(rs.getString("sid")); s.setSname(rs.getString("sname")); s.setSage(rs.getDate("sage")); s.setSsex(rs.getString("ssex")); list.add(s); } return list; } }); }}
        
       
      
     
    
   

------ StudentDaoTest:

package com.zking.test.dao;import static org.junit.Assert.*;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Date;import java.util.List;import org.junit.Before;import org.junit.Test;import com.zking.test.entity.Student;import com.zking.test.util.PageBean;public class StudentDaoTest {		public Student student;		public StudentDao studentdao = new StudentDao();		@Before	public void brfore() {		student = new Student();	}//	@Test//	public void add() throws Exception {//		//		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");//		String sj = "2000-02-26";//		//uiltdate时间//		Date d= sdf.parse(sj);//		//long的时分秒//		long l= d.getTime();//		//转换为sql时间//		java.sql.Date sd = new java.sql.Date(l);//		//		student.setId("14");//		student.setSname("大神");//		student.setSage(sd);//		student.setSsex("女");	//		//		//		studentdao.addStu(student);//	}//	@Test//	public void upde() throws Exception {//		//		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");//		String sj = "2000-05-26";//		//uiltdate时间//		Date d= sdf.parse(sj);//		//long的时分秒//		long l= d.getTime();//		//转换为sql时间//		java.sql.Date sd = new java.sql.Date(l);//		//		student.setSname("大神2");//		student.setSage(sd);//		student.setSsex("男");	//		student.setId("14");//		//		//		studentdao.updeStu(student);//	}//	@Test//	public void dele() throws Exception {//		student.setId("14");//		//		studentdao.updeStu(student);//	}//	//	@Test//	public void student() throws Exception {//		student.setId("14");//		//		//		studentdao.Student(student);//	}	@Test	public void likelist() throws Exception {		PageBean pageBean = new PageBean();		pageBean.setPage(1);		pageBean.setRows(5);		List
   
     list = studentdao.listStu(student, pageBean);	for(Student s : list) {		System.out.println(s);	}	}}
   

6.课外知识:数据库空值默认值0转换为null;

----- util/BeanUtilsListener

package com.zking.test.util;

import java.math.BigDecimal;

import javax.servlet.ServletContextEvent;

import javax.servlet.ServletContextListener;

import org.apache.commons.beanutils.ConvertUtils;

import org.apache.commons.beanutils.converters.BigDecimalConverter; import org.apache.commons.beanutils.converters.DoubleConverter; import org.apache.commons.beanutils.converters.FloatConverter; import org.apache.commons.beanutils.converters.IntegerConverter; import org.apache.commons.beanutils.converters.LongConverter; import org.apache.commons.beanutils.converters.ShortConverter;

public class BeanUtilsListener implements ServletContextListener {

//解决在数据库空值默认值0转换为null;@Overridepublic void contextDestroyed(ServletContextEvent arg0) {}@Overridepublic void contextInitialized(ServletContextEvent arg0) {	System.out.println("BeanUtilsListener contextInitialized");	ConvertUtils.register(new IntegerConverter(null), Integer.class);	ConvertUtils.register(new FloatConverter(null), Float.class);	ConvertUtils.register(new DoubleConverter(null), Double.class);	ConvertUtils.register(new LongConverter(null), Long.class);	ConvertUtils.register(new BigDecimalConverter(null), BigDecimal.class);}

}

转载地址：https://blog.csdn.net/weixin_45067120/article/details/104544240 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！