viewbean.java

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

package Beans;

import java.sql.*;

public class ViewBean implements java.io.Serializable {
	private int uid;
	private String name="";
	private String up="";
	//private String name;
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getUid() {
		return uid;
	}
	public void setUid(int uid) {
		this.uid = uid;
	}
	public String getUp() {
		return up;
	}
	public void setUp(String up) {
		this.up = up;
	}
	public ResultSet getrs(String id)
	{
		String sql="select Users_Name,Tot_Sco.*,Tb_Class.* from Tb_Users_Info,Tot_Sco,Tb_Class where Tb_Users_Info.Users_ID=Tot_Sco.Users_ID and Tb_Users_Info.Std_ClsID=Tb_Class.class_ID and (Mater="+
			id+" or Helper="+id+")";
		if (uid!=0) sql+=" and Tb_Users_Info.Users_ID="+String.valueOf(uid);
		
		if (!name.equals("")) sql+=" and Users_Name='"+name+"'";
		
		sql+=" order by Score ";
		if(up.equals("ON"))sql+="asc";else sql+="desc";
		dbAccess.Conn Conner=new dbAccess.Conn();
		ResultSet rs=null;
		Conner.connectdb(sql);
		rs=Conner.getrs();
		return(rs);

	}



}