cardbean.java

在线教育平台： 从小学

package edu;

import java.sql.*;

import java.text.*;
import java.util.Random;

public class CardBean {
	private int id;

	private int c_id;

	private int u_id;

	private String no;

	private String psw;

	private int day;

	private String allowday;

	private int startrow;

	private int pagesize;

	public void setStartpage(int s) {
		startrow = s;
	}

	public int getStartpage() {
		return startrow;
	}

	public void setPagesize(int s) {
		pagesize = s;
	}

	public int getPagesize() {
		return pagesize;
	}

	public void setId(int id) {
		this.id = id;
	}

	public int getId() {
		return id;
	}

	public void setNo(String no) {
		this.no = no;
	}

	public String getNo() {
		return no;
	}

	public void setDay(int day) {
		this.day = day;
	}

	public int getDay() {
		return day;
	}

	public void setPsw(String psw) {
		this.psw = psw;
	}

	public String getPsw() {
		return psw;
	}

	public void setAllowday(String allowday) {
		this.allowday = allowday;
	}

	public String getAllowday() {
		return allowday;
	}

	public void setC_id(int c_id) {
		this.c_id = c_id;
	}

	public int getC_id() {
		return c_id;
	}

	public void setU_id(int u_id) {
		this.u_id = u_id;
	}

	public int getU_id() {
		return u_id;
	}

	public ResultSet getCard() {
		String sql = "select * from card ORDER BY  c_id DESC limit " + startrow
				+ "," + pagesize + "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getCardUser() {
		String sql = "select * from carduser";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getCard(int id) {
		String sql = "select * from card where c_id='" + id + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public int getCard_Id(String no) throws SQLException {
		int c_id = 0;
		String sql = "select c_id from card where c_no='" + no + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		if (rs.next())
			c_id = rs.getInt("c_id");
		return c_id;
	}

	public int getAllow(String no) throws SQLException {
		int c_allow = 0;
		String sql = "select c_allow from card where c_no='" + no + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		if (rs.next())
			c_allow = rs.getInt("c_allow");
		return c_allow;
	}

	public int cardCount() throws SQLException {
		int number = 0;
		String sql = "select count(*) from card ";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		if (rs.next())
			number = rs.getInt(1);
		return number;
	}

	public int cardCount_unuse() throws SQLException {
		int number = 0;
		String sql = "select count(*) from card where c_allow=0";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		if (rs.next())
			number = rs.getInt(1);
		return number;
	}

	public int getCardDay(String no) throws SQLException {
		int day = 0;
		String sql = "select c_day from card where c_no='" + no + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		if (rs.next()) {
			day = rs.getInt("c_day");
		}
		return day;
	}

	public int keepDay(int u_id) throws ParseException, SQLException {
		SqlBean db = new SqlBean();
		int day = 0;
		String sql1 = "select u_allowday from user where u_id='" + u_id + "'";

		ResultSet rs_sql1 = db.executeQuery(sql1);
		if (rs_sql1.next()) {
			String allowday = rs_sql1.getString(1);
			if (allowday != null) {
				DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
				java.util.Date date = df.parse(allowday);
				java.util.Date now = new java.util.Date();
				System.out.print(date.getTime());
				if ((date.getTime() - now.getTime()) > 0)
					day = (int) ((date.getTime() - now.getTime()) / (3600 * 1000 * 24));
				else
					day = 0;

			} else
				day = 0;
		}
		return day;
	}

	public int addCardUser() {
		int mun;
		String sql1 = "insert into carduser(c_id,u_id) values('" + c_id + "','"
				+ u_id + "')";
		String sql2 = "update user  set u_allowday='" + allowday
				+ "' where u_id='" + u_id + "' ";
		String sql3 = "update card  set c_allow=1 where c_id='" + c_id + "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql1);
		db.executeInsert(sql2);
		mun = db.executeInsert(sql3);
		return mun;
	}

	public void deleteCard() {

		String sql = "delete  from card where c_id ='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeDelete(sql);
	}

	public void addCard() {
		String sql = "insert into card(c_no,c_psw,c_day)  " + "VALUES('" + no
				+ "','" + psw + "','" + day + "')";
		SqlBean db = new SqlBean();

		db.executeInsert(sql);
	}

	public String getRandom(int len) {
		// 35是因为数组是从0开始的，26个字母+10个数字
		final int maxNum = 36;
		int i; // 生成的随机数
		int count = 0; // 生成的密码的长度
		char[] str = { 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k',
				'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w',
				'x', 'y', 'z', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' };

		StringBuffer rand = new StringBuffer("");
		Random r = new Random();
		while (count < len) {
			// 生成随机数，取绝对值，防止生成负数，

			i = Math.abs(r.nextInt(maxNum)); // 生成的数最大为36-1

			if (i >= 0 && i < str.length) {
				rand.append(str[i]);
				count++;
			}
		}

		return rand.toString();
	}

	public int getCardNumber() throws SQLException {
		int number = 0;
		String sql = "select card_number from control where id=1";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		if (rs.next())
			number = rs.getInt("card_number");
		return number;
	}

	public int updateCardNumber() {

		String sql = "update control set card_number=card_number+1   where id=1";
		SqlBean db = new SqlBean();
		int f = db.executeInsert(sql);

		return f;
	}
}