使用maven搭建Hibernate
使用maven搭建Hibernate框架(web项目)
1 create table USERS 2 ( 3 ID NUMBER not null primary key, 4 NAME VARCHAR2(50), 5 PASSWORD VARCHAR2(50), 6 TELEPHONE VARCHAR2(15), 7 USERNAME VARCHAR2(50), 8 ISADMIN VARCHAR2(5) 9 ); 10 create table DISTRICT 11 ( 12 ID NUMBER not null primary key, 13 NAME VARCHAR2(50) not null 14 ); 15 create table HOUSE 16 ( 17 ID NUMBER, 18 USER_ID NUMBER, 19 TYPE_ID NUMBER, 20 TITLE NVARCHAR2(50), 21 DESCRIPTION NVARCHAR2(2000), 22 PRICE NUMBER, 23 PUBDATE DATE, 24 FLOORAGE NUMBER, 25 CONTACT VARCHAR2(100), 26 STREET_ID NUMBER 27 ); 28 29 create table STREET 30 ( 31 ID NUMBER not null primary key, 32 NAME VARCHAR2(50), 33 DISTRICT_ID NUMBER 34 ); 35 create table TYPE 36 ( 37 ID NUMBER not null primary key, 38 NAME VARCHAR2(12) not null 39 ); 40 --主外键关系 41 ALTER TABLE HOUSE ADD CONSTRAINT fk_HOUSE_STREET FOREIGN KEY(STREET_ID) REFERENCES STREET (ID); 42 ALTER TABLE HOUSE ADD CONSTRAINT fk_HOUSE_TYPE FOREIGN KEY(TYPE_ID) REFERENCES TYPE (ID); 43 ALTER TABLE HOUSE ADD CONSTRAINT fk_HOUSE_USERS FOREIGN KEY(USER_ID) REFERENCES USERS (ID) ; 44 ALTER TABLE STREET ADD CONSTRAINT fk_DISTRICT_STREET FOREIGN KEY(DISTRICT_ID) REFERENCES DISTRICT(ID); 45 --DISTRICT 46 insert into DISTRICT (ID, NAME) 47 values (1001, '东城'); 48 insert into DISTRICT (ID, NAME) 49 values (1002, '西城'); 50 insert into DISTRICT (ID, NAME) 51 values (1003, '石景山'); 52 insert into DISTRICT (ID, NAME) 53 values (1006, '朝阳'); 54 insert into DISTRICT (ID, NAME) 55 values (1000, '丰台'); 56 insert into DISTRICT (ID, NAME) 57 values (1004, '海淀'); 58 commit; 59 --STREET 60 insert into STREET (ID, NAME, DISTRICT_ID) 61 values (1000, '知春路', 1004); 62 insert into STREET (ID, NAME, DISTRICT_ID) 63 values (1001, '中关村大街', 1004); 64 insert into STREET (ID, NAME, DISTRICT_ID) 65 values (1002, '学院路', 1004); 66 insert into STREET (ID, NAME, DISTRICT_ID) 67 values (1003, '朝阳路', 1006); 68 commit; 69 --USERS 70 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1001,'zhangsan','1234','13267089839','张三','是'); 71 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1002,'lisi','1234','13267034439','李四','否'); 72 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1003,'wangxin','1234','13848879541','王鑫','是'); 73 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1004,'zhangjian','1234','13846972541','张建','否'); 74 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1005,'lijian','1234','13247965251','李健','是'); 75 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1006,'jiangyiran','1234','13445697214','蒋以然','否'); 76 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1007,'wangxiaochao','1234','13598248731','王晓超','否'); 77 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1008,'zhangdongxue','1234','13869732519','张冬雪','否'); 78 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1009,'sunpeng','1234','13299358331','孙鹏'); 79 INSERT INTO USERS(ID,NAME,PASSWORD,TELEPHONE,USERNAME,ISADMIN) VALUES(1010,'jianglianchang','1234','13846937982','蒋连昌','否'); 80 commit; 81 --TYPE 82 insert into TYPE (ID, NAME) 83 values (1000, '一室一厅'); 84 insert into TYPE (ID, NAME) 85 values (1001, '一室两厅'); 86 insert into TYPE (ID, NAME) 87 values (1002, '两室一厅'); 88 insert into TYPE (ID, NAME) 89 values (1003, '两室两厅'); 90 insert into TYPE (ID, NAME) 91 values (1004, '三室一厅'); 92 insert into TYPE (ID, NAME) 93 values (1005, '三室两厅'); 94 insert into TYPE (ID, NAME) 95 values (1006, '四室一厅'); 96 insert into TYPE (ID, NAME) 97 values (1007, '四室两厅'); 98 insert into TYPE (ID, NAME) 99 values (1008, '四十三厅'); 100 commit; 101 --HOUSE 102 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 103 VALUES(1,1001,1002,'中关村','中关村一条街',2600,to_date('2014-02-14','yyyy-mm-dd'),100,'张三',1000); 104 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 105 VALUES(2,1002,1003,'苏州街','苏州街一条街',3600,to_date('2009-1-3','yyyy-mm-dd'),100,'李四',1001); 106 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 107 VALUES(3,1003,1004,'万泉庄','万泉庄一条街',4600,to_date('2009-1-4','yyyy-mm-dd'),130,'王鑫',1002); 108 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 109 VALUES(1,1003,1002,'万泉庄附近','万泉庄附近一条街',1500,to_date('2009-7-2','yyyy-mm-dd'),125,'张建',1003); 110 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 111 VALUES(1,1005,1002,'东单','东单很多美食',2700,to_date('2009-9-2','yyyy-mm-dd'),140,'蒋以然',1001); 112 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 113 VALUES(3,1001,1002,'中关村','中关村电脑城',2600,to_date('2009-4-1','yyyy-mm-dd'),137,'王晓超',1003); 114 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 115 VALUES(4,1004,1001,'东四','东四一条街',2000,to_date('2009-4-2','yyyy-mm-dd'),200,'王晓超',1002); 116 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 117 VALUES(5,1006,1003,'西四','西四一条街',3600,to_date('2009-1-2','yyyy-mm-dd'),210,'张冬雪',1003); 118 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 119 VALUES(5,1007,1002,'西单','西单购物城',3600,to_date('2009-4-2','yyyy-mm-dd'),240,'孙鹏',1001); 120 INSERT INTO HOUSE(ID,USER_ID,TYPE_ID,TITLE,DESCRIPTION,PRICE,PUBDATE,FLOORAGE,CONTACT,STREET_ID) 121 VALUES(6,1002,1002,'苏州街','苏州街美食',2600,to_date('2009-2-2','yyyy-mm-dd'),260,'蒋连昌',1000); 122 commit;
create.sql
第一步：打开idea
第二步：创建maven项目
第三步：创建项目名称
第四步：创建完成之后，选中src点击右键选择Directory创建java文件夹
第五步：选中java点击右键，选中 Mark Diectory as 选择Sources Root
第六步：选中main点击右键Directory创建resources文件夹
第七步：选中resources点击右键，选中 Mark Diectory as 选择Sources Root
第八步：点击 File — Project Structure —Facets，点击 “+” 选中hibernate
第九步:IDEA连接Oracle数据
1 <?xml version="1.0" encoding="UTF-8"?> 2 3 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 5 <modelVersion>4.0.0</modelVersion> 6 7 <groupId>com.bdqn</groupId> 8 <artifactId>Hid03</artifactId> 9 <version>1.0-SNAPSHOT</version> 10 <packaging>war</packaging> 11 12 <name>Hid03 Maven Webapp</name> 13 <!-- FIXME change it to the project's website --> 14 <url>http://www.example.com</url> 15 16 <properties> 17 <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> 18 <maven.compiler.source>1.7</maven.compiler.source> 19 <maven.compiler.target>1.7</maven.compiler.target> 20 </properties> 21 22 <dependencies> 23 <dependency> 24 <groupId>junit</groupId> 25 <artifactId>junit</artifactId> 26 <version>4.11</version> 27 <scope>test</scope> 28 </dependency> 29 30 <dependency> 31 <groupId>org.hibernate</groupId> 32 <artifactId>hibernate-core</artifactId> 33 <version>4.0.0.Final</version> 34 </dependency> 35 36 <dependency> 37 <groupId>com.oracle</groupId> 38 <artifactId>ojdbc6</artifactId> 39 <version>10.2.0.1.0</version> 40 </dependency> 41 <dependency> 42 <groupId>javax.servlet</groupId> 43 <artifactId>jstl</artifactId> 44 <version>1.2</version> 45 </dependency> 46 47 <dependency> 48 <groupId>javax.servlet</groupId> 49 <artifactId>javax.servlet-api</artifactId> 50 <version>3.0.1</version> 51 <scope>provided</scope> 52 </dependency> 53 54 <dependency> 55 <groupId>com.fasterxml.jackson.core</groupId> 56 <artifactId>jackson-databind</artifactId> 57 <version>2.8.3</version> 58 </dependency> 59 <dependency> 60 <groupId>org.apache.taglibs</groupId> 61 <artifactId>taglibs-standard-impl</artifactId> 62 <version>1.2.5</version> 63 </dependency> 64 </dependencies> 65 66 67 </project>
pom.xml
1 <?xml version='1.0' encoding='utf-8'?> 2 <!DOCTYPE hibernate-configuration PUBLIC 3 "-//Hibernate/Hibernate Configuration DTD//EN" 4 "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> 5 <hibernate-configuration> 6 <session-factory> 7 <property name="connection.driver_class">oracle.jdbc.OracleDriver</property> <!--Oracle 数据驱动--> 8 <property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:orcl</property> <!--数据库路径--> 9 <property name="connection.username">OT</property> 10 <property name="connection.password">1234</property> 11 <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property><!--数据库方言--> 12 <property name="show_sql">true</property><!--生成的sql语句--> 13 <property name="format_sql">true</property><!--sql格式化--> 14 <mapping resource="mapping/User.hbm.xml"/> 15 </session-factory> 16 </hibernate-configuration>
hibernate.cfg.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" > 3 <hibernate-mapping> 4 <class name="com.bdqn.entity.Users" table="Users"> 5 <id name="id" type="java.lang.Integer" column="id"> 6 <generator class="increment"/> 7 </id> 8 <property name="name" type="java.lang.String" column="NAME"/> 9 <property name="password" type="java.lang.String" column="PASSWORD"/> 10 <property name="telephone" type="java.lang.String" column="TELEPHONE"/> 11 <property name="username" type="java.lang.String" column="USERNAME"/> 12 <property name="isadmin" type="java.lang.String" column="ISADMIN"/> 13 14 </class> 15 </hibernate-mapping>
User.hbm.xml
dao层
1 package com.bdqn.dao; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.page.Page; 5 import java.util.List; 6 7 public interface UserDao { 8 /** 9 * 1.根据用户名和密码查询 10 * 11 * @param sname 12 * @param password 13 * @return 14 */ 15 Users findByNameAndPwd(String sname, String password); 16 17 /** 18 * 2.延时加载:查询所有 19 * 20 * @return 21 */ 22 List<Users> findAll(); 23 24 /** 25 * 3.保存 26 * 27 * @param stu 28 * @return 29 */ 30 int save(Users stu); 31 32 /** 33 * 4.根据主键id查询单条 34 * 35 * @param sid 36 * @return 37 */ 38 Users findById(Integer sid); 39 40 /** 41 * 5.修改 42 */ 43 int update(Users stu); 44 45 /** 46 * 6.删除对象 47 * 48 * @param stu 49 * @return 50 */ 51 int delete(Users stu); 52 53 /** 54 * 7.分页查询 55 */ 56 List<Users> findPage(Page page); 57 58 /** 59 * 8.查询总条数 60 */ 61 int getTotalCount(); 62 }
UserDao
1 package com.bdqn.dao.impl; 2 3 import com.bdqn.dao.UserDao; 4 import com.bdqn.entity.Users; 5 import com.bdqn.page.Page; 6 import com.bdqn.util.Hibernate_Util; 7 import org.hibernate.HibernateException; 8 import org.hibernate.Query; 9 import org.hibernate.Session; 10 import java.util.List; 11 12 public class UserDaoImpl implements UserDao { 13 /** 14 * 1.查询所有:立即加载 15 */ 16 public List<Users> findAll() { 17 //1.获取session对象 18 Session session = Hibernate_Util.getSession(); 19 //2.定义hql语句 20 String hql = "from Users"; 21 //3.Session创建Query对象 22 Query query = session.createQuery(hql); 23 //4.query对象执行操作 24 List<Users> it = query.list(); 25 //5.释放资源 26 Hibernate_Util.closeSession(); 27 return it; 28 } 29 30 /** 31 * 2.根据用户名和密码查询 32 */ 33 public Users findByNameAndPwd(String sname, String password) { 34 //1.获取session对象 35 Session session = Hibernate_Util.getSession(); 36 //2.定义hql语句(命名参数) 37 String hql = "from Users where name=:name and password=:password"; 38 //3.Session创建Query对象 39 Query query = session.createQuery(hql); 40 //4.query对象给占位符赋值 41 /*query.setString("sname", sname); 42 query.setString("password", password);*/ 43 query.setParameter("name", sname); 44 query.setParameter("password", password); 45 46 //query.setProperties(user); 47 //5.执行操作(uniqueResult()查询的单行数据) 48 Users stu = (Users) query.uniqueResult(); 49 //6.释放资源 50 Hibernate_Util.closeSession(); 51 return stu; 52 53 } 54 55 56 /** 57 * 根据id主键查询单条 58 */ 59 public Users findById(Integer sid) { 60 //1.获取session对象 61 Session session = Hibernate_Util.getSession(); 62 //2.利用session根据主键查询 63 Users stu = (Users) session.get(Users.class, sid); 64 /*3. 65 * 因为在修改时要提前查询单条,和session关联已经变成持久化对象, 66 * 而在修改时session执行update方法时, 67 * 首先会查询该主键id是否存在, 68 * 如果存在,则根据主键id修改该对象,此时对象已经处于持久化对象, 69 * 而实际session中不能同时存在两个主键id相同的对象, 70 * 否则会出现如下错误: 71 * org.hibernate.NonUniqueObjectException: 72 * a different object with the same identifier 73 * value was already associated with the 74 * session: [com.entity.Student#1] 75 */ 76 Hibernate_Util.closeSession(); 77 // session.clear(); 78 return stu; 79 } 80 81 /** 82 * 删除对象 83 */ 84 public int delete(Users stu) { 85 int num = 1; 86 //1.获取session对象 87 Session session = Hibernate_Util.getSession(); 88 89 try { 90 //session删除操作 91 session.delete(stu); 92 session.beginTransaction().commit(); 93 } catch (HibernateException e) { 94 num = 0; 95 // TODO Auto-generated catch block 96 e.printStackTrace(); 97 } finally { 98 //5.释放资源 99 Hibernate_Util.closeSession(); 100 } 101 102 return num; 103 } 104 105 /** 106 * 添加 107 */ 108 public int save(Users stu) { 109 int num = 1; 110 //1.获取session对象 111 Session session = Hibernate_Util.getSession(); 112 //执行操作 113 try { 114 session.save(stu); 115 session.beginTransaction().commit(); 116 } catch (HibernateException e) { 117 num = 0; 118 e.printStackTrace(); 119 } finally { 120 //5.释放资源 121 Hibernate_Util.closeSession(); 122 } 123 return num; 124 } 125 126 /** 127 * 修改 128 */ 129 public int update(Users stu) { 130 int num = 1; 131 //1.获取session对象 132 Session session = Hibernate_Util.getSession(); 133 try { 134 //执行操作 135 //该对象的主键id必须存在 136 session.update(stu); 137 session.beginTransaction().commit(); 138 } catch (HibernateException e) { 139 num = 0; 140 e.printStackTrace(); 141 } finally { 142 //5.释放资源 143 Hibernate_Util.closeSession(); 144 } 145 return num; 146 } 147 148 /** 149 * 7.分页查询 150 */ 151 public List<Users> findPage(Page page) { 152 //1.获取session 153 Session session = Hibernate_Util.getSession(); 154 155 //2.定义查询最大记录数的hql 156 String hql = "from Users "; 157 158 //3.定义查询最大记录数的Query对象 159 Query querypage = session.createQuery(hql); 160 161 //4.查询最大记录数的数据 162 querypage.setMaxResults(page.getPagesize()); 163 164 //5.确定查询起点 165 querypage.setFirstResult(page.getStartrow()); 166 167 //6.分页查询 168 List<Users> list = querypage.list(); 169 170 //7.关闭session 171 Hibernate_Util.closeSession(); 172 173 return list; 174 } 175 176 /** 177 * 8.查询总条数 178 */ 179 public int getTotalCount() { 180 //1.获取session 181 Session session = Hibernate_Util.getSession(); 182 183 //2.定义查询总条数hql语句 184 String hqlcount = "select count(*) from Users "; 185 186 //3.利用Session创建Query对象 187 Query querycount = session.createQuery(hqlcount); 188 189 //4.获取总条数(返回单行数据uniqueResult()) 190 Integer totalCount = Integer.parseInt(querycount.uniqueResult().toString()); 191 //5.释放资源 192 Hibernate_Util.closeSession(); 193 return totalCount; 194 } 195 }
UserDaoImpl
page层
1 package com.bdqn.page; 2 3 public class Page { 4 private Integer pagesize; //页面大小 5 private Integer pageno; //当前页 6 private Integer startrow; //起始行 7 private Integer totalpage; //总页数 8 private Integer totalcount; //总条数 9 10 11 public Page() { 12 } 13 14 public Page(Integer pageSize, Integer pageNo, Integer totalCount) { 15 this.pagesize = pageSize; //页面大小 16 this.pageno = pageNo; //当前页 17 this.totalcount = totalCount; //计算总条数 18 this.setStartrow(pageNo, pageSize); //计算起始行 19 this.setTotalpage(totalCount, pageSize); //计算总页数 20 } 21 22 public Integer getPagesize() { 23 return pagesize; 24 } 25 26 public void setPagesize(Integer pageSize) { 27 this.pagesize = pageSize; 28 } 29 30 public Integer getPageno() { 31 return pageno; 32 } 33 34 public void setPageno(Integer pageNo) { 35 this.pageno = pageNo; 36 } 37 38 public Integer getStartrow() { 39 return startrow; 40 } 41 42 /** 43 * 计算起始行 44 * 45 * @param pageNo 46 * @param pageSize 47 */ 48 public void setStartrow(Integer pageNo, Integer pageSize) { 49 this.startrow = (pageNo - 1) * pageSize; 50 } 51 52 public Integer getTotalpage() { 53 return totalpage; 54 } 55 56 /** 57 * 计算总页数 58 * 59 * @param totalCount 60 * @param pageSize 61 */ 62 public void setTotalpage(Integer totalCount, Integer pageSize) { 63 this.totalpage = totalCount % pageSize == 0 ? totalCount / pageSize : totalCount / pageSize + 1; 64 } 65 66 public Integer getTotalcount() { 67 return totalcount; 68 } 69 70 public void setTotalCount(Integer totalCount) { 71 this.totalcount = totalCount; 72 } 73 74 @Override 75 public String toString() { 76 return "[{\"pageno\":" + pageno + ",\"pagesize\":" + pagesize 77 + ",\"startrow\":" + startrow + ",\"totalcount\":" + totalcount 78 + ",\"totalpage\":" + totalpage + "}]"; 79 } 80 }
Page
service层
1 package com.bdqn.service; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.page.Page; 5 6 import java.util.List; 7 8 public interface UserService { 9 /** 10 * 1.登录的业务 11 * 12 * @param sname 13 * @param password 14 * @return 15 */ 16 Users login(String sname, String password); 17 18 /** 19 * 2.注册 20 * 21 * @param stu 22 * @return 23 */ 24 int register(Users stu); 25 26 /** 27 * 3.查询所有 28 */ 29 List<Users> findAll(); 30 31 /** 32 * 4.根据主键id查询 33 * 34 * @param sid 35 * @return 36 */ 37 Users findById(Integer sid); 38 39 /** 40 * 5.修改 41 */ 42 int update(Users stu); 43 44 /** 45 * 6.删除 46 */ 47 int delete(Users stu); 48 49 /** 50 * 7.分页查询 51 */ 52 List<Users> findPage(Page page); 53 54 /** 55 * 8.查询总条数 56 */ 57 int getTotalCount(); 58 59 }
UserService
1 package com.bdqn.service.impl; 2 3 import com.bdqn.dao.UserDao; 4 import com.bdqn.dao.impl.UserDaoImpl; 5 import com.bdqn.entity.Users; 6 import com.bdqn.page.Page; 7 import com.bdqn.service.UserService; 8 9 import java.util.List; 10 11 public class UserServiceImpl implements UserService { 12 /** 13 * 使用多态引用数据访问层对象 14 */ 15 private UserDao dao = new UserDaoImpl(); 16 17 /** 18 * 登录 19 */ 20 public Users login(String sname, String password) { 21 return dao.findByNameAndPwd(sname, password); 22 } 23 24 public int delete(Users stu) { 25 // TODO Auto-generated method stub 26 return dao.delete(stu); 27 } 28 29 public List<Users> findAll() { 30 // TODO Auto-generated method stub 31 return dao.findAll(); 32 } 33 34 public Users findById(Integer sid) { 35 // TODO Auto-generated method stub 36 return dao.findById(sid); 37 } 38 39 public int register(Users stu) { 40 // TODO Auto-generated method stub 41 return dao.save(stu); 42 } 43 44 public int update(Users stu) { 45 // TODO Auto-generated method stub 46 return dao.update(stu); 47 } 48 49 public List<Users> findPage(Page page) { 50 // TODO Auto-generated method stub 51 return dao.findPage(page); 52 } 53 54 public int getTotalCount() { 55 // TODO Auto-generated method stub 56 return dao.getTotalCount(); 57 } 58 59 }
UserServiceImpl
servlet层
实现删除功能
1 package com.bdqn.servlet; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.service.UserService; 5 import com.bdqn.service.impl.UserServiceImpl; 6 7 import javax.servlet.ServletException; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest; 10 import javax.servlet.http.HttpServletResponse; 11 import java.io.IOException; 12 13 public class DeleteSerlvet extends HttpServlet { 14 public void doGet(HttpServletRequest request, HttpServletResponse response) 15 throws ServletException, IOException { 16 17 this.doPost(request, response); 18 } 19 20 public void doPost(HttpServletRequest request, HttpServletResponse response) 21 throws ServletException, IOException { 22 request.setCharacterEncoding("UTF-8"); 23 response.setCharacterEncoding("UTF-8"); 24 response.setContentType("text/html;charset=UTF-8"); 25 26 // 2.接受参数 27 Integer sid=Integer.valueOf(request.getParameter("id")); 28 // 3.业务处理 29 UserService service = new UserServiceImpl(); 30 Users stu=service.findById(sid); 31 if (stu != null) { 32 System.out.println("根据id查询成功"); 33 int num=service.delete(stu); 34 if(num>0){ 35 System.out.println("delete success!!"); 36 // 4.页面跳转 37 response.sendRedirect("FindAllServlet"); 38 39 }else{ 40 System.out.println("delete success!!"); 41 42 } 43 } else { 44 System.out.println("根据id查询失败!"); 45 46 } 47 48 } 49 50 }
DeleteSerlvet
实现统计总记录数功能
1 package com.bdqn.servlet; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.page.Page; 5 import com.bdqn.service.UserService; 6 import com.bdqn.service.impl.UserServiceImpl; 7 8 import javax.servlet.ServletException; 9 import javax.servlet.http.HttpServlet; 10 import javax.servlet.http.HttpServletRequest; 11 import javax.servlet.http.HttpServletResponse; 12 import java.io.IOException; 13 import java.io.PrintWriter; 14 import java.util.List; 15 16 17 public class FindAllServlet extends HttpServlet { 18 public void doGet(HttpServletRequest request, HttpServletResponse response) 19 throws ServletException, IOException { 20 21 this.doPost(request, response); 22 } 23 24 25 public void doPost(HttpServletRequest request, HttpServletResponse response) 26 throws ServletException, IOException { 27 request.setCharacterEncoding("UTF-8"); 28 response.setCharacterEncoding("UTF-8"); 29 response.setContentType("text/html;charset=UTF-8"); 30 31 /** 32 * ☆ 33 * 在使用ajax往前台通过输出流对象的print方法发送json时 34 * 该行获取输出流对象的代码必须放在 35 * response.setContentType("text/html;charset=UTF-8"); 36 * 之后,否则ajax回调时,页面拿到的中文数据就永远都是乱码, 37 * 原因是:如果将改行代码写在处理客户端乱码之前,表示编码格式已经确定, 38 * 所以,编码格式的处理应该放在获取PrintWriter对象之前 39 * 40 */ 41 PrintWriter out = response.getWriter(); 42 43 44 // 2.接受参数 45 String no = request.getParameter("pageNo"); 46 47 48 // 3.业务处理 49 UserService service = new UserServiceImpl(); 50 51 int pageSize = 3; //页面大小 52 int pageNo = 1; //默认的pageNo为1 53 if (no != null && no != "") { 54 pageNo = Integer.valueOf(no); 55 } 56 //获取总条数 57 int totalCount = service.getTotalCount(); 58 Page page = new Page(pageSize, pageNo, totalCount); 59 60 List<Users> list = service.findPage(page); 61 if (list != null) { 62 System.out.println("find All page success"); 63 request.setAttribute("list", list); 64 request.setAttribute("page", page); 65 request.getRequestDispatcher("index.jsp").forward(request, response); 66 } else { 67 System.out.println("find All page fail!"); 68 69 70 } 71 72 } 73 }
FindAllServlet
实现根据条件查询功能
1 package com.bdqn.servlet; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.service.UserService; 5 import com.bdqn.service.impl.UserServiceImpl; 6 7 import javax.servlet.ServletException; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest; 10 import javax.servlet.http.HttpServletResponse; 11 import java.io.IOException; 12 13 14 public class FindByIdSerlvet extends HttpServlet { 15 public void doGet(HttpServletRequest request, HttpServletResponse response) 16 throws ServletException, IOException { 17 18 this.doPost(request, response); 19 } 20 21 public void doPost(HttpServletRequest request, HttpServletResponse response) 22 throws ServletException, IOException { 23 request.setCharacterEncoding("UTF-8"); 24 response.setCharacterEncoding("UTF-8"); 25 response.setContentType("text/html;charset=UTF-8"); 26 27 // 2.接受参数 28 Integer sid=Integer.valueOf(request.getParameter("id")); 29 30 // 3.业务处理 31 UserService service = new UserServiceImpl(); 32 33 Users stu=service.findById(sid); 34 System.out.println("stu:"+stu); 35 if(stu!=null){ 36 System.out.println("根据id查询到对象"); 37 request.setAttribute("stu", stu); 38 request.getRequestDispatcher("update.jsp").forward(request, response); 39 }else{ 40 System.out.println("没有根据id查询到对象"); 41 } 42 43 } 44 }
FindByIdSerlvet
实现分页功能
1 package com.bdqn.servlet; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.page.Page; 5 import com.bdqn.service.UserService; 6 import com.bdqn.service.impl.UserServiceImpl; 7 import com.fasterxml.jackson.databind.ObjectMapper; 8 9 import javax.servlet.ServletException; 10 import javax.servlet.http.HttpServlet; 11 import javax.servlet.http.HttpServletRequest; 12 import javax.servlet.http.HttpServletResponse; 13 import java.io.IOException; 14 import java.io.PrintWriter; 15 import java.util.List; 16 17 18 public class FindPageServlet extends HttpServlet { 19 20 public void doGet(HttpServletRequest request, HttpServletResponse response) 21 throws ServletException, IOException { 22 23 this.doPost(request, response); 24 } 25 26 public void doPost(HttpServletRequest request, HttpServletResponse response) 27 throws ServletException, IOException { 28 response.setContentType("text/html;charset=UTF-8"); 29 request.setCharacterEncoding("UTF-8"); 30 response.setCharacterEncoding("UTF-8"); 31 /** 32 * ☆ 33 * 在使用ajax往前台通过输出流对象的print方法发送json时 34 * 该行获取输出流对象的代码必须放在 35 * response.setContentType("text/html;charset=UTF-8"); 36 * 之后,否则ajax回调时,页面拿到的中文数据就永远都是乱码, 37 * 原因是:如果将改行代码写在处理客户端乱码之前,表示编码格式已经确定, 38 * 所以,编码格式的处理应该放在获取PrintWriter对象之前 39 * 40 */ 41 PrintWriter out=response.getWriter(); 42 43 44 // 2.接受参数 45 String no=request.getParameter("pageNo"); 46 47 48 // 3.业务处理 49 UserService service = new UserServiceImpl(); 50 51 int pageSize=3; //页面大小 52 int pageNo=1; //默认的pageNo为1 53 if(no!=null && no!=""){ 54 pageNo=Integer.valueOf(no); 55 } 56 //获取总条数 57 int totalCount=service.getTotalCount(); 58 //封装分页所需字段 59 Page page=new Page(pageSize, pageNo, totalCount); 60 //分页查询 61 List<Users> list = service.findPage(page); 62 63 ObjectMapper om=new ObjectMapper(); 64 String str=om.writeValueAsString(list); 65 String pagestr=om.writeValueAsString(page); 66 str="{\"page\":"+pagestr+",\"list\":"+str+"}"; 67 System.out.println(str); 68 69 out.print(str); 70 71 72 } 73 }
FindPageServlet
实现登录功能
1 package com.bdqn.servlet; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.service.UserService; 5 import com.bdqn.service.impl.UserServiceImpl; 6 7 import javax.servlet.ServletException; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest; 10 import javax.servlet.http.HttpServletResponse; 11 import java.io.IOException; 12 13 public class LoginServlet extends HttpServlet { 14 public void doGet(HttpServletRequest request, HttpServletResponse response) 15 throws ServletException, IOException { 16 17 this.doPost(request, response); 18 } 19 20 21 public void doPost(HttpServletRequest request, HttpServletResponse response) 22 throws ServletException, IOException { 23 request.setCharacterEncoding("UTF-8"); 24 response.setCharacterEncoding("UTF-8"); 25 response.setContentType("text/html;charset=UTF-8"); 26 27 //2.接受参数 28 String name = request.getParameter("name"); 29 String password = request.getParameter("password"); 30 //3.业务处理 31 UserService service = new UserServiceImpl(); 32 Users stu = service.login(name, password); 33 if (stu != null) { 34 System.out.println("login success!"); 35 //4.页面跳转 36 request.getSession().setAttribute("name", name); 37 response.sendRedirect("FindAllServlet"); 38 } else { 39 System.out.println("login fail!"); 40 41 } 42 43 } 44 }
LoginServlet
实现添加功能
1 package com.bdqn.servlet; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.service.UserService; 5 import com.bdqn.service.impl.UserServiceImpl; 6 7 import javax.servlet.ServletException; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest; 10 import javax.servlet.http.HttpServletResponse; 11 import java.io.IOException; 12 13 14 public class RegisterServlet extends HttpServlet { 15 public void doGet(HttpServletRequest request, HttpServletResponse response) 16 throws ServletException, IOException { 17 18 this.doPost(request, response); 19 } 20 21 public void doPost(HttpServletRequest request, HttpServletResponse response) 22 throws ServletException, IOException { 23 request.setCharacterEncoding("UTF-8"); 24 response.setCharacterEncoding("UTF-8"); 25 response.setContentType("text/html;charset=UTF-8"); 26 27 // 2.接受参数 28 29 String name = request.getParameter("name"); 30 String password = request.getParameter("password"); 31 String telephone = request.getParameter("telephone"); 32 String username = request.getParameter("username"); 33 String isadmin = request.getParameter("isadmin"); 34 35 Users stu = new Users(name, password, telephone, username,isadmin); 36 37 // 3.业务处理 38 UserService service = new UserServiceImpl(); 39 int num = service.register(stu); 40 if (num > 0) { 41 System.out.println("register success!"); 42 response.sendRedirect("FindAllServlet"); 43 } else { 44 System.out.println("register fail!"); 45 46 } 47 48 } 49 }
RegisterServlet
实现修改功能
1 package com.bdqn.servlet; 2 3 import com.bdqn.entity.Users; 4 import com.bdqn.service.UserService; 5 import com.bdqn.service.impl.UserServiceImpl; 6 7 import javax.servlet.ServletException; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest; 10 import javax.servlet.http.HttpServletResponse; 11 import java.io.IOException; 12 13 14 public class UpdateServlet extends HttpServlet { 15 public void doGet(HttpServletRequest request, HttpServletResponse response) 16 throws ServletException, IOException { 17 18 this.doPost(request, response); 19 } 20 21 public void doPost(HttpServletRequest request, HttpServletResponse response) 22 throws ServletException, IOException { 23 request.setCharacterEncoding("UTF-8"); 24 response.setCharacterEncoding("UTF-8"); 25 response.setContentType("text/html;charset=UTF-8"); 26 27 // 2.接受参数 28 Integer id = Integer.valueOf(request.getParameter("id")); 29 String name = request.getParameter("name"); 30 String password = request.getParameter("password"); 31 String telephone = request.getParameter("telephone"); 32 String username = request.getParameter("username"); 33 String isadmin = request.getParameter("isadmin"); 34 Users stu = new Users(id,name, password, telephone, username,isadmin); 35 36 // 3.业务处理 37 UserService service = new UserServiceImpl(); 38 int num=service.update(stu); 39 if(num>0){ 40 System.out.println("update success!"); 41 response.sendRedirect("FindAllServlet"); 42 }else{ 43 System.out.println("update fail!"); 44 45 } 46 47 } 48 }
UpdateServlet
Util层
Hibernate封装类
1 package com.bdqn.util; 2 3 import org.hibernate.HibernateException; 4 import org.hibernate.Session; 5 import org.hibernate.SessionFactory; 6 import org.hibernate.cfg.Configuration; 7 8 public class Hibernate_Util { 9 private static ThreadLocal<Session> threadLocal = new ThreadLocal<Session>(); 10 private static Configuration configuration = null; 11 private static SessionFactory sessionFactory = null; 12 13 static { 14 15 try { 16 configuration = new Configuration().configure("/hibernate.cfg.xml"); 17 sessionFactory = configuration.buildSessionFactory(); 18 } catch (HibernateException e) { 19 System.out.println("解析xml和创建Session工厂error"); 20 e.printStackTrace(); 21 } 22 23 } 24 25 public static Session getSession() { 26 Session session = threadLocal.get(); 27 if (session == null) { 28 session = sessionFactory.openSession(); 29 threadLocal.set(session); 30 } 31 return session; 32 } 33 34 public static void closeSession() { 35 Session session = threadLocal.get(); 36 if (session != null) { 37 threadLocal.set(null); 38 session.close(); 39 } 40 } 41 }
Hibernate_Util
JSP
1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> 2 <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> 3 <% 4 String path = request.getContextPath(); 5 String basePath = request.getScheme() + "://" 6 + request.getServerName() + ":" + request.getServerPort() 7 + path + "/"; 8 %> 9 10 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 11 <html> 12 <head> 13 <base href="<%=basePath%>"> 14 15 <title>My JSP 'index.jsp' starting page</title> 16 <meta http-equiv="pragma" content="no-cache"> 17 <meta http-equiv="cache-control" content="no-cache"> 18 <meta http-equiv="expires" content="0"> 19 <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> 20 <meta http-equiv="description" content="This is my page"> 21 <!-- 22 <link rel="stylesheet" type="text/css" href="styles.css"> 23 --> 24 <script type="text/javascript" src="js/jquery-1.8.3.js"></script> 25 <script type="text/javascript" src="js/ajaxindex.js"></script> 26 </head> 27 28 <body> 29 <CENTER> 30 31 <table></table> 32 <div> 33 第<span id="pageNo"></span>/<span id="totalPage"></span>页 34 <a href="javascript:void(0);" class="apage">首页</a> 35 <a href="javascript:void(0);" class="apage">上一页</a> 36 <a href="javascript:void(0);" class="apage">下一页</a> 37 <a href="javascript:void(0);" class="apage">末页</a> 38 共<span id="totalCount"></span>条 39 </div> 40 41 </CENTER> 42 43 </body> 44 </html> 45 46 ajaxindex.jsp
ajaxindex.jsp
1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8" %> 2 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> 3 <% 4 String path = request.getContextPath(); 5 String basePath = request.getScheme() + "://" 6 + request.getServerName() + ":" + request.getServerPort() 7 + path + "/"; 8 %> 9 10 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 11 <html> 12 <head> 13 <base href="<%=basePath%>"> 14 15 <title>My JSP 'index.jsp' starting page</title> 16 <meta http-equiv="pragma" content="no-cache"> 17 <meta http-equiv="cache-control" content="no-cache"> 18 <meta http-equiv="expires" content="0"> 19 <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> 20 <meta http-equiv="description" content="This is my page"> 21 <!-- 22 <link rel="stylesheet" type="text/css" href="styles.css"> 23 --> 24 </head> 25 26 <body> 27 <CENTER> 28 <table border="1px" width="60%"> 29 <tr> 30 <td colspan="6"> 31 <a href="register.jsp">注册</a> 32 </td> 33 </tr> 34 <tr> 35 <td> 36 用户编号 37 </td> 38 <td> 39 用户名 40 </td> 41 <td> 42 密码 43 </td> 44 <td> 45 电话 46 </td> 47 <td> 48 姓名 49 </td> 50 <td> 51 操作 52 </td> 53 </tr> 54 55 <c:forEach var="i" items="${list}"> 56 <tr> 57 <td> 58 ${i.id } 59 </td> 60 <td> 61 ${i.name } 62 </td> 63 <td> 64 ${i.password } 65 </td> 66 <td> 67 ${i.telephone } 68 </td> 69 70 <td> 71 ${i.username } 72 </td> 73 <td> 74 <a href="FindByIdSerlvet?id=${i.id}">修改</a> 75 76 <a href="DeleteSerlvet?id=${i.id}">删除</a> 77 78 </td> 79 </tr> 80 </c:forEach> 81 82 </table> 83 <div> 84 85 86 第${page.pageno}/${page.totalpage}页 87 <a href="FindAllServlet?pageNo=1">首页</a> 88 <c:choose> 89 <c:when test="${page.pageno gt 1}"> 90 <a href="FindAllServlet?pageNo=${page.pageno-1 }">上一页</a> 91 </c:when> 92 <c:otherwise> 93 <a href="javascript:alert('已经是第一页了,没有上一页!');">上一页</a> 94 </c:otherwise> 95 </c:choose> 96 <c:choose> 97 <c:when test="${page.pageno lt page.totalpage}"> 98 <a href="FindAllServlet?pageNo=${page.pageno+1 }">下一页</a> 99 </c:when> 100 <c:otherwise> 101 <a href="javascript:alert('已经是最有一页了,没有下一页!');">下一页</a> 102 </c:otherwise> 103 </c:choose> 104 105 <a href="FindAllServlet?pageNo=${page.totalpage}">末页</a> 106 107 共${page.totalcount}条 108 109 </div> 110 111 </CENTER> 112 113 </body> 114 </html>
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP 'index.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <center> <fieldset style="width: 300px;"> <legend> 登录 </legend> <form action="LoginServlet" method="post"> <table> <tr> <td> 用户名: </td> <td> <input type="text" name="name" /> </td> </tr> <tr> <td> 密码: </td> <td> <input type="password" name="password" /> </td> </tr> <tr> <td> <input type="submit" value="提交" /> </td> <td> <input type="reset" value="重置" /> </td> </tr> </table> </form> </fieldset> </center> </body> </html>
long.jsp
1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8" %> 2 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> 3 <% 4 String path = request.getContextPath(); 5 String basePath = request.getScheme() + "://" 6 + request.getServerName() + ":" + request.getServerPort() 7 + path + "/"; 8 %> 9 10 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 11 <html> 12 <head> 13 <base href="<%=basePath%>"> 14 15 <title>My JSP 'index.jsp' starting page</title> 16 <meta http-equiv="pragma" content="no-cache"> 17 <meta http-equiv="cache-control" content="no-cache"> 18 <meta http-equiv="expires" content="0"> 19 <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> 20 <meta http-equiv="description" content="This is my page"> 21 <!-- 22 <link rel="stylesheet" type="text/css" href="styles.css"> 23 --> 24 </head> 25 26 <body> 27 <center> 28 <fieldset style="width: 300px;"> 29 <legend> 30 注册 31 </legend> 32 <form action="RegisterServlet" method="post"> 33 <table> 34 <tr> 35 <td> 36 用户名: 37 </td> 38 <td> 39 <input type="text" name="name"/> 40 </td> 41 </tr> 42 <tr> 43 <td> 44 密码: 45 </td> 46 <td> 47 <input type="password" name="password"/> 48 </td> 49 </tr> 50 <tr> 51 <td> 52 电话: 53 </td> 54 <td> 55 <input type="text" name="telephone"/> 56 </td> 57 </tr> 58 <tr> 59 <td> 60 姓名: 61 </td> 62 <td> 63 <input type="text" name="username"/> 64 </td> 65 </tr> 66 <tr> 67 <td> 68 <input type="submit" value="修改"/> 69 </td> 70 <td> 71 <input type="reset" value="重置"/> 72 </td> 73 </tr> 74 </table> 75 </form> 76 </fieldset> 77 </center> 78 </body> 79 </html>
register.jsp
1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> 2 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> 3 <% 4 String path = request.getContextPath(); 5 String basePath = request.getScheme() + "://" 6 + request.getServerName() + ":" + request.getServerPort() 7 + path + "/"; 8 %> 9 10 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 11 <html> 12 <head> 13 <base href="<%=basePath%>"> 14 <title>My JSP 'index.jsp' starting page</title> 15 <meta http-equiv="pragma" content="no-cache"> 16 <meta http-equiv="cache-control" content="no-cache"> 17 <meta http-equiv="expires" content="0"> 18 <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> 19 <meta http-equiv="description" content="This is my page"> 20 <!-- 21 <link rel="stylesheet" type="text/css" href="styles.css"> 22 --> 23 </head> 24 25 <body> 26 <center> 27 <fieldset style="width: 300px;"> 28 <legend> 29 <br>修改 30 </legend> 31 <form action="UpdateServlet?id=${stu.id}" method="post"> 32 <table border="1px" width="60%"> 33 <tr> 34 <td> 35 用户名: 36 </td> 37 <td> 38 <input type="text" name="name" value="${stu.name}"/> 39 </td> 40 </tr> 41 <tr> 42 <td> 43 密码: 44 </td> 45 <td> 46 <input type="password" name="password" value="${stu.password}"/> 47 </td> 48 </tr> 49 <tr> 50 <td> 51 电话: 52 </td> 53 <td> 54 <input type="text" name="telephone" value="${stu.telephone}"/> 55 </td> 56 </tr> 57 <tr> 58 <td> 59 姓名: 60 </td> 61 <td> 62 <input type="text" name="username" value="${stu.username}"/> 63 </td> 64 </tr> 65 66 <tr> 67 <td> 68 <input type="submit" value="修改" /> 69 </td> 70 <td> 71 <input type="reset" value="重置" /> 72 </td> 73 </tr> 74 </table> 75 </form> 76 </fieldset> 77 </center> 78 </body> 79 </html>
update.jsp
原文作者：HumourTeacher
原文地址: https://www.cnblogs.com/humorMr/p/11695205.html
本文转自网络文章，转载此文章仅为分享知识，如有侵权，请联系博主进行删除。
原文地址: https://www.cnblogs.com/humorMr/p/11695205.html
本文转自网络文章，转载此文章仅为分享知识，如有侵权，请联系博主进行删除。
相关文章