package?com.bean.dal;

import?java.sql.CallableStatement;
import?java.sql.Connection;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.sql.Types;

import?com.bean.dbutility.Connect;
import?com.bean.model.Score;
public?class?SscoreDal?{

	public?String?insertScore（int?StuNOint?stuNameint?Subscore）{
		String?sql=“{call?proc_insertScore（???）}“;
		Connection?conn=Connect.openOracleConnection（）;
		CallableStatement?proc=null;
		
		if（conn==null）{
			return?null;
		}else{
			try?{
				proc=conn.prepareCall（sql）;
				proc.setInt（1StuNO）;
				proc.setInt（2?stuName）;
				proc.setInt（3?Subscore）;
				
				proc.execute（）;
				return?null;
				
			}?catch?（SQLException?e）?{
				return?null;
			}finally{
				Connect.closeConnection（conn?proc）;
			}
		}
	}
	public?Score?getScore（String?columnsString?i）{
		String?sql=String.format（“select?*?from?Score?where?%s=‘%s‘“columns?i）;
		Score?score=null;
		ResultSet?rs=Connect.executeSelect（sql）;
		
		try?{
			if（rs.next（））{
				score=new?Score（）;
				score.setForStuNo（rs.getInt（“forStuNo“））;
				score.setForStuNo（rs.getInt（“forStuNo“））;
				score.setForSubId（rs.getInt（“forSubId“））;
				score.setSScore（rs.getInt（“score“））;
				score.setCreateTime（rs.getString（“createTime“））;
				return?score;
			}else{
				return?null;
			}
		}?catch?（SQLException?e）?{
			return?null;
		}
		
	}
	
	
	public?int?updateScore（String?sidString?forsubnoString?score）{
		String?sql=“{call?proc_updateScore（????）}“;
		Connection?conn=Connect.openOracleConnection（）;
		CallableStatement?proc=null;
		
		if（conn==null）{
			return?-1;
		}else{
			try?{
				proc=conn.prepareCall（sql）;
				proc.setString（1?sid）;
				proc.setString（2?forsubno）;
				proc.setString（3?score）;
				proc.registerOutParameter（4?Types.INTEGER）;
				
				proc.execute（）;

				int?returns=proc.getInt（5）;
				
				if（returns==-1）{
					return?-1;
				}else{
					return?returns;
				}

				
			}?catch?（SQLException?e）?{
				return?-2;
			}
			
			
		}
	
		
	}

}

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

?????文件???????4576??2010-08-27?00:25??Myitems（jsp+Oracle）\orelec.txt

?????文件????????458??2010-08-22?19:35??Myitems（jsp+Oracle）\StudentSystem\.classpath

?????文件????????312??2011-04-12?15:30??Myitems（jsp+Oracle）\StudentSystem\.mymetadata

?????文件???????1419??2010-08-18?15:23??Myitems（jsp+Oracle）\StudentSystem\.project

?????文件????????500??2010-08-17?14:09??Myitems（jsp+Oracle）\StudentSystem\.settings\.jsdtscope

?????文件????????330??2010-08-17?14:09??Myitems（jsp+Oracle）\StudentSystem\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2010-08-17?14:09??Myitems（jsp+Oracle）\StudentSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-08-17?14:09??Myitems（jsp+Oracle）\StudentSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2127??2010-08-26?17:49??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\dal\SscoreDal.java

?????文件???????4360??2010-08-27?09:49??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\dal\StuInfoDal.java

?????文件???????1524??2010-08-24?00:52??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\dal\SubjectDal.java

?????文件???????4627??2010-08-27?09:50??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\dbutility\Connect.java

?????文件????????799??2010-08-24?00:28??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\model\Score.java

?????文件????????877??2010-08-17?15:29??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\model\StuInfo.java

?????文件????????640??2010-08-17?15:28??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\model\Subject.java

?????文件???????1022??2010-08-26?20:52??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\modelForView\View_ScoreInfo.java

?????文件????????729??2010-08-26?20:52??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\modelForView\View_selectstuInfo.java

?????文件????????363??2010-08-22?18:43??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\test\Testing.java

?????文件???????1044??2010-08-27?10:36??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\viewDal\StuInfoView.java

?????文件???????1104??2010-08-27?10:02??Myitems（jsp+Oracle）\StudentSystem\src\com\bean\viewDal\SubScoreInfo.java

?????文件???????1038??2010-08-25?09:22??Myitems（jsp+Oracle）\StudentSystem\src\net\servlet\daoupdate.java

?????文件???????1091??2010-08-26?20:57??Myitems（jsp+Oracle）\StudentSystem\src\net\servlet\forward\SetForwards.java

?????文件???????1292??2010-08-24?08:54??Myitems（jsp+Oracle）\StudentSystem\src\net\servlet\InsertScore.java

?????文件???????1912??2010-08-26?23:45??Myitems（jsp+Oracle）\StudentSystem\src\net\servlet\Login.java

?????文件????????940??2010-08-26?17:48??Myitems（jsp+Oracle）\StudentSystem\src\net\servlet\UpdateScore.java

?????文件???????1187??2010-08-26?20:52??Myitems（jsp+Oracle）\StudentSystem\src\net\servlet\ViewStuInfoAll.java

?????文件???????1094??2010-08-26?20:52??Myitems（jsp+Oracle）\StudentSystem\src\net\servlet\View_Score.java

?????文件????????482??2010-08-18?15:19??Myitems（jsp+Oracle）\StudentSystem\WebRoot\error.jsp

?????文件?????120555??2010-08-23?23:12??Myitems（jsp+Oracle）\StudentSystem\WebRoot\html\images\all.jpg

?????文件??????39213??2010-08-23?08:37??Myitems（jsp+Oracle）\StudentSystem\WebRoot\html\images\background.jpg

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