package?com.denglu.poco;

import?java.sql.*;

public?class?common?{

	/**
	?*?@param?args
	?*?
	?*/
	String?courseid;
	int?amount;
	
	
	public?String?getCourseid（）?{
		return?courseid;
	}

	public?void?setCourseid（String?courseid）?{
		this.courseid?=?courseid;
	}
	
	public?int?getAmount（）?{
		return?amount;
	}

	public?void?setAmount（int?amount）?{
		this.amount?=?amount;
	}
	
	public?int??count（）?{
		//?TODO?Auto-generated?method?stub
		
		//user?use=new??user（）;
		
	????String?driverName?=?“com.mysql.jdbc.Driver“;
		String?strConn?=?“jdbc:mysql://localhost:3306/creat“;
				String?dbUserName?=?“root“;
				String?dbPassword?=?“root“;
				String?sql=“select?*?from?elective“;
				DriverManager?dm;
				Connection?con;
				Statement?stat;
				ResultSet?rs;
				//String?wcourse=null;
				//int?i=0;
				//?course?vcourse=new?course（）;
				//String?wcourse=vcourse.getCourseId（）;
				//String?wuser=use.getUsername（）;
				
				?sql=“select?count（distinct?username）??from?elective?where?course_id=‘“+courseid+“‘?“;
				?try?{
						//load?driver
						Class.forName（driverName）;
						//get?conn
						con?=?DriverManager.getConnection（strConn?dbUserName?dbPassword）;
						//create?statement
						stat?=?con.createStatement（）;
						//query
						rs?=?stat.executeQuery（sql）;
						//output
						while（rs.next（））?{
							
						amount=rs.getInt（1）;
					
						}
						
					}?catch?（Exception?e）?{
						//?TODO?Auto-generated?catch?block
						e.printStackTrace（）;
					}
					
				
					return?amount;
	}

	



}

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

?????文件???????3536??2003-07-01?09:25??復件?java?web實習\creat.sql

?????文件????????433??2010-06-28?22:08??復件?java?web實習\lx\.classpath

?????文件????????288??2003-07-01?08:09??復件?java?web實習\lx\.mymetadata

?????文件???????1223??2010-06-28?22:08??復件?java?web實習\lx\.project

?????文件???????1606??2003-06-30?09:14??復件?java?web實習\lx\src\com\denglu\poco\common.java

?????文件???????3140??2010-06-29?22:13??復件?java?web實習\lx\src\com\denglu\poco\course.java

?????文件????????616??2010-06-28?20:49??復件?java?web實習\lx\src\com\denglu\poco\user.java

?????文件???????2617??2003-07-01?08:50??復件?java?web實習\lx\WebRoot\add.jsp

?????文件???????8202??2010-06-30?22:11??復件?java?web實習\lx\WebRoot\addcourse.jsp

?????文件???????2829??2003-07-01?08:19??復件?java?web實習\lx\WebRoot\addcourse1.jsp

?????文件???????2855??2003-06-30?11:07??復件?java?web實習\lx\WebRoot\check.jsp

?????文件???????3979??2010-06-30?22:00??復件?java?web實習\lx\WebRoot\chooseCourse.jsp

?????文件???????1640??2010-06-30?01:15??復件?java?web實習\lx\WebRoot\delete.jsp

?????文件??????35536??2010-06-30?15:58??復件?java?web實習\lx\WebRoot\img\0b89a53cd1bae83ebaa16797.jpg

?????文件??????23006??2007-03-11?17:48??復件?java?web實習\lx\WebRoot\img\18.cur

?????文件???????1472??2010-06-30?15:54??復件?java?web實習\lx\WebRoot\img\190486_6114811_122.gif

?????文件???????9354??2010-06-30?16:00??復件?java?web實習\lx\WebRoot\img\20090422082358454.jpg

?????文件??????69374??2010-06-30?15:57??復件?java?web實習\lx\WebRoot\img\265_10170.jpg

?????文件??????27181??2010-06-30?15:59??復件?java?web實習\lx\WebRoot\img\6c468f09f87bc60de9248889.jpg

?????文件???????7994??2010-06-30?13:36??復件?java?web實習\lx\WebRoot\img\blue6.jpg

?????文件??????78214??2010-06-30?17:38??復件?java?web實習\lx\WebRoot\img\blue8.jpg

?????文件??????24797??2010-06-30?19:02??復件?java?web實習\lx\WebRoot\img\c.jpg

?????文件??????25006??2010-06-30?19:04??復件?java?web實習\lx\WebRoot\img\d.jpg

?????文件??????16294??2010-06-30?15:28??復件?java?web實習\lx\WebRoot\img\fen.jpg

?????文件??????38386??2010-06-30?17:14??復件?java?web實習\lx\WebRoot\img\green.jpg

?????文件??????14536??2010-06-30?13:15??復件?java?web實習\lx\WebRoot\img\qin.jpg

?????文件???????1282??2010-06-30?13:16??復件?java?web實習\lx\WebRoot\img\white.gif

?????文件??????16008??2010-06-30?15:56??復件?java?web實習\lx\WebRoot\img\ye.jpg

?????文件???????2287??2010-06-30?21:36??復件?java?web實習\lx\WebRoot\index.jsp

?????文件????????889??2010-06-29?13:13??復件?java?web實習\lx\WebRoot\logout.jsp

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