getclassinfor.java

本远程教育系统是采用jsp技术配合SqlServer 2000数据库和Tomcat服务器开发的动态交互式网站。基本实现了用户管理

package condb;
import java.sql.*;
import condb.ConDB;
public class GetClassInfor{
	private	String class_id;
	private String class_name;
	private String class_password;
	private String admin_id;
	private String xuanyan;
	private boolean isExist;
	public GetClassInfor(){
		class_id = "";
		class_name = "";
		admin_id = "";
		class_password = "";
		xuanyan = "";
		isExist = false;
	}
	public void setClass_id(String class_id){
		this.class_id = class_id;
		String sql = "select * from classes where class_id='"+class_id+"'";
		ConDB condb = new ConDB();
		ResultSet rs = condb.getRs(sql);
		try{
			if(rs.next()){
				class_name = rs.getString("class_name");
				class_password = rs.getString("class_password");
				admin_id = rs.getString("admin_id");
				xuanyan = rs.getString("xuanyan");
				isExist = true;
			}
			else{
				isExist = false;
			}
		}
		catch(Exception e){
			System.err.println(e.getMessage());
		}
	}
	public String getClass_id(){
		return class_id;
	}
	public String getClass_name(){
		return class_name;
	}
	public String getClass_password(){
		return class_password;
	}
	public String getAdmin_id(){
		return admin_id;
	}
	public String getXuanyan(){
		return xuanyan;
	}
	public boolean isExist(){
		return isExist;
	}

}