tusertable.java

《短信平台系统》向注册用户提供向指定手机或通讯录中手机发送短信的功能

package com.ascenttech.hib.po;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import com.ascenttech.hib.vo.HibernateSessionFactory;
import com.ascenttech.hib.vo.t_user.TUser;
import com.ascenttech.hib.vo.t_user.TUserId;
import com.ascenttech.shi.LuanMa;
import com.ascenttech.struts.form.ZhuceForm;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;

public class TUserTable {
	private String number;

	private String password;

	public TUserTable() {
	}

	// 验证卡号密码用
	List list;

	Query query;

	// 卡号密码验证方法
	public SucessBean login() {

		SucessBean sb = null;
		Transaction ts = null;
		String dateok = null;
		String priceok = null;
		try {
			Session session = HibernateSessionFactory.currentSession();
			ts = session.beginTransaction();

			query = session.createQuery("from TUser as t where t.id='" + number
					+ "'and t.password='" + password + "'");

			if (query != null) {
				list = query.list();

				if (list.size() > 0) {
					TUser tu = (TUser) list.get(0);
					TUserId ti = tu.getId();
					String loginname = ti.getLoginname();
					String subport = tu.getSubport();

					sb = new SucessBean(loginname, subport);
					return sb;
					// 验证卡号密码不存在，进行下列操作
				} else {

					return sb;
				}

			}
			ts.commit();
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			ts.rollback();
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return sb;
	}

	public TUserTable(String number, String password) {
		super();
		// TODO Auto-generated constructor stub
		this.number = number;
		this.password = password;
	}

	// 注册用方法
	public String insertTUser(ZhuceForm zf) {
		Long id = (Long) zf.getUserid();
		String lname = (String) zf.getLoginname();
		String p = (String) zf.getPassword();
		String uname = (String) zf.getUsername();
		String sex = (String) zf.getSex();
		Integer age = (Integer) zf.getAge();
		String ed = (String) zf.getEducation();
		String job = (String) zf.getJob();
		String phone = (String) zf.getPhone();
		String cell = (String) zf.getCell();
		String com = (String) zf.getCompany();
		String add = (String) zf.getAddress();
		String sb = (String) zf.getSubport();
		String pc = (String) zf.getPostcode();

		// 插入成功返回值
		String insertok = null;

		// 验证用户唯一性返回值
		String l = loginnameTest(lname);

		// 验证唯一性Subport
		String s = subportTest(sb);
		// 当用户和下标都不存在是才可以注册
		if (l.equals("no") & s.equals("no")) {
			Transaction ts = null;

			TUserId uid = new TUserId();// 保存loginname
			TUser t = new TUser();// 保存loginname

			t.setUserid(id);
			uid.setLoginname(lname);

			t.setPassword(p);
			t.setUsername(uname);
			t.setSex(sex);
			t.setAge(age);
			t.setEducation(ed);
			t.setJob(job);
			t.setPhone(phone);
			t.setCell(cell);
			t.setCompany(com);
			t.setAddress(add);
			t.setSubport(sb);
			t.setPostcode(pc);
			t.setId(uid);// 保存loginname

			try {
				Session session = HibernateSessionFactory.currentSession();
				ts = session.beginTransaction();
				session.save(t);

				ts.commit();

			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				ts.rollback();
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

			try {
				Session session = HibernateSessionFactory.currentSession();
				ts = session.beginTransaction();
				Query query = session
						.createQuery("from TUser as t where  loginname='"
								+ lname + "'and password='" + p
								+ "' and subport='" + sb + "'");

				if (query != null) {
					List list = query.list();
					if (list.size() > 0) {
						insertok = "ok";

						return insertok;

					} else {
						insertok = "no";
						return insertok;
					}
				}
				ts.commit();

			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				ts.rollback();
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} else {
			insertok = "no";
			return insertok;
		}
		return insertok;
	}

	// 验证用户唯一性
	public String loginnameTest(String loginname) {

		String logok = null;
		Transaction ts = null;
		try {
			Session session = HibernateSessionFactory.currentSession();
			ts = session.beginTransaction();
			Query query = session
					.createQuery("from TUser as t where  loginname='"
							+ loginname + "'");

			if (query != null) {
				List list = query.list();
				if (list.size() > 0) {
					logok = "ok";

					return logok;

				} else {
					logok = "no";
					return logok;
				}
			}
			ts.commit();

		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			ts.rollback();
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return logok;
	}

	// 验证唯一性Subport
	public String subportTest(String subport) {

		String logok = null;
		Transaction ts = null;
		try {
			Session session = HibernateSessionFactory.currentSession();
			ts = session.beginTransaction();
			Query query = session
					.createQuery("from TUser as t where  t.subport='" + subport
							+ "'");

			if (query != null) {
				List list = query.list();
				if (list.size() > 0) {
					logok = "ok";

					return logok;

				} else {
					logok = "no";
					return logok;
				}
			}
			ts.commit();

		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			ts.rollback();
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return logok;
	}
}