userupdate.java

是一个JSP与数据库应用系统

package User;

import java.sql.*;
import database.conn;

public class Userupdate
{
	private String UserName;
	private String UserPwd;
	private String Question;
	private String Answer;
	private String Sex;
	private String Phone;
	private String Email;
	private String Postcode;
	private String LockUser;
	private int id;
	
	conn cn = new conn();
	
	public Userupdate()
	{
		UserName = "";
		UserPwd = "";
		Question = "";
		Answer = "";
		Sex = "";
		Phone = "";
		Email = "";
		Postcode = "";
		LockUser = "";
	}
	
	public void setId(int id)
	{
		this.id = id;
	}
	public String getUserName()
	{
		return UserName;
	}
	public String getUserPwd()
	{
		return UserPwd;
	}
	public String getQuestion()
	{
		return Question;
	}
	public String getAnswer()
	{
		return Answer;
	}
	public String getSex()
	{
		return Sex;
	}
	public String getPhone()
	{
		return Phone;
	}
	public String getEmail()
	{
		return Email;
	}
	public String getPostcode()
	{
		return Postcode;
	}
	public String getLockUser()
	{
		return LockUser;
	}
	public void getUser()
	{
		try
		{
			String strsql = "select * from C_User where id = "+id+"";
			ResultSet rs = cn.executeQuery(strsql);
			if(rs.next())
            {
            	UserName = rs.getString("UserName");
				UserPwd = rs.getString("UserPwd");
				Question = rs.getString("Question");
				Answer = rs.getString("Answer");
				Sex = rs.getString("Sex");
				Phone = rs.getString("Phone");
				Email = rs.getString("Email");
				Postcode = rs.getString("Postcode");
				LockUser = rs.getString("LockUser");
            }
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}