updatestudent.java

JB做的竞卖管理

package beans;
import beans.*;
import java.sql.*;
public class updateStudent {

	private String stu_id;
	private String stu_name;
	private String password;
	private String jiguan;
	private String department;	
	private int mark;
	private String tel;
	private String e_mail;
	
	//beans
	public String getDepartment() {
		return department;
	}
	public void setDepartment(String department) {
		this.department = department;
	}
	public String getE_mail() {
		return e_mail;
	}
	public void setE_mail(String e_mail) {
		this.e_mail = e_mail;
	}
	public String getJiguan() {
		return jiguan;
	}
	public void setJiguan(String jiguan) {
		this.jiguan = jiguan;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getStu_id() {
		return stu_id;
	}
	public void setStu_id(String stu_id) {
		this.stu_id = stu_id;
	}
	public String getStu_name() {
		return stu_name;
	}
	public void setStu_name(String stu_name) {
		this.stu_name = stu_name;
	}
	public String getTel() {
		return tel;
	}
	public void setTel(String tel) {
		this.tel = tel;
	}
	
	
	public int getMark() {
		return mark;
	}
	public void setMark(int mark) {
		this.mark = mark;
	}
	public void update() {
		sqlBean bean = new sqlBean();
		String sql = "select * from student where id = '" + stu_id + "'";
		ResultSet rs = bean.executeQuery(sql);
		try {
			if(rs.next()) {
				setStu_id(rs.getString(1));
				setStu_name(rs.getString(2));
				setPassword(rs.getString(3));
				setJiguan(rs.getString(4));
				setDepartment(rs.getString(5));
				setMark(rs.getInt(7));
				setTel(rs.getString(8));
				setE_mail(rs.getString(9));

			} 
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	

	
	
}