apply.java

来自「NTsky新闻发布v1.0(提供JavaBean)」· Java 代码 · 共 121 行

package ntsky.news;

import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import ntsky.database.*;
import ntsky.common.*;

public class Apply{
	private String user = null;
	private String passwd = null;
	private String passwdvalidate = null;
	private int sex;
	private String question = null;
	private String answer = null;
	private String email = null;
	private String qq = null;
	private String http = null;
	private int total;

	//用户名
	public String user(String user){
		this.user = CodeFilter.toHtml(user);
		return this.user;
	}

	//密码
	public String passwd(String passwd){
		this.passwd = CodeFilter.toHtml(passwd);
		return this.passwd;
	}

	//重复密码
	public String passwdvalidate(String passwdvalidate){
		this.passwdvalidate = CodeFilter.toHtml(passwdvalidate);
		return this.passwdvalidate;
	}
	
	//性别
	public int sex(int sex){
		this.sex = sex;
		return this.sex;
	}

	//问题
	public String question(String question){
		this.question = CodeFilter.toHtml(question);
		return this.question;
	}

	//答案
	public String answer(String answer){
		this.answer = CodeFilter.toHtml(answer);
		return this.answer;
	}

	//E-mail
	public String email(String email){
		this.email = CodeFilter.toHtml(email);
		return this.email;
	}
	
	//QQ
	public String qq(String qq){
		this.qq = CodeFilter.toHtml(qq);
		return this.qq;
	}

	//http
	public String http(String http){
		this.http = CodeFilter.toHtml(http);
		return this.http;
	}

	//判断可行
	public int countUser(){
		String sql = "select count(*) as total from usr where user=?;";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setString(1,user);
			ResultSet rs = dbc.executeQuery();
			rs.next();
			total = rs.getInt("total");
			rs.close();
			rs = null;
		}
		catch(Exception e){
			System.out.println("countUser() "+e.getMessage());	
		}
		return total;
	}
	//插入数据
	public void insertapply(){
		String sql = "insert into usr(user,passwd,passwdvalidate,sex,question,answer,email,qq,http,loadtime) values(?,?,?,?,?,?,?,?,?,now());";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setString(1,user);
			dbc.setString(2,passwd);
			dbc.setString(3,passwdvalidate);
			dbc.setInt(4,sex);
			dbc.setString(5,question);
			dbc.setString(6,answer);
			dbc.setString(7,email);
			dbc.setString(8,qq);
			dbc.setString(9,http);
			dbc.executeUpdate();
		}
		catch(Exception e){
			System.out.println("insertapply" +e.getMessage());	
		}
	}
	//返回到个人区
	public void rdtPersonal(HttpServletResponse response,String url){
		try{
			response.sendRedirect(url);			
		}
		catch(Exception e){
			System.out.println("rdtaddarticle" +e.getMessage());
		}
	}
}