使用maven搭建Hibernate

2019-10-18 08:40:06来源：博客园阅读 ()

使用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>页   &nbsp;&nbsp;
34         <a href="javascript:void(0);" class="apage">首页</a>  &nbsp;&nbsp;
35         <a href="javascript:void(0);" class="apage">上一页</a> &nbsp;&nbsp;
36         <a href="javascript:void(0);" class="apage">下一页</a> &nbsp;&nbsp;
37         <a href="javascript:void(0);" class="apage">末页</a>&nbsp;&nbsp;
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                     &nbsp;&nbsp;
 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}页 &nbsp;&nbsp;
 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         &nbsp;&nbsp;
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>

 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>