package?classman;
import?db.dbconn;
import?util.stringUtil;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.Statement;
import?java.sql.ResultSet;
/**
?*?封裝對班級表的所有操作
?*?@author?鄧子云
?*/
public?class?class_operation{
???/**
????*?功能:往班級表增加一條記錄
????*?輸入參數:class_name為班級名稱
????*?輸出:返回1表成功，返回2表數據連接參數配置不正確或連接數據庫失敗或數據庫操作失敗，
????*?返回3表此班級已存在，返回4表輸入參數class_name為空;
????*/
???public?int?class_add_one（String?class_name）{
???????dbconn?dbconnobject=new?dbconn（）;//數據庫連接對象
???????String?sqlString=null;//SQL語句字符串
???????ResultSet?rs=null;//結果記錄集
???????Connection?dbconn=dbconnobject.getDBConn（）;//得到數據庫連接
???????if（dbconn==null）?return?2;//連接失敗
???????//--------輸入參數不正確---------
???????if（class_name==null||class_name.trim（）.length（）==0）
??????????return?4;
???????//--------輸入參數編碼轉換-------
???????stringUtil?stringCode=new?stringUtil（）;
???????class_name=stringCode.codeToString（class_name.trim（））;
???????//--------插入記錄，先判斷是否已存在------
???????sqlString=“select?*?from?class?where?class_name=?“;
???????try{
??????????PreparedStatement?preSQLSelect=dbconn.prepareStatement（sqlString）;
??????????preSQLSelect.setString（1class_name）;
??????????rs=preSQLSelect.executeQuery（）;
??????????if（rs.next（））?return?3;//已存在此班級
??????????sqlString=“insert?into?class（class_name）?values（?）“;
??????????PreparedStatement?preSQLInsert=dbconn.prepareStatement（sqlString）;
??????????preSQLInsert.setString（1class_name）;
??????????preSQLInsert.executeUpdate（）;
??????????return?1;
????????}catch（Exception?e）{
??????????System.out.print（e）;
??????????return?2;
????????}?????????????
???}
???/**
????*?功能:查詢出所有的班級
????*?輸入參數：無
????*?輸出:所有班級的記錄集如果沒有記錄或操作失敗返回null
????*/
???public?ResultSet?class_select_all（）{
???????String?sqlString=null;//SQL語句字符串
???????Statement?sql=null;//SQL語句對象
???????ResultSet?rs=null;//結果記錄集
???????dbconn?dbconnobject=new?dbconn（）;//數據庫連接對象
???????Connection?dbconn=dbconnobject.getDBConn（）;//得到數據庫連接
???????if（dbconn==null）?return?null;//連接失敗
???????try{
??????????//-------查詢出數據------------
??????????sqlString=“select?*?from?class“;?
??????????sql=dbconn.createStatement（ResultSet.TYPE_SCROLL_SENSITIVE?ResultSet.CONCUR_READ_ONLY）;
??????????rs=sql.executeQuery（sqlString）;
??????????return?rs;
???????}catch（Exception?e）{
??????????System.out.print（e）;
??????????return?null;
???????}??
???}
???/**
????*?功能：刪除一個班級的信息
????*?輸入參數：班級的ID號
????*?輸出：返回1表成功，返回2表數據連接參數配置不正確或連接數據庫失敗，
????*?返回4表輸入參數class_id為0，即輸入參數不正確
????*/
???public?int?class_delete（int?class_id）{
???????String?sqlString=null;//SQL語句字符串
???????ResultSet?rs=null;//結果記錄集
???????dbconn?dbconnobject=new?dbconn（）;//數據庫連接對象
???????Connection?dbconn=dbconnobject.getDBConn（）;//得到數據庫連接
???????if（dbconn==null）?return?2;//連接失敗
???????if（class_id==0）?return?4;//輸入參數不正確
???????//---------刪除數據--------------
???????sqlString=“delete?from?class?where?class_id=?“;
???????try{
???????????PreparedStatement?preSQLDelete=dbco

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-06-15?09:25??chengji\
?????目錄???????????0??2012-11-19?09:56??chengji\chengji\
?????文件????????1054??2012-11-19?10:51??chengji\chengji\.classpath
?????目錄???????????0??2014-07-03?11:19??chengji\chengji\.myeclipse\
?????文件?????????294??2012-11-19?09:56??chengji\chengji\.mymetadata
?????文件????????1225??2007-12-03?10:07??chengji\chengji\.project
?????目錄???????????0??2012-11-19?09:56??chengji\chengji\WebRoot\
?????目錄???????????0??2012-11-19?09:56??chengji\chengji\WebRoot\meta-INF\
?????文件??????????39??2007-12-03?10:02??chengji\chengji\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2012-11-19?09:56??chengji\chengji\WebRoot\WEB-INF\
?????文件???????10763??2007-12-03?10:01??chengji\chengji\WebRoot\WEB-INF\c-1_0-rt.tld
?????文件???????11310??2007-12-03?10:01??chengji\chengji\WebRoot\WEB-INF\c-1_0.tld
?????文件???????15999??2007-12-03?10:01??chengji\chengji\WebRoot\WEB-INF\c.tld
?????目錄???????????0??2012-11-19?10:51??chengji\chengji\WebRoot\WEB-INF\classes\
?????目錄???????????0??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\classman\
?????文件????????3683??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\classman\class_operation.class
?????目錄???????????0??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\core\
?????文件????????8256??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\core\core_operation.class
?????目錄???????????0??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\db\
?????文件????????2264??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\db\dbconn.class
?????文件?????????164??2012-11-19?10:51??chengji\chengji\WebRoot\WEB-INF\classes\dbconn.properties
?????目錄???????????0??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\lessionman\
?????文件????????4340??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\lessionman\classlession_operation.class
?????文件????????3737??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\lessionman\lession_operation.class
?????目錄???????????0??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\pic\
?????文件????????2208??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\pic\corePieChart.class
?????目錄???????????0??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\studentman\
?????文件????????4752??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\studentman\student_operation.class
?????目錄???????????0??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\teacherman\
?????文件????????4196??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\teacherman\teacher_operation.class
?????目錄???????????0??2002-01-01?01:09??chengji\chengji\WebRoot\WEB-INF\classes\teachlessionman\
............此處省略133個文件信息