src源代码部分:
1.hibernate部分
Users.java
package Hibernate;
import java.util.HashSet;
import java.util.Set;
/**
* Users entity. @author MyEclipse Persistence Tools
*/
public class Users implements java.io.Serializable {
// Fields
private String username;
private String pwd;
private String teleNo;
private Integer age;
private String sex;
private String account;
private Integer grade;
private Integer warnings;
// Constructors
/** default constructor */
public Users() {
}
/** full constructor */
public Users(String username, String pwd, String teleNo, Integer age,
String sex, String account, Integer grade, Integer warnings) {
// TODO Auto-generated constructor stub
this.username = username;
this.pwd = pwd;
this.teleNo = teleNo;
this.age = age;
this.sex = sex;
this.account = account;
this.grade = grade;
this.warnings = warnings;
}
// Property accessors
private Integer id;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public String getTeleNo() {
return teleNo;
}
public void setTeleNo(String teleNo) {
this.teleNo = teleNo;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAccount() {
return account;
}
public void setAccount(String account) {
this.account = account;
}
public Integer getGrade() {
return grade;
}
public void setGrade(Integer grade) {
this.grade = grade;
}
public Integer getWarnings() {
return warnings;
}
public void setWarnings(Integer warnings) {
this.warnings = warnings;
}
}
Users.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="Hibernate.Users" table="users" catalog="myparking">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="identity" />
</id>
<property name="username" type="java.lang.String">
<column name="username" length="10" />
</property>
<property name="pwd" type="java.lang.String">
<column name="pwd" length="10" />
</property>
<property name="teleNo" type="java.lang.String">
<column name="teleNo" length="15" />
</property>
<property name="age" type="java.lang.Integer">
<column name="age" />
</property>
<property name="sex" type="java.lang.String">
<column name="sex" length="1" />
</property>
<property name="account" type="java.lang.String">
<column name="account" length="11" />
</property>
<property name="grade" type="java.lang.Integer">
<column name="grade" />
</property>
<property name="warnings" type="java.lang.Integer">
<column name="warnings" />
</property>
</class>
</hibernate-mapping>
UsersBO.java
package Hibernate;
import java.io.Serializable;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.util.Calendar;
import java.util.Collection;
import java.util.Date;
import java.util.Iterator;
import java.util.Locale;
import java.util.Map;
import java.util.Set;
import org.hibernate.CacheMode;
import org.hibernate.FlushMode;
import org.hibernate.HibernateException;
import org.hibernate.LockMode;
import org.hibernate.LockOptions;
import org.hibernate.Query;
import org.hibernate.ScrollMode;
import org.hibernate.ScrollableResults;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.transform.ResultTransformer;
import org.hibernate.type.Type;
import java.util.List;
public class UsersBO {
public void addUsers(String username, String pwd, String teleNo, Integer age,
String sex, String account, Integer grade,Integer warnings){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Users users= new Users(username, pwd, teleNo, age,sex, account, grade,warnings);
session.save(users);
tx.commit();
}
public Users getUsers(Integer id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Users user = (Users)session.get(Users.class, id);
tx.commit();
return user;
}
public boolean IsUserExist(Integer id){
Users user = getUsers(id);
if(user==null)return false;
else return true;
}
public boolean checkUser(Integer id, String pwd){
Users user=getUsers(id);
if(user.getPwd().equals(pwd))return true;
else return false;
}
public List<Users> getUsers(){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Users");
List<Users> list = query.list();
tx.commit();
return list;
}
public void updateUsersByUser(Users users, String username, String pwd, String teleNo, Integer age,
String sex, String account){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
users.setUsername(username);
users.setPwd(pwd);
users.setTeleNo(teleNo);
users.setAge(age);
users.setSex(sex);
users.setAccount(account);
session.saveOrUpdate(users);
tx.commit();
}
public void updateUsersBySuper(Users users,Integer grade){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
users.setGrade(grade);
session.saveOrUpdate(users);
tx.commit();
}
public void deleteUsers(Integer id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Users user = (Users)session.get(Users.class, id);
session.delete(user);
tx.commit();
}
}
Parkspace.java
package Hibernate;
import java.sql.Timestamp;
/**
* Parkspace entity. @author MyEclipse Persistence Tools
*/
public class Parkspace implements java.io.Serializable {
// Fields
private Integer pos;
private String isEmpty;
private String carnum;
private String isReserved;
private Timestamp reserveStart;
private Timestamp reserveEnd;
// Constructors
/** default constructor */
public Parkspace() {
}
/** minimal constructor */
public Parkspace(Integer pos, Timestamp reserveStart, Timestamp reserveEnd) {
this.pos = pos;
this.reserveStart = reserveStart;
this.reserveEnd = reserveEnd;
}
/** full constructor */
public Parkspace(Integer pos, String isEmpty, String carnum,
String isReserved, Timestamp reserveStart, Timestamp reserveEnd) {
this.pos = pos;
this.isEmpty = isEmpty;
this.carnum = carnum;
this.isReserved = isReserved;
this.reserveStart = reserveStart;
this.reserveEnd = reserveEnd;
}
// Property accessors
public Integer getPos() {
return this.pos;
}
public void setPos(Integer pos) {
this.pos = pos;
}
public String getIsEmpty() {
return this.isEmpty;
}
public void setIsEmpty(String isEmpty) {
this.isEmpty = isEmpty;
}
public String getCarnum() {
return this.carnum;
}
public void setCarnum(String carnum) {
this.carnum = carnum;
}
public String getIsReserved() {
return this.isReserved;
}
public void setIsReserved(String isReserved) {
this.isReserved = isReserved;
}
public Timestamp getReserveStart() {
return this.reserveStart;
}
public void setReserveStart(Timestamp reserveStart) {
this.reserveStart = reserveStart;
}
public Timestamp getReserveEnd() {
return this.reserveEnd;
}
public void setReserveEnd(Timestamp reserveEnd) {
this.reserveEnd = reserveEnd;
}
}
Parkspace.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="Hibernate.Parkspace" table="parkspace" catalog="myparking">
<id name="pos" type="java.lang.Integer">
<column name="pos" />
<generator class="assigned" />
</id>
<property name="isEmpty" type="java.lang.String">
<column name="is_empty" length="1" />
</property>
<property name="carnum" type="java.lang.String">
<column name="carnum" length="7" />
</property>
<property name="isReserved" type="java.lang.String">
<column name="is_reserved" length="1" />
</property>
<property name="reserveStart" type="java.sql.Timestamp">
<column name="reserve_start" length="19" not-null="false" />
</property>
<property name="reserveEnd" type="java.sql.Timestamp">
<column name="reserve_end" length="19" not-null="false" />
</property>
</class>
</hibernate-mapping>
ParkspaceBO.java
package Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import java.sql.Timestamp;
import java.util.List;
public class ParkspaceBO {
public void addParkspace(Integer pos, String isEmpty, String carnum,
String isReserved, Timestamp reserveStart, Timestamp reserveEnd){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Parkspace Parkspace= new Parkspace(pos, "0", null, "0", null,null);
session.save(Parkspace);
tx.commit();
}
public void addParkspace(Parkspace parkspace){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
session.save(parkspace);
tx.commit();
}
public Parkspace getParkspace(String size){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
String s = "";
if(size.indexOf("A")!=-1){
s += "from Parkspace where pos between 1 and 100 and ";
}
else if(size.indexOf("B")!=-1){
s += "from Parkspace where pos between 101 and 200 and ";
}
else if(size.indexOf("C")!=-1){
s += "from Parkspace where pos between 201 and 300 and ";
}
else{
s += "from Parkspace where pos between 301 and 400 and ";
}
s+="is_empty=1";
Query query = session.createQuery(s);
List<Parkspace> list = query.list();
try
{
tx.commit();
} catch (Exception e)
{
if (null != tx)
tx.rollback();
e.printStackTrace();
}
return list.get(0);
}
public void updateParkspace(Parkspace parkspace,String carnum, String isempty){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
parkspace.setCarnum(carnum);
parkspace.setIsEmpty(isempty);
parkspace.setReserveStart(parkspace.getReserveEnd());
session.saveOrUpdate(parkspace);
tx.commit();
}
public void updateParkspace(Parkspace parkspace, String isempty){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
parkspace.setCarnum(null);
parkspace.setIsEmpty(isempty);
session.saveOrUpdate(parkspace);
tx.commit();
}
public void updateParkspace(Parkspace parkspace, String carnum,String isempty, String isreserve,Timestamp start,Timestamp end){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
parkspace.setIsEmpty(isempty);
parkspace.setCarnum(carnum);
parkspace.setIsReserved(isreserve);
parkspace.setReserveStart(start);
parkspace.setReserveEnd(end);
session.saveOrUpdate(parkspace);
tx.commit();
}
public Parkspace getParkspace(Integer pos){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Parkspace user = (Parkspace)session.get(Parkspace.class, pos);
tx.commit();
return user;
}
public boolean IsParkspaceAvailable(Integer pos){
Parkspace parkspace = getParkspace(pos);
return Integer.parseInt(parkspace.getIsEmpty())==1?true:false;
}
public boolean IsParkspaceReserved(Integer pos){
Parkspace parkspace = getParkspace(pos);
return Integer.parseInt(parkspace.getIsReserved())==1?true:false;
}
public List<Parkspace> getParkspace(){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Parkspace");
List<Parkspace> list = query.list();
tx.commit();
return list;
}
public List<Parkspace> getparkspace(String carnum){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
String a = "from Parkspace where carnum ="+carnum+" and is_reserved = 1";
Query query = session.createQuery(a);
List<Parkspace> list = query.list();
tx.commit();
return list;
}
public void reserve(Parkspace cars,Timestamp start,Timestamp end){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
cars.setReserveStart(start);
cars.setReserveEnd(end);
session.saveOrUpdate(cars);
tx.commit();
}
public void deleteParkspace(Integer id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Parkspace Parkspace = getParkspace(id);
session.delete(Parkspace);
tx.commit();
}
}
Employers.java
package Hibernate;
import java.sql.Timestamp;
/**
* Employers entity. @author MyEclipse Persistence Tools
*/
public class Employers implements java.io.Serializable {
// Fields
private Integer employId;
private String name;
private String pwd;
private Integer age;
private String sex;
private String grade;
private String isWork;
private Timestamp lastUsed;
// Constructors
/** default constructor */
public Employers() {
}
/** minimal constructor */
public Employers(Timestamp lastUsed) {
this.lastUsed = lastUsed;
}
/** full constructor */
public Employers(String name, String pwd, Integer age, String sex,
String grade, String isWork, Timestamp lastUsed) {
this.name = name;
this.pwd = pwd;
this.age = age;
this.sex = sex;
this.grade = grade;
this.isWork = isWork;
this.lastUsed = lastUsed;
}
// Property accessors
public Integer getEmployId() {
return this.employId;
}
public void setEmployId(Integer employId) {
this.employId = employId;
}
public String getName() {
return this.name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return this.pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public Integer getAge() {
return this.age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getSex() {
return this.sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getGrade() {
return this.grade;
}
public void setGrade(String grade) {
this.grade = grade;
}
public String getIsWork() {
return this.isWork;
}
public void setIsWork(String isWork) {
this.isWork = isWork;
}
public Timestamp getLastUsed() {
return this.lastUsed;
}
public void setLastUsed(Timestamp lastUsed) {
this.lastUsed = lastUsed;
}
}
Employers.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="Hibernate.Employers" table="employers" catalog="myparking">
<id name="employId" type="java.lang.Integer">
<column name="employ_id" />
<generator class="identity" />
</id>
<property name="name" type="java.lang.String">
<column name="name" length="10" />
</property>
<property name="pwd" type="java.lang.String">
<column name="pwd" length="10" />
</property>
<property name="age" type="java.lang.Integer">
<column name="age" />
</property>
<property name="sex" type="java.lang.String">
<column name="sex" length="1" />
</property>
<property name="grade" type="java.lang.String">
<column name="grade" length="1" />
</property>
<property name="isWork" type="java.lang.String">
<column name="is_work" length="1" />
</property>
<property name="lastUsed" type="java.sql.Timestamp">
<column name="last_used" length="19" not-null="true" />
</property>
</class>
</hibernate-mapping>
EmployersBO.java
package Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import java.sql.Timestamp;
import java.util.List;
public class EmployersBO {
public void addEmployers(String name, String pwd, Integer age, String sex,
String grade, String isWork,Timestamp lastUsed){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Employers Employers= new Employers(name, pwd, age, sex, grade, "1", new Timestamp(System.currentTimeMillis()));
session.save(Employers);
tx.commit();
}
public Employers getEmployers(Integer id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Employers user = (Employers)session.get(Employers.class, id);
tx.commit();
return user;
}
public boolean IsEmployerExist(Integer id){
Employers employers = getEmployers(id);
if(employers==null)return false;
else return true;
}
public boolean checkEmployer(Integer id, String pwd){
Employers employers=getEmployers(id);
if(employers.getPwd().equals(pwd))return true;
else return false;
}
public List<Employers> getEmployers(){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Employers");
List<Employers> list = query.list();
tx.commit();
return list;
}
public void updateEmployersByEmployee(Employers employers,String name, String pwd, Integer age, String sex
){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
employers.setName(name);
employers.setPwd(pwd);
employers.setAge(age);
employers.setSex(sex);
session.saveOrUpdate(employers);
tx.commit();
}
public void updateEmployersBySuper(Employers employers,String grade,String isWork){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
employers.setIsWork(isWork);
employers.setGrade(grade);
session.saveOrUpdate(employers);
tx.commit();
}
public void deleteEmployers(Integer id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Employers Employers = (Employers)session.get(Employers.class, id);
session.delete(Employers);
tx.commit();
}
}
Charge.java
package Hibernate;
import java.sql.Timestamp;
/**
* Charge entity. @author MyEclipse Persistence Tools
*/
public class Charge implements java.io.Serializable {
// Fields
private Integer cardId;
private Users users;
private String cardType;
private Double cost;
private Timestamp starttime;
private Timestamp endtime;
private Double balance;
// Constructors
/** default constructor */
public Charge() {
}
/** full constructor */
public Charge(Users users, String cardType, Double cost,
Timestamp starttime, Timestamp endtime, Double balance) {
this.users = users;
this.cardType = cardType;
this.cost = cost;
this.starttime = starttime;
this.endtime = endtime;
this.balance = balance;
}
// Property accessors
public Charge(Users users, String cardType, Timestamp starttime) {
// TODO Auto-generated constructor stub
this.users = users;
this.cardType=cardType;
this.starttime = starttime;
}
public Integer getCardId() {
return this.cardId;
}
public void setCardId(Integer cardId) {
this.cardId = cardId;
}
public Integer getId(){
return this.users.getId();
}
public Users getUsers() {
return this.users;
}
public void setUsers(Users users) {
this.users = users;
}
public String getCardType() {
return this.cardType;
}
public void setCardType(String cardType) {
this.cardType = cardType;
}
public Double getCost() {
return this.cost;
}
public void setCost(Double cost) {
this.cost = cost;
}
public Timestamp getStarttime() {
return this.starttime;
}
public void setStarttime(Timestamp starttime) {
this.starttime = starttime;
}
public Timestamp getEndtime() {
return this.endtime;
}
public void setEndtime(Timestamp endtime) {
this.endtime = endtime;
}
public Double getBalance() {
return this.balance;
}
public void setBalance(Double balance) {
this.balance = balance;
}
}
Charge.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="Hibernate.Charge" table="charge" catalog="myparking">
<id name="cardId" type="java.lang.Integer">
<column name="card_id" />
<generator class="identity" />
</id>
<many-to-one name="users" class="Hibernate.Users" fetch="select">
<column name="id" not-null="true" />
</many-to-one>
<property name="cardType" type="java.lang.String">
<column name="card_type" length="1" />
</property>
<property name="cost" type="java.lang.Double">
<column name="cost" precision="10" />
</property>
<property name="starttime" type="java.sql.Timestamp">
<column name="starttime" length="19" not-null="true" />
</property>
<property name="endtime" type="java.sql.Timestamp">
<column name="endtime" length="19" not-null="false" />
</property>
<property name="balance" type="java.lang.Double">
<column name="balance" precision="10" />
</property>
</class>
</hibernate-mapping>
ChargeBO.java
package Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import java.sql.Timestamp;
import java.util.List;
public class ChargeBO {
public void addCharge(Users users, String cardType){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Charge charge= new Charge(users,cardType,0.0,new Timestamp(System.currentTimeMillis()),new Timestamp(System.currentTimeMillis()),0.0);
System.out.println(users.getId());
session.save(charge);
session.saveOrUpdate(charge);
tx.commit();
}
public void updateCharges(Charge charge,Double cost){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Double a = charge.getCost();
if(a==null){
a = 0.0;
}
Double b = charge.getBalance();
Double c = a+cost;
System.out.println(a+cost);
charge.setCost(c);
charge.setBalance(b-cost);
session.saveOrUpdate(charge);
tx.commit();
}
public void recharge(Charge charge,Double re){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Double a = charge.getBalance();
Double c = a+re;
System.out.println(a+re);
charge.setBalance(c);
session.saveOrUpdate(charge);
tx.commit();
}
public Charge getCharge(Integer card_id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Charge Charge = (Charge)session.get(Charge.class, card_id);
tx.commit();
return Charge;
}
public boolean IsChargeExist(Integer id){
Charge Charge = getcharge(id);
if(Charge==null)return false;
else return true;
}
public List<Charge> getCharge(){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Charge");
List<Charge> list = query.list();
tx.commit();
return list;
}
public Charge getcharge(Integer id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Charge where users.id="+id);
List<Charge> list = query.list();
tx.commit();
if(list.size()!=0)
return list.get(0);
else
return null;
}
public void CarIn(Charge charge){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
charge.setStarttime(new Timestamp(System.currentTimeMillis()));
session.saveOrUpdate(charge);
tx.commit();
}
public void CarOut(Charge charge){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
charge.setStarttime(new Timestamp(System.currentTimeMillis()));
session.saveOrUpdate(charge);
tx.commit();
}
public void deleteCharge(Integer id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Charge Charge = getCharge(id);
session.delete(Charge);
tx.commit();
}
}
Cars.java
package Hibernate;
import java.sql.Timestamp;
/**
* Cars entity. @author MyEclipse Persistence Tools
*/
public class Cars implements java.io.Serializable {
// Fields
private String carnum;
private Users users;
private String size;
private Integer pos;
private Timestamp timein;
private Timestamp timeout;
private String state;
// Constructors
/** default constructor */
public Cars() {
}
/** minimal constructor */
public Cars(String carnum, Users users, Timestamp timein, Timestamp timeout) {
this.carnum = carnum;
this.users = users;
this.timein = timein;
this.timeout = timeout;
}
/** full constructor */
public Cars(String carnum, Users users, String size, Integer pos,
Timestamp timein, Timestamp timeout, String state) {
this.carnum = carnum;
this.users = users;
this.size = size;
this.pos = pos;
this.timein = timein;
this.timeout = timeout;
this.state = state;
}
// Property accessors
public String getCarnum() {
return this.carnum;
}
public void setCarnum(String carnum) {
this.carnum = carnum;
}
public Users getUsers() {
return this.users;
}
public void setUsers(Users users) {
this.users = users;
}
public String getSize() {
return this.size;
}
public void setSize(String size) {
this.size = size;
}
public Integer getPos() {
return this.pos;
}
public void setPos(Integer pos) {
this.pos = pos;
}
public Timestamp getTimein() {
return this.timein;
}
public void setTimein(Timestamp timein) {
this.timein = timein;
}
public Timestamp getTimeout() {
return this.timeout;
}
public void setTimeout(Timestamp timeout) {
this.timeout = timeout;
}
public String getState() {
return this.state;
}
public void setState(String state) {
this.state = state;
}
}
Cars.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="Hibernate.Cars" table="cars" catalog="myparking">
<id name="carnum" type="java.lang.String">
<column name="carnum" length="7" />
<generator class="assigned" />
</id>
<many-to-one name="users" class="Hibernate.Users" fetch="select">
<column name="id" not-null="true" />
</many-to-one>
<property name="size" type="java.lang.String">
<column name="size" length="10" />
</property>
<property name="pos" type="java.lang.Integer">
<column name="pos" />
</property>
<property name="timein" type="java.sql.Timestamp">
<column name="timein" length="19" not-null="false" />
</property>
<property name="timeout" type="java.sql.Timestamp">
<column name="timeout" length="19" not-null="false" />
</property>
<property name="state" type="java.lang.String">
<column name="state" length="1" />
</property>
</class>
</hibernate-mapping>
CarsBO.java
package Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import java.sql.Timestamp;
import java.util.List;
public class CarsBO {
public void addCars(String carnum, Users users, String size, Integer pos,
Timestamp timein, Timestamp timeout, String state){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Cars Cars= new Cars(carnum, users, size, pos, new Timestamp(System.currentTimeMillis()), null, "1");
session.save(Cars);
tx.commit();
}
public void addCars(String carnum,String size,Integer id){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
UsersBO userbo = new UsersBO();
Users users = userbo.getUsers(id);
Cars Cars= new Cars(carnum, users, size, null, new Timestamp(System.currentTimeMillis()), null, "1");
session.save(Cars);
tx.commit();
}
public void updateCars(Cars cars, Integer pos, Timestamp timein,Timestamp timeout,String state){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
cars.setPos(pos);
cars.setTimein(timein);
cars.setTimeout(timeout);
cars.setState(state);
session.saveOrUpdate(cars);
tx.commit();
}
public void updateCars(Cars cars, Integer pos, Timestamp timeout,String state){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
cars.setPos(pos);
cars.setTimeout(timeout);
cars.setState(state);
session.saveOrUpdate(cars);
tx.commit();
}
public Cars getCars(String carnum){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Cars user = (Cars)session.get(Cars.class, carnum);
tx.commit();
return user;
}
public boolean IsCarExist(String carnum){
Cars Cars = getCars(carnum);
if(Cars==null)return false;
else return true;
}
public List<Cars> getCars(){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Cars");
List<Cars> list = query.list();
tx.commit();
return list;
}
public List<Cars> getCars(Integer id){
Session session = (Session)HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Cars where users="+id);
List<Cars> list = query.list();
System.out.println(list.size());
try
{
tx.commit();
} catch (Exception e)
{
if (null != tx)
tx.rollback();
e.printStackTrace();
}
return list;
}
public List<Cars> getCars(Integer id,String state){
Session session = (Session)HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Cars where users="+id+" and state="+state);
List<Cars> list = query.list();
System.out.println(list.size());
try
{
tx.commit();
} catch (Exception e)
{
if (null != tx)
tx.rollback();
e.printStackTrace();
}
return list;
}
public void CarsIn(Cars cars, Integer pos){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
cars.setState("1");
cars.setPos(pos);
session.saveOrUpdate(cars);
tx.commit();
}
public void CarsOut(Cars cars){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
cars.setState("0");
cars.setPos(new Integer(-1));
session.saveOrUpdate(cars);
tx.commit();
}
public void deleteCars(String carnum){
Session session = (Session) HibernateSessionFactory.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Cars cars = getCars(carnum);
session.delete(cars);
tx.commit();
}
}
HibernateSessionFactory.java
package Hibernate;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution. Follows the Thread Local Session
* pattern, see {@link http://hibernate.org/42.html }.
*/
public class HibernateSessionFactory {
/**
* Location of hibernate.cfg.xml file.
* Location should be on the classpath as Hibernate uses
* #resourceAsStream style lookup for its configuration file.
* The default classpath location of the hibernate config file is
* in the default package. Use #setConfigFile() to update
* the location of the configuration file for the current session.
*/
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static org.hibernate.SessionFactory sessionFactory;
private static Configuration configuration = new Configuration();
private static ServiceRegistry serviceRegistry;
static {
try {
configuration.configure();
serviceRegistry = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry();
sessionFactory = configuration.buildSessionFactory(serviceRegistry);
} catch (Exception e) {
System.err.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
private HibernateSessionFactory() {
}
/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the <code>SessionFactory</code> if needed.
*
* @return Session
* @throws HibernateException
*/
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();
if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}
return session;
}
/**
* Rebuild hibernate session factory
*
*/
public static void rebuildSessionFactory() {
try {
configuration.configure();
serviceRegistry = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry();
sessionFactory = configuration.buildSessionFactory(serviceRegistry);
} catch (Exception e) {
System.err.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
/**
* Close the single hibernate session instance.
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);
if (session != null) {
session.close();
}
}
/**
* return session factory
*
*/
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}
/**
* return hibernate configuration
*
*/
public static Configuration getConfiguration() {
return configuration;
}
}
2. servlet
package servlet;
import java.io.IOException;
import java.sql.Timestamp;
import java.util.Date;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Hibernate.Employers;
import Hibernate.EmployersBO;
/**
* Servlet implementation class addOperator
*/
public class addOperator extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public addOperator() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
EmployersBO employersbo = new EmployersBO();
String name = request.getParameter("name");
String pwd = request.getParameter("password");
Integer age = Integer.parseInt(request.getParameter("age"));
String sex = request.getParameter("sex");
String grade = request.getParameter("grade");
String isWork="1";
Date date = new Date();
Timestamp lastUsed = new Timestamp(date.getTime());
employersbo.addEmployers(name,pwd,age,sex,grade,isWork,lastUsed);
List<Employers> allemployers = employersbo.getEmployers();
request.setAttribute("allemployers", allemployers);
request.setAttribute("opage", opmanage.opage);
RequestDispatcher dispatcher = request.getRequestDispatcher("opmanage.jsp");
dispatcher.forward(request, response);
}
}
package servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Hibernate.Cars;
import Hibernate.CarsBO;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class carmanage
*/
public class carmanage extends HttpServlet {
private static final long serialVersionUID = 1L;
public static int cpage=1;
/**
* @see HttpServlet#HttpServlet()
*/
public carmanage() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
CarsBO carsbo = new CarsBO();
List<Cars> allcars = carsbo.getCars();
request.setAttribute("allcars", allcars);
request.setAttribute("cpage", Integer.valueOf(cpage));
RequestDispatcher dispatcher = request.getRequestDispatcher("carmanage.jsp");
dispatcher.forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
CarsBO carsbo = new CarsBO();
List<Cars> allcars = carsbo.getCars();
double tp = allcars.size();
int num = (int) Math.ceil(tp/8);
request.setAttribute("allcars", allcars);
String dir = request.getParameter("dir");
if(dir.equals("涓婁竴椤?)){
if(cpage>1){
cpage--;
}
}
else if(dir.equals("涓嬩竴椤?)){
if(cpage<num){
cpage++;
}
}
else{
String s = request.getParameter("cpage");
cpage = Integer.parseInt(s);
}
request.setAttribute("cpage", cpage);
RequestDispatcher dispatcher = request.getRequestDispatcher("carmanage.jsp");
dispatcher.forward(request, response);
}
}
package servlet;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class changeinf
*/
public class changeinf extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public changeinf() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
Users user1 =(Users)request.getSession().getAttribute("user");
String username = request.getParameter("username");
String sex = request.getParameter("sex");
String sage = request.getParameter("age");
String teleno = request.getParameter("teleNO");
String account = request.getParameter("account");
String pwd = request.getParameter("password");
UsersBO userbo = new UsersBO();
if(username!=null || sex!=null || sage!=null || teleno!=null || account!=null || pwd!=null){
Integer age = Integer.parseInt(request.getParameter("age"));
userbo.updateUsersByUser(user1, username, pwd, teleno, age, sex, account);
HttpSession session = request.getSession();
session.setAttribute("user", user1);
}
RequestDispatcher dispatcher = request.getRequestDispatcher("changeinf.jsp");
dispatcher.forward(request, response);
}
}
package servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Hibernate.Employers;
import Hibernate.EmployersBO;
/**
* Servlet implementation class changeop
*/
public class changeop extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public changeop() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
EmployersBO employersbo=new EmployersBO();
List<Employers> allemployers = employersbo.getEmployers();
double tmpnum1 = allemployers.size();
int size1 = (int) Math.ceil(tmpnum1/8);
String BTNid = request.getParameter("id");
String id = BTNid.substring(1);
String BTN = BTNid.substring(0, 1);
Employers employer = employersbo.getEmployers(Integer.parseInt(id));
if(BTN.equals("c")){
String g = request.getParameter("grade"+id);
String st = request.getParameter("state"+id);
if(g != null && st != null){
employersbo.updateEmployersBySuper(employer, g, st);
}
}
else{
employersbo.deleteEmployers(Integer.parseInt(id));
}
allemployers = employersbo.getEmployers();
double tmpnum2 = allemployers.size();
int size2 = (int) Math.ceil(tmpnum2/8);
if(size2 != size1){
if(opmanage.opage == size1){
opmanage.opage = size2;
}
}
request.setAttribute("allemployers", allemployers);
request.setAttribute("opage", opmanage.opage);
RequestDispatcher dispatcher = request.getRequestDispatcher("opmanage.jsp");
dispatcher.forward(request, response);
}
}
package servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class changeuser
*/
public class changeuser extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public changeuser() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
UsersBO usersbo=new UsersBO();
List<Users> allusers = usersbo.getUsers();
double tmpnum1 = allusers.size();
int size1 = (int) Math.ceil(tmpnum1/8);
String BTNid = request.getParameter("id");
String id = BTNid.substring(1);
String BTN = BTNid.substring(0, 1);
Users user = usersbo.getUsers(Integer.parseInt(id));
if(BTN.equals("c")){
String g = request.getParameter("grade"+id);
if(g != null){
if(g.equals("鏅€氱敤鎴?)){
usersbo.updateUsersBySuper(user, new Integer(0));
}
else{
usersbo.updateUsersBySuper(user, new Integer(1));
}
}
}
else{
usersbo.deleteUsers(Integer.parseInt(id));
}
allusers = usersbo.getUsers();
double tmpnum2 = allusers.size();
int size2 = (int) Math.ceil(tmpnum2/8);
if(size2 != size1){
if(usermanage.page == size1){
usermanage.page = size2;
}
}
request.setAttribute("allusers", allusers);
request.setAttribute("page", usermanage.page);
RequestDispatcher dispatcher = request.getRequestDispatcher("usermanage.jsp");
dispatcher.forward(request, response);
}
}
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Timestamp;
import java.util.List;
import javax.naming.spi.DirStateFactory.Result;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;
import Hibernate.CarsBO;
import Hibernate.Parkspace;
import Hibernate.ParkspaceBO;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class register
*/
public class inmanage extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* Default constructor.
*/
public inmanage() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String userid = request.getParameter("userid");
boolean in = false;
String carnum = request.getParameter("carnum");
String carsize = (new String(request.getParameter("carsize").getBytes("UTF-8"), "GB2312")).substring(0,1);
if(userid.length()<=10&&carnum.length()<=7){
CarsBO carsbo = new CarsBO();
Integer id = Integer.parseInt(userid);
ParkspaceBO parksbo = new ParkspaceBO();
Parkspace park = parksbo.getParkspace(carsize);
parksbo.updateParkspace(park,carnum,"0");
Integer pos = park.getPos();
if(!carsbo.IsCarExist(carnum)){
carsbo.addCars(carnum,(new UsersBO()).getUsers(id),carsize,pos,new Timestamp(System.currentTimeMillis()), new Timestamp(System.currentTimeMillis()), "1");
}
else{
if(carsbo.getCars(carnum).getUsers().getId()==id){
if(carsbo.getCars(carnum).getState().indexOf("0")!=-1){
carsbo.updateCars(carsbo.getCars(carnum), pos, new Timestamp(System.currentTimeMillis()), new Timestamp(System.currentTimeMillis()), "1");
}
else{
in = true;
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('鏈溅宸插叆鍦猴紝璇峰嬁閲嶆柊鍏ュ満锛?);");
out.println("history.go(-1);");
out.println("</script>");
}
}
else{
in = true;
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('杞﹁締涓庣敤鎴蜂笉绗︼紒璇烽噸鏂拌緭鍏ワ紒');");
out.println("history.go(-1);");
out.println("</script>");
}
}
if(in==false){
RequestDispatcher dispatcher = request.getRequestDispatcher("inresult.jsp");
dispatcher.forward(request, response);
}
}else{//锟斤拷锟诫不一锟斤拷
//JOptionPane.showMessageDialog(null,"涓ゆ杈撳叆瀵嗙爜涓嶄竴鑷达紝璇烽噸鏂拌緭鍏?);
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('鐢ㄦ埛鍚嶄笉瓒呰繃鍗佷釜瀛楃锛岃溅鐗屽彿涓嶈秴杩囦竷涓瓧绗?);");
out.println("history.go(-1);");
out.println("</script>");
}
}
}
package servlet;
import java.awt.Window;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import Hibernate.Employers;
import Hibernate.EmployersBO;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class login
*/
public class login extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public login() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String userIdString =request.getParameter("userID");
if(request.getParameter("role").equals("user")){//鐧婚檰瑙掕壊涓虹敤鎴?
Integer userID = Integer.parseInt(userIdString);
String password = request.getParameter("password");
UsersBO usersbo = new UsersBO();
if(!usersbo.IsUserExist(userID)){//锟矫伙拷锟斤拷锟斤拷锟斤拷
RequestDispatcher dispatcher = request.getRequestDispatcher("UserNotFound.jsp");
dispatcher.forward(request, response);
}else{
if(usersbo.checkUser(userID, password)){//锟矫伙拷锟斤拷陆
HttpSession session = request.getSession();
Users user = usersbo.getUsers(userID);
session.setAttribute("user", user);
session.setAttribute("type", "user");
//if(request.getParameter("role").equals("user")){
RequestDispatcher dispatcher = request.getRequestDispatcher("frame.jsp");
dispatcher.forward(request, response);
//}
//else if(request.getParameter("role").equals("operator")){//鎿嶄綔鍛樼櫥闄?
//}
}
else {//鐢ㄦ埛涓嶅瓨鍦?
RequestDispatcher dispatcher = request.getRequestDispatcher("LogErr.jsp");
dispatcher.forward(request, response);
}
}
}else if(request.getParameter("role").equals("operator")){//鐧婚檰瑙掕壊涓烘搷浣滃憳
Integer EmployeeId = Integer.parseInt(userIdString);
String password = request.getParameter("password");
EmployersBO employerBo = new EmployersBO();
if(employerBo.IsEmployerExist(EmployeeId)){//鎿嶄綔鍛樺瓨鍦?
if(!employerBo.checkEmployer(EmployeeId, password)){//鎿嶄綔鍛榠d涓庡瘑鐮佷笉鍖归厤
RequestDispatcher dispatcher = request.getRequestDispatcher("LogErr.jsp");
dispatcher.forward(request, response);
}else{//鎿嶄綔鍛樺瓨鍦ㄥ苟涓斿瘑鐮佹纭?
//鍒ゆ柇鏄鐞嗗憳杩樻槸鎿嶄綔鍛?
HttpSession session = request.getSession();
Employers employers = employerBo.getEmployers(EmployeeId);
session.setAttribute("employee", employers);
session.setAttribute("type", "employee");
if(Integer.parseInt(employers.getGrade())==1){//绠$悊鍛?
RequestDispatcher dispatcher = request.getRequestDispatcher("super.jsp");
dispatcher.forward(request, response);
}else if(Integer.parseInt(employers.getGrade())==0){//鎿嶄綔鍛?
RequestDispatcher dispatcher = request.getRequestDispatcher("operator.jsp");
dispatcher.forward(request, response);
}
}
}else{//璇ユ搷浣滃憳涓嶅瓨鍦?
RequestDispatcher dispatcher = request.getRequestDispatcher("UserNotFound.jsp");
dispatcher.forward(request, response);
}
}
}
}
package servlet;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import Hibernate.Employers;
import Hibernate.EmployersBO;
import Hibernate.Users;
/**
* Servlet implementation class opchangeinf
*/
public class opchangeinf extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public opchangeinf() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//Employers employers,String name, String pwd, Integer age, String sex
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
EmployersBO employersbo = new EmployersBO();
Employers employer = (Employers)request.getSession().getAttribute("employee");
String name = request.getParameter("username");
String pwd = request.getParameter("password");
String sage = request.getParameter("age");
String sex = request.getParameter("sex");
if(name != null && pwd != null && sage != null && sex != null){
employersbo.updateEmployersByEmployee(employer, name, pwd, Integer.parseInt(sage), sex);
HttpSession session = request.getSession();
session.setAttribute("employee", employer);
}
String gd = employer.getGrade();
if(gd.equals("1")){
RequestDispatcher dispatcher = request.getRequestDispatcher("opchangeinf.jsp");
dispatcher.forward(request, response);
}
else{
RequestDispatcher dispatcher = request.getRequestDispatcher("empchangeinf.jsp");
dispatcher.forward(request, response);
}
}
}
package servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Hibernate.Employers;
import Hibernate.EmployersBO;
/**
* Servlet implementation class opmanage
*/
public class opmanage extends HttpServlet {
private static final long serialVersionUID = 1L;
public static int opage=1;
/**
* @see HttpServlet#HttpServlet()
*/
public opmanage() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
EmployersBO employersbo = new EmployersBO();
List<Employers> allemployers = employersbo.getEmployers();
request.setAttribute("allemployers", allemployers);
request.setAttribute("opage", Integer.valueOf(opage));
RequestDispatcher dispatcher = request.getRequestDispatcher("opmanage.jsp");
dispatcher.forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
EmployersBO employersbo = new EmployersBO();
List<Employers> allemployers = employersbo.getEmployers();
double tp = allemployers.size();
int num = (int) Math.ceil(tp/8);
request.setAttribute("allemployers", allemployers);
String dir = request.getParameter("dir");
if(dir.equals("涓婁竴椤?)){
if(opage>1){
opage--;
}
}
else if(dir.equals("涓嬩竴椤?)){
if(opage<num){
opage++;
}
}
else{
String s = request.getParameter("opage");
opage = Integer.parseInt(s);
}
request.setAttribute("opage", opage);
RequestDispatcher dispatcher = request.getRequestDispatcher("opmanage.jsp");
dispatcher.forward(request, response);
}
}
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Timestamp;
import java.util.List;
import javax.naming.spi.DirStateFactory.Result;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;
import Hibernate.CarsBO;
import Hibernate.Charge;
import Hibernate.ChargeBO;
import Hibernate.Parkspace;
import Hibernate.ParkspaceBO;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class register
*/
public class outmanage extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* Default constructor.
*/
public outmanage() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String userid = request.getParameter("userid");
UsersBO users = new UsersBO();
Integer id = Integer.parseInt(userid);
Users user = users.getUsers(id);
String carnum = request.getParameter("carnum");
String cardtype = request.getParameter("cardtype");
String pay = request.getParameter("cardc");
Double payd;
if(pay.length()==0){
payd = 0.0;
}
else{
payd = Double.parseDouble(pay);
}
if(userid.length()<=10&&carnum.length()<=7){
System.out.println(cardtype);
CarsBO carsbo = new CarsBO();
ChargeBO chargebo = new ChargeBO();
if(carsbo.getCars(carnum)!=null){
if(carsbo.getCars(carnum).getUsers().getId()==id){
Integer pos = carsbo.getCars(carnum).getPos();
Timestamp timein = carsbo.getCars(carnum).getTimein();
Long in = timein.getTime();
double minute = (double)((System.currentTimeMillis()-in)/(1000*60));
if(pos!=null){
ParkspaceBO parksbo = new ParkspaceBO();
Parkspace park = parksbo.getParkspace(pos);
if(carsbo.getCars(carnum).getState().indexOf("1")!=-1){
if(request.getParameter("cardtype").equals("cz")){
if(chargebo.getcharge(id)==null){
chargebo.addCharge((new UsersBO()).getUsers(id),"0");
}
Charge current = chargebo.getcharge(id);
chargebo.recharge(current,payd);
if(carsbo.getCars(carnum).getSize().indexOf("A")!=-1){
Double each = 0.17;
if(current.getBalance()>each*minute){
chargebo.updateCharges(chargebo.getcharge(id),each*minute);
parksbo.updateParkspace(park,"1");
carsbo.updateCars(carsbo.getCars(carnum),null,new Timestamp(System.currentTimeMillis()),"0");
}
}
else if(carsbo.getCars(carnum).getSize().indexOf("B")!=-1){
Double each = 0.34;
chargebo.updateCharges(chargebo.getcharge(id),each*minute);
parksbo.updateParkspace(park,"1");
carsbo.updateCars(carsbo.getCars(carnum),null,new Timestamp(System.currentTimeMillis()),"0");
}
else if(carsbo.getCars(carnum).getSize().indexOf("C")!=-1){
Double each = 0.51;
chargebo.updateCharges(chargebo.getcharge(id),each*minute);
parksbo.updateParkspace(park,"1");
carsbo.updateCars(carsbo.getCars(carnum),null,new Timestamp(System.currentTimeMillis()),"0");
}
else{
Double each = 0.68;
chargebo.updateCharges(chargebo.getcharge(id),each*minute);
parksbo.updateParkspace(park,"1");
carsbo.updateCars(carsbo.getCars(carnum),null,new Timestamp(System.currentTimeMillis()),"0");
}
}
if(request.getParameter("cardtype").equals("yz")){
if(!chargebo.IsChargeExist(id)){
chargebo.addCharge((new UsersBO()).getUsers(id),"1");
}
}
if(request.getParameter("cardtype").equals("ls")){
if(!chargebo.IsChargeExist(id)){
chargebo.addCharge((new UsersBO()).getUsers(id),"2");
}
}
}
users.updateUsersBySuper(user,1);
RequestDispatcher dispatcher = request.getRequestDispatcher("outresult.jsp");
dispatcher.forward(request, response);
}
else{
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('鏈溅涓嶅湪鏈仠杞﹀満锛?);");
out.println("history.go(-1);");
out.println("</script>");
}
}
else{
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('杞﹁締涓庣敤鎴蜂笉绗︼紒璇烽噸鏂拌緭鍏ワ紒');");
out.println("history.go(-1);");
out.println("</script>");
}
}
else{
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('杞︾墝鍙疯緭鍏ユ湁璇紒璇烽噸鏂拌緭鍏ワ紒');");
out.println("history.go(-1);");
out.println("</script>");
}
}else{//锟斤拷锟诫不一锟斤拷
//JOptionPane.showMessageDialog(null,"涓ゆ杈撳叆瀵嗙爜涓嶄竴鑷达紝璇烽噸鏂拌緭鍏?);
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('鐢ㄦ埛鍚嶄笉瓒呰繃鍗佷釜瀛楃锛岃溅鐗屽彿涓嶈秴杩囦竷涓瓧绗?);");
out.println("history.go(-1);");
out.println("</script>");
}
}
}
package servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Hibernate.Parkspace;
import Hibernate.ParkspaceBO;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class parkspace
*/
public class parkspace extends HttpServlet {
private static final long serialVersionUID = 1L;
public static int spage = 1;
/**
* @see HttpServlet#HttpServlet()
*/
public parkspace() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
ParkspaceBO parkspacebo = new ParkspaceBO();
List<Parkspace> allparkspaces = parkspacebo.getParkspace();//
request.setAttribute("allparkspaces", allparkspaces);
request.setAttribute("spage", Integer.valueOf(spage));
RequestDispatcher dispatcher = request.getRequestDispatcher("parkspace.jsp");
dispatcher.forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
ParkspaceBO parkspacebo = new ParkspaceBO();
List<Parkspace> allparkspaces = parkspacebo.getParkspace();
double tp = allparkspaces.size()-1;
int num = (int) Math.ceil(tp/8);
request.setAttribute("allparkspaces", allparkspaces);
String dir = request.getParameter("dir");
if(dir.equals("涓婁竴椤?)){
if(spage>1){
spage--;
}
}
else if(dir.equals("涓嬩竴椤?)){
if(spage<num){
spage++;
}
}
else{
String s = request.getParameter("spage");
spage = Integer.parseInt(s);
}
request.setAttribute("spage", spage);
RequestDispatcher dispatcher = request.getRequestDispatcher("parkspace.jsp");
dispatcher.forward(request, response);
}
}
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.naming.spi.DirStateFactory.Result;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class register
*/
public class register extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* Default constructor.
*/
public register() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String username = request.getParameter("username");
String password = request.getParameter("password");
String repassword = request.getParameter("repassword");
//锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷欠锟揭伙拷锟?
if(password.equals(repassword)){
String phonenum = request.getParameter("phonenumber");
Integer age = Integer.parseInt(request.getParameter("age"));
String sex = request.getParameter("sex");
String account = request.getParameter("acc");
System.out.println(account);
UsersBO usersbo = new UsersBO();
System.out.println(account);
usersbo.addUsers(username, password, phonenum, age, sex, account, new Integer(0), new Integer(0));
List<Users> result = usersbo.getUsers();
Users users=result.get(result.size()-1);
int userID = users.getId();
request.setAttribute("userID",userID);
RequestDispatcher dispatcher = request.getRequestDispatcher("succre.jsp");
dispatcher.forward(request, response);
}else{//锟斤拷锟诫不一锟斤拷
//JOptionPane.showMessageDialog(null,"涓ゆ杈撳叆瀵嗙爜涓嶄竴鑷达紝璇烽噸鏂拌緭鍏?);
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('涓ゆ杈撳叆瀵嗙爜涓嶄竴鑷达紝璇烽噸鏂拌緭鍏?);");
out.println("history.go(-1);");
out.println("</script>");
}
}
}
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;
import javax.naming.spi.DirStateFactory.Result;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;
import Hibernate.CarsBO;
import Hibernate.Parkspace;
import Hibernate.ParkspaceBO;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class register
*/
public class reserve extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* Default constructor.
*/
public reserve() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=gbk");
request.setCharacterEncoding("gbk");
response.setCharacterEncoding("gbk");
Users user =(Users)request.getSession().getAttribute("user");
Integer grade = user.getGrade();
ParkspaceBO park = new ParkspaceBO();
String carnum = request.getParameter("carnum");
List<Parkspace> list = park.getparkspace(carnum);
if(grade.equals(new Integer(1))||2-list.size()!=0){
String carsize = new String(request.getParameter("carsize").getBytes("UTF-8"), "GB2312");
String day = request.getParameter("date");
String time = new String(request.getParameter("clock").getBytes("UTF-8"), "GB2312");
String hour = time.substring(0,2);
String endhour = time.substring(6,8);
String startt = day+" "+hour+":00:00.0";
String endt = day+" "+endhour+":00:00.0";
DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss E");
format.setLenient(false);
Timestamp ts = new Timestamp(System.currentTimeMillis());
Timestamp te = new Timestamp(System.currentTimeMillis());
try {
ts = new Timestamp(format.parse(startt).getTime());
te = new Timestamp(format.parse(endt).getTime());
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
RequestDispatcher dispatcher = request.getRequestDispatcher("result.jsp");
dispatcher.forward(request, response);
}
else{
PrintWriter out = response.getWriter();
out.println("<script language=javascript>");
out.println("alert('鎮ㄤ笉鍙啀棰勮杞︿綅锛?);");
out.println("history.go(-1);");
out.println("</script>");
}
}
}
package servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Hibernate.Users;
import Hibernate.UsersBO;
/**
* Servlet implementation class usermanage
*/
public class usermanage extends HttpServlet {
private static final long serialVersionUID = 1L;
public static int page=1;
/**
* @see HttpServlet#HttpServlet()
*/
public usermanage() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
UsersBO usersbo = new UsersBO();
List<Users> allusers = usersbo.getUsers();
request.setAttribute("allusers", allusers);
request.setAttribute("page", Integer.valueOf(page));
RequestDispatcher dispatcher = request.getRequestDispatcher("usermanage.jsp");
dispatcher.forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
UsersBO usersbo = new UsersBO();
List<Users> allusers = usersbo.getUsers();
double tp = allusers.size();
int num = (int) Math.ceil(tp/8);
request.setAttribute("allusers", allusers);
String dir = request.getParameter("dir");
if(dir.equals("涓婁竴椤?)){
if(page>1){
page--;
}
}
else if(dir.equals("涓嬩竴椤?)){
if(page<num){
page++;
}
}
else{
String s = request.getParameter("page");
page = Integer.parseInt(s);
}
request.setAttribute("page", page);
RequestDispatcher dispatcher = request.getRequestDispatcher("usermanage.jsp");
dispatcher.forward(request, response);
}
}
3. jsp
<%@ page language="java" contentType="text/html; charset=utf-8" import="Hibernate.Users" import="Hibernate.Cars"
import="Hibernate.CarsBO" import="java.util.List" import="java.sql.Timestamp" import="Hibernate.ChargeBO"
import="Hibernate.Charge" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style>
table{
position: absolute;
top:200 px;
}
</style>
</head>
<body background = "img/bg3.png">
<h2><img src="img/account_data.jpg" alt="账户" width="33" height="33"/><strong> 账户信息</strong></h2>
<%
Users user =(Users)request.getSession().getAttribute("user");
Integer level = user.getGrade();
String account = user.getAccount();
ChargeBO chargebo = new ChargeBO();
Charge charge = chargebo.getCharge(user.getId());
String type = "";
if(charge!=null){
type = charge.getCardType();
}
%>
<table>
<tr>
<td>用户类别:</td>
<td><%if(level==0){ %> 普通用户<%} %>
<%if(level!=0){ %> VIP用户<%} %></td>
</tr>
<tr>
<td>账户卡号:</td>
<td>
<%if(account==null){ %>
尚无账户信息!<%} %>
<%if(account!=null){ %>
<%=account %><%} %>
</td>
</tr>
<tr>
<td>计费卡类:</td>
<td>
<%if(type==""){ %> 尚无用户卡的信息!<%} %>
<%if(type.indexOf("0")!=-1){ %> 储值卡<%} %>
<%if(type.indexOf("1")!=-1){ %> 月租卡<%} %>
<%if(type.indexOf("2")!=-1){ %> 临时卡<%} %></td>
</tr>
<tr>
<td>储值卡余额:</td>
<td>
<%if(charge==null){ %>
尚无储值卡信息!<%} %>
<%if(charge!=null){ %>
<%=charge.getBalance() %><%} %>
</td>
</tr>
<tr>
<td>警告次数:</td>
<td> <%=user.getWarnings() %></td>
</tr>
</table>
</body>
</html>
<%@ 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 'addCar.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">
-->
<script type="text/javascript">
<!--
//使用js
function checkValidate()
{
//判断车牌号是否为空
if(document.car.carnum.value==""||document.car.carnum.value==null)
{
window.alert("车牌号不能为空!!!");
return false;
}
}
-->
</script>
</head>
<body >
<center>
<h2>请输入车辆信息</h2>
<form action="" method="post" name="car">
<table border="1">
<tr><td>车牌号:</td><td><input type="text" name="carnum" maxlength=7/></td></tr>
<tr>
<td>车辆类型: </td>
<td>
<select name="carsize" style={width:153px}>
<option>A类/小型车微型车</option>
<option>B类/中型车</option>
<option>C类/中大型车</option>
<option>D类/豪华车</option>
</select>
</td>
</tr>
</table><br>
<input type="submit" value="添加车辆" οnclick="return checkValidate();"/>
<input type="button" value="取消" οnclick="window.location.href='inmanage.jsp'"/>
</form>
</center>
</body>
</html>
<%@ 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 'addCar.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">
-->
<script type="text/javascript">
<!--
//使用js
function checkValidate()
{
//判断姓名是否为空
if(document.operator.name.value==""||document.operator.name.value==null)
{
window.alert("姓名不能为空!!!");
return false;
}
//判断密码是否为空
if(document.operator.password.value==""||document.operator.password.value==null)
{
window.alert("密码不能为空!!!");
return false;
}
//判断密码是否为空
if(document.operator.repassword.value==""||document.operator.repassword.value==null)
{
window.alert("确认密码不能为空!!!");
return false;
}
//判断两次密码是否一致
if(document.operator.repassword.value!=document.operator.password.value)
{
window.alert("两次输入密码不一致!!!");
return false;
}
if(document.operator.age.value==""||document.operator.age.value==null)
{
window.alert("年龄不能为空!!!");
return false;
}
}
-->
</script>
</head>
<body >
<center>
<h2>请输入操作员信息</h2>
<form action="/NewWeb/addOperator" method="post" name="operator">
<table border="1">
<tr><td>姓名:</td><td><input type="text" name="name" maxlength=10/></td></tr>
<tr>
<td>性别: </td>
<td>
<input type="radio" name="sex" value="男" checked = "true">男</radio>
<input type="radio" name="sex" value="女">女</radio>
</td>
</tr>
<tr><td>密码:</td><td><input type="password" name="password" maxlength=10/></td></tr>
<tr><td>确认密码:</td><td><input type="password" name="repassword" maxlength=10/></td></tr>
<tr><td>年龄:</td><td><input type="text" name="age" maxlength=11/></td></tr>
<tr><td>权限等级:</td><td>
<input type="radio" name="grade" value="1" checked = "true">管理员</radio>
<input type="radio" name="grade" value="0">操作员</radio>
<br></td></tr>
</table><br>
<input type="submit" value="添加操作员" οnclick="return checkValidate();"/>
<input type="button" value="取消" οnclick="window.location.href='opmanage.jsp'"/>
</form>
</center>
</body>
</html>