editbean.java

学生档案管理系统 eclipse开发 数据库用的是SQL Sever 详细见里面的说明

package Beans;
import java.sql.*;
public class EditBean implements java.io.Serializable{
	private String pwd;
	private String sex;
	private String bday;
	private String from;
	public String getPwd(){
		return pwd;
	}
	public String getSex(){
		return sex;
	}
	public String getBday(){
		return bday;
	}
	public String getFrom(){
		return from;
	}
	public void setPwd(String pwd){
		this.pwd=pwd;
	}
	public void setBday(String bday){
		this.bday=bday;
	}
	public void setSex(String sex){
		this.sex=sex;
	}
	public void setFrom(String from){
		this.from=from;
	}
	public boolean update(String id)
	{
		String sql="update Tb_Users_Info set Users_Pword='"+pwd+"',Users_Gender='"+sex+"',Users_birth_Date='"+bday+
		"',Users_From='"+from+"'"+" where Users_ID="+id;
		dbAccess.Conn Conner=new dbAccess.Conn();
		return( Conner.connectdb(sql));
	}
	public boolean select(String id)
	{
		boolean b;
		String sql="select Users_Pword,Users_Gender,Users_birth_Date,Users_From from Tb_Users_Info where Users_ID="+id;
		dbAccess.Conn Conner=new dbAccess.Conn();
		b=Conner.connectdb(sql);
		ResultSet rs=Conner.getrs();
		try
		{
			rs.next();
			this.pwd=rs.getString("Users_Pword");
			this.sex=rs.getString("Users_Gender");
			this.bday=rs.getString("Users_birth_Date");
			this.from=rs.getString("Users_From");
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
		return(b);
		
	}
}