package?bean;

import?java.sql.*;

import?bean.sqlBean;

public?class?course?{
	private?String?cid;
	private?String?clnum;
	private?String?cname;
	private?double?credit;
	private?int?capacity;
	public?String?getCid（）?{
		return?cid;
	}
	public?void?setCid（String?cid）?{
		this.cid?=?cid;
	}
	public?String?getClnum（）?{
		return?clnum;
	}
	public?void?setClnum（String?clnum）?{
		this.clnum?=?clnum;
	}
	public?String?getCname（）?{
		return?cname;
	}
	public?void?setCname（String?cname）?{
		this.cname?=?cname;
	}
	public?double?getCredit（）?{
		return?credit;
	}
	public?void?setCredit（double?credit）?{
		this.credit?=?credit;
	}
	
	public?int?getCapacity（）?{
		return?capacity;
	}
	public?void?setCapacity（int?capacity）?{
		this.capacity?=?capacity;
	}
	public?ResultSet?getCourse（）{
		String?sql=“select?*?from?course“;
		sqlBean?db=new?sqlBean（）;
		ResultSet?rs=db.executeQuery（sql）;
		return?rs;
	}
	public?ResultSet?getCinfo（String?cid）{
	????String?sql=“select?*?from?course?where?cid=‘“+cid+“‘“;
	????sqlBean?db=new?sqlBean（）;
	????ResultSet?rs=db.executeQuery（sql）;
	????return?rs;
	}
	public?boolean?isValid（String?cno）{
		boolean?f=true;
		String?sql=“select?cid?from?course?where?cid=‘“+cno+“‘“;
		sqlBean?db=new?sqlBean（）;
		try{
			ResultSet?rs=db.executeQuery（sql）;
			if（rs.next（））{
				f=true;
			}
			else{
				f=false;
				}
		}
		catch（Exception?e）{
			e.getMessage（）;
		}
		return?f;
		
	}
	public?void?addCourse（）{
		String?sql=“insert?into?course（cidclnumcnamecreditcapacity）?values?（‘“+cid+“‘‘“+clnum+“‘‘“+cname+“‘“+credit+““+capacity+“）“;
		sqlBean?db=new?sqlBean（）;
		db.executeInsert（sql）;
	}
	public?int?delcourse（String?cno）{
		int?num=0;
		String?sql=“delete?from?course?where?cid=‘“+cno+“‘“;
		sqlBean?db=new?sqlBean（）;
		num=db.executeDelete（sql）;
		return?num;
	}
	public?void?updateCourse（）{
		String?sql=“update?course?set?cid=‘“+cid+“‘clnum=‘“+clnum+“‘cname=‘“+cname+“‘credit=“+credit+“capacity=“+capacity
		+“?where?cid=‘“+cid+“‘“;
		sqlBean?db=new?sqlBean（）;
		db.Update（sql）;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1230??2009-12-10?14:03??stu_score_ms\.project

?????文件????????309??2009-12-10?13:57??stu_score_ms\.mymetadata

?????文件????????433??2009-12-10?13:57??stu_score_ms\.classpath

?????文件???????2039??2009-12-12?09:00??stu_score_ms\WebRoot\index.jsp

?????文件????????902??2010-01-05?23:08??stu_score_ms\WebRoot\errorpage.jsp

?????文件????????880??2009-12-29?23:46??stu_score_ms\WebRoot\exist.jsp

?????文件???????2254??2010-01-01?00:09??stu_score_ms\WebRoot\login.jsp

?????文件??????85793??2009-12-10?12:10??stu_score_ms\WebRoot\星期.gif

?????文件??????99338??2008-12-14?21:52??stu_score_ms\WebRoot\1.jpg

?????文件??????41768??2009-12-31?19:18??stu_score_ms\WebRoot\2.jpg

?????文件???????1056??2010-01-06?13:14??stu_score_ms\WebRoot\student\s1.jsp

?????文件???????1692??2010-01-06?13:16??stu_score_ms\WebRoot\student\s2.jsp

?????文件????????923??2010-01-05?23:53??stu_score_ms\WebRoot\student\s3.jsp

?????文件???????1100??2009-12-19?09:55??stu_score_ms\WebRoot\student\student.jsp

?????文件???????1659??2010-01-05?23:49??stu_score_ms\WebRoot\student\updateSpassword.jsp

?????文件???????2937??2010-01-06?12:52??stu_score_ms\WebRoot\student\searchmyself.jsp

?????文件???????1126??2010-01-05?23:48??stu_score_ms\WebRoot\student\searchothers.jsp

?????文件???????2372??2010-01-05?23:48??stu_score_ms\WebRoot\student\searchoneself1.jsp

?????文件???????2061??2010-01-05?23:48??stu_score_ms\WebRoot\student\showstucou.jsp

?????文件???????2063??2010-01-05?23:48??stu_score_ms\WebRoot\student\selectcourse.jsp

?????文件???????1245??2009-12-16?22:57??stu_score_ms\WebRoot\manager\delteacher.jsp

?????文件????????993??2010-01-01?00:13??stu_score_ms\WebRoot\manager\m1.jsp

?????文件???????2215??2010-01-05?23:28??stu_score_ms\WebRoot\manager\m2.jsp

?????文件????????878??2009-12-31?23:59??stu_score_ms\WebRoot\manager\m3.jsp

?????文件???????1033??2009-12-17?23:51??stu_score_ms\WebRoot\manager\manager.jsp

?????文件???????2397??2010-01-05?23:39??stu_score_ms\WebRoot\manager\showcourse.jsp

?????文件???????2796??2010-01-05?23:35??stu_score_ms\WebRoot\manager\showstudent.jsp

?????文件???????2004??2010-01-05?23:37??stu_score_ms\WebRoot\manager\showteacher.jsp

?????文件???????1680??2010-01-05?23:09??stu_score_ms\WebRoot\manager\updateMpassword.jsp

?????文件???????2910??2010-01-05?23:40??stu_score_ms\WebRoot\manager\addcourse.jsp

............此處省略208個文件信息