package?com.action;

import?java.util.ArrayList;
import?java.util.List;

import?org.hibernate.Query;
import?org.hibernate.SQLQuery;
import?org.hibernate.Session;
import?org.hibernate.Transaction;

import?com.dao.CourseDAO;
import?com.dao.ScoreDAO;
import?com.entity.Course;
import?com.entity.Score;
import?com.entity.Student;
import?com.util.HibernateSessionFactory;
import?com.util.HibernateUtil;

public?class?ceshi?{

	/**
	?*?@param?args
	?*/
	public?static?void?main（String[]?args）?{
		//?TODO?Auto-generated?method?stub
//		ScoreDAO?dao=new?ScoreDAO（）;
//		List?all=dao.findAll（）;
//		for（Score?s:all）
//		{
//			System.out.println（s.getScoreId（）+“-----“+s.getStudent（）.getStuName（）+“-----------“+s.getScore（）+“----“+s.getCourse（）.getCouName（））;
//		}
?????	Session?session=HibernateSessionFactory.getSession（）;
?????	Transaction?tran=session.beginTransaction（）;
//		Query?query=session.createQuery（“select?count（s）??from?Student?as?s?“）;
//
//		Integer??count=（Integer）query.uniqueResult（）;
		//int?count=HibernateUtil.getRows（“select?count（*）??from?Score?as?s“）;
		
		//System.out.println（count）;
//		String?[]str={““};
//		List?list=queryByPage（““?null?1?1）;
//		for（Student?stu:list）
//		{
//			System.out.println（stu.getStuName（）+“----“）;
//		}
//		Score?scores=new?Score（）;
//		Student?stu=new?Student（）;
//		stu.setStuId（1）;
//		Course?co=new?Course（）;
//		co.setCouId（2）;
//		
//		
//		scores.setCourse（co）;
//		System.out.println（scores.getCourse（）.getCouId（））;
//		scores.setScore（99）;
//		scores.setStudent（stu）;
//		ScoreDAO?dao=new?ScoreDAO（）;
//		dao.save（scores）;
?????	?
????????String?sql?=?“update?Score??set?stuId?=?1?couId?=?:nowdatescore?=?:manager?where?scoreId?=?:orderId“;
????????Query?obj?=?session.createQuery（sql）;
????????obj.setParameter（“nowdate“?“1“）;
????????obj.setParameter（“managerId““99“）;
????????obj.setParameter（“orderId““1“）;
????????System.out.println（obj.getQueryString（））;
	}
	public?int?getLogin（String?username）
	{?
	String?sql=“select?*?from?test..Student?where?stuName=?“;
	Session?session=HibernateSessionFactory.getSession（）;
	SQLQuery?query=session.createSQLQuery（sql）.addEntity（Student.class）;
	query.setString（0username）;
	List?all=query.list（）;
	for（Student?s:all）
	{
		System.out.println（s.getStuName（）+“----“+query.uniqueResult（）.toString（））;
	}
	return?Integer.parseInt（query.uniqueResult（）.toString（））;

	}
	?public?static??List?queryByPage（String?sqlString[]?paramint?pageint?size）??
?????{??
?????????List?list=new?ArrayList（）;??
?????????Session?session=null;??
??????????try??
???????????{??
???????????????session=HibernateSessionFactory.getSession（）;
???????????????Query?query=session.createQuery（sql）;??
???????????????if（param!=null）??
???????????????{??
???????????????????for（int?i=0;i???????????????????{??
???????????????????????query.setString（iparam[i]）;????

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

?????文件???????4502??2015-10-27?14:38??StuManages\.classpath

?????文件????????576??2015-10-26?18:19??StuManages\.myhibernatedata

?????文件????????303??2015-10-27?08:58??StuManages\.mymetadata

?????文件???????1822??2015-10-27?14:38??StuManages\.project

?????文件????????364??2015-10-27?14:38??StuManages\.settings\org.eclipse.jdt.core.prefs

?????文件????????522??2015-10-27?14:38??StuManages\.settings\.jsdtscope

?????文件????????475??2015-10-27?14:38??StuManages\.settings\com.genuitec.eclipse.migration.prefs

?????文件????????556??2015-10-27?14:38??StuManages\.settings\org.eclipse.wst.common.component

?????文件????????463??2015-10-27?14:38??StuManages\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-10-27?14:38??StuManages\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-10-27?14:38??StuManages\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1067??2015-10-27?10:12??StuManages\src\hibernate.cfg.xml

?????文件????????817??2015-10-27?10:05??StuManages\src\struts.xml

?????文件???????3505??2015-10-27?16:45??StuManages\src\com\action\ceshi.java

?????文件????????196??2015-10-26?12:16??StuManages\src\com\action\LoginAction.java

?????文件???????2613??2015-10-27?16:32??StuManages\src\com\action\ScoreAction.java

?????文件???????2254??2015-10-27?12:13??StuManages\src\com\action\StuAction.java

?????文件???????1189??2015-10-26?18:16??StuManages\src\com\action\SuperAction.java

?????文件???????3975??2015-10-26?18:20??StuManages\src\com\dao\CourseDAO.java

?????文件???????3899??2015-10-26?18:20??StuManages\src\com\dao\ScoreDAO.java

?????文件???????4192??2015-10-26?19:47??StuManages\src\com\dao\StudentDAO.java

?????文件???????1452??2015-10-26?18:19??StuManages\src\com\entity\Course.java

?????文件???????1593??2015-10-27?11:06??StuManages\src\com\entity\Score.java

?????文件???????1799??2015-10-26?19:37??StuManages\src\com\entity\Student.java

?????文件????????328??2015-10-26?18:25??StuManages\src\com\util\DaseDAO.java

?????文件???????3252??2015-10-26?18:27??StuManages\src\com\util\HibernateSessionFactory.java

?????文件???????5418??2015-10-27?09:45??StuManages\src\com\util\HibernateUtil.java

?????文件????????217??2015-10-26?18:19??StuManages\src\com\util\IbaseHibernateDAO.java

?????文件?????????25??2015-10-27?14:38??StuManages\src\meta-INF\MANIFEST.MF

?????文件???????4772??2015-10-27?10:08??StuManages\WebRoot\index.jsp

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