欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久

 <Context path="/hibernate" docBase="hibernate" debug="0" reloadable="true" crossContext="true"> 
 <Resource name="jdbc/hibernate" auth="Container" type="javax.sql.DataSource"/> 
 <ResourceParams name="jdbc/hibernate"> 
 <parameter> 
 <name>factory</name> 
 <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> 
 </parameter>
 <parameter> 
 <name>driverClassName</name> 
 <value>org.gjt.mm.mysql.Driver</value> 
 </parameter> 
 <parameter> 
 <name>url</name> 
 <value>jdbc:mysql:///test</value> 
 </parameter> 
 <parameter> 
 <name>username</name> 
 <value>root</value> 
 </parameter> 
 <parameter> 
 <name>password</name> 
 <value></value> 
 </parameter> 
 <parameter> 
 <name>maxActive</name> 
 <value>20</value> 
 </parameter>
 <parameter> 
 <name>maxIdle</name> 
 <value>10</value>
 </parameter> 
 <parameter> 
 <name>maxWait</name> 
 <value>-1</value> 
 </parameter> 
 </ResourceParams> 
 </Context>
 

 <!DOCTYPE hibernate-configuration
 PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
 "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
 
 <hibernate-configuration>
 <session-factory>
 <property name="connection.datasource">java:comp/env/jdbc/hibernate</property>
 <property name="show_sql">false</property>
 <property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
 
 <!-- Mapping files -->
 
 </session-factory>
 
 </hibernate-configuration>
 

 package com.hellking.study.hibernate;
 
 import java.util.Set;
 
 /**
 *在hibernate中代表了Course表的類(lèi)。
 */
 public class Course 
 {
 /**每個(gè)屬性和表的一個(gè)字段對應**/
 private String id;
 private String name;
 
 /**students表示course中的學(xué)生，在后面才會(huì )用到，暫時(shí)不管**/
 private Set students;
 
 /**屬性的訪(fǎng)問(wèn)方法**/
 public void setId(String string) {
 id = string;
 }
 
 public String getId() {
 return id;
 }
 
 public void setName(String name)
 {
 this.name=name;
 }
 public String getName()
 {
 return this.name;
 }
 public void setStudents(Set stud)
 {
 this.students=stud;
 }
 public Set getStudents()
 {
 return this.students;
 }
 }
 

 <?xml version="1.0"?>
 <!DOCTYPE hibernate-mapping PUBLIC
 "-//Hibernate/Hibernate Mapping DTD 2.0//EN" 
 "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
 
 <hibernate-mapping>
 <class
 name="com.hellking.study.hibernate.Course"
 table="Courses"
 dynamic-update="false"
 >
 
 <id
 name="id"
 column="CourseId"
 type="string"
 unsaved-value="any"
 >
 <generator class="assigned"/>
 </id>
 
 <property
 name="name"
 type="string"
 update="true"
 insert="true"
 column="Name"
 /> 
 </class>
 </hibernate-mapping>
 

 <session-factory>
 …
 <!-- Mapping files --> 
 <mapping resource="Course.hbm.xml"/>
 </session-factory>
 

 package com.hellking.study.hibernate;
 
 import net.sf.hibernate.*;
 import net.sf.hibernate.cfg.*;
 import java.util.*;
 import java.io.IOException;
 import java.io.PrintWriter;
 
 public abstract class HibernateBase 
 {
 protected SessionFactory sessionFactory;//會(huì )話(huà)工廠(chǎng)，用于創(chuàng  )建會(huì )話(huà)
 protected Session session;//hibernate會(huì )話(huà)
 protected Transaction transaction; //hiberante事務(wù)
 
 public HibernateBase()throws HibernateException
 {
 this.initHibernate();
 }
 // 幫助方法
 protected void initHibernate()
 throws HibernateException {
 
 // 裝載配置，構造SessionFactory對象
 sessionFactory = new Configuration().configure().buildSessionFactory();
 }
 
 /**
 *開(kāi)始一個(gè)hibernate事務(wù)
 */
 protected void beginTransaction()
 throws HibernateException {
 
 session = sessionFactory.openSession();
 transaction = session.beginTransaction();
 }
 
 /**
 *結束一個(gè)hibernate事務(wù)。
 */
 protected void endTransaction(boolean commit)
 throws HibernateException {
 
 if (commit) {
 transaction.commit();
 } else {
 //如果是只讀的操作，不需要commit這個(gè)事務(wù)。
 transaction.rollback();
 }
 session.close();
 }
 }
 

 package com.hellking.study.hibernate;
 
 import net.sf.hibernate.*;
 import net.sf.hibernate.cfg.*;
 import java.util.*;
 
 /**
 *和course相關(guān)的業(yè)務(wù)邏輯
 */
 public class CourseBean extends HibernateBase
 {
 public CourseBean()throws HibernateException
 {
 super();
 }
 /**
 *增加一個(gè)Course
 */
 public void addCourse(Course st)throws HibernateException
 {
 beginTransaction();
 session.save(st); 
 endTransaction(true);
 }
 
 /**
 *查詢(xún)系統中所有的Course，返回的是包含有Course持久對象的Iterator。
 */
 public Iterator getAllCourses()throws HibernateException
 {
 String queryString = "select courses from Course as courses";
 beginTransaction();
 Query query = session.createQuery(queryString);
 Iterator it= query.iterate();
 return it;
 }
 
 /**
 *刪除給定ID的course
 */
 public void deleteCourse(String id)throws HibernateException
 {
 beginTransaction(); 
 Course course=(Course)session.load(Course.class,id); 
 session.delete(course);
 endTransaction(true);
 }
 
 /**
 *按course的名字進(jìn)行模糊查找，返回的是包含有Course持久對象的Iterator。
 */
 public Iterator getSomeCourse(String name)throws HibernateException
 {
 String queryString = "select c from Course as c where c.name like :name" ;
 beginTransaction();
 Query query = session.createQuery(queryString);
 query.setString("name", "%"+name+"%");
 Iterator it= query.iterate();
 return it;
 } 
 }
 

 session.save(Course);
 

 Connection con=…
 Statement stmt=con.createStatement();
 stmt.executeUpdate("insert into courses values('"+course.getId(),+"','"+course.getName()+"')");
 con.close();
 

 <%@ page import="java.sql.*,java.util.*" errorPage="error.jsp"%> 
 <jsp:useBean id="course" class="com.hellking.study.hibernate.Course" scope="page">
 <jsp:setProperty name="course" property="*"/>
 </jsp:useBean>
 <jsp:useBean id="courseBusiness" class="com.hellking.study.hibernate.CourseBean" scope="page"/>
 <html><body><center>
 <% 
 try
 {
 if(course.getId().equals(null)||course.getId().equals(""));
 else courseBusiness.addCourse(course);
 
 %>
 成功添加了Course：<br>
 name：<%=course.getName()%>
 Id:<%=course.getId()%>
 <%
 }
 catch(Exception e)
 {
 } 
 %> 
 
 <hr>
 <br>::增加一個(gè)course::<br>
 <form action="course.jsp" method="get" name="add">
 id:<input type=text name="id"><br>
 name:<input type=text name="name"><br>
 <input type=submit value="submit"><br>
 </form>
 <hr>
 ::按名字模糊查找::<br>
 <form action="queryCourse.jsp" method="get" name="queryByName">
 name:<input type=text name="name"><br>
 <input type=submit value="query"><br>
 </form>
 <hr>
 ::刪除一個(gè)Course::<br>
 <form action="deleteCourse.jsp" method="get" name="queryByName">
 id:<input type=text name="id"><br>
 <input type=submit value="delete"><br>
 </form>
 <hr>
 <a href=viewAll.jsp>::查看所有Course::<a>
 </body>
 </html>
 

 <%@ page import="java.sql.*,java.util.*,com.hellking.study.hibernate.Course" errorPage="error.jsp"%> 
 <jsp:useBean id="courseBusiness" class="com.hellking.study.hibernate.CourseBean" scope="page"/>
 …
 <% try
 {
 Iterator it=courseBusiness.getSomeCourse((String)request.getParameter("name"));
 while(it.hasNext())
 {
 Course temp=(Course)it.next();
 out.println("<tr><td>"+temp.getId()+"</td>");
 out.println("<td>"+temp.getName()+"</td></tr>");
 }
 }
 catch(Exception e)
 {
 out.println(e.getMessage());
 }
 %>
 ….
 

 /**
 *按course的名字進(jìn)行模糊查找
 */
 public Iterator getSomeCourse(String name)throws HibernateException
 {
 String queryString = "select c from Course as c where c.name like :name" ;
 beginTransaction();
 Query query = session.createQuery(queryString);
 query.setString("name", "%"+name+"%");
 Iterator it= query.iterate();
 return it;
 }
 

 select c from Course as c where c.name like :name"
 

 …
 <jsp:useBean id="courseBusiness" class="com.hellking.study.hibernate.CourseBean" scope="page"/>
 …
 <% try
 {
 Iterator it=courseBusiness.getAllCourses();
 while(it.hasNext())
 {
 Course temp=(Course)it.next();
 out.println("<tr><td>"+temp.getId()+"</td>");
 out.println("<td>"+temp.getName()+"</td></tr>");
 }
 }
 catch(Exception e)
 {
 out.println(e.getMessage());
 }
 %>
 …
 

 <jsp:useBean id="courseBusiness" class="com.hellking.study.hibernate.CourseBean" scope="page"/>
 …
 刪除id為：<%=request.getParameter("id")%>的course：:::<br>
 
 <% try
 {
 courseBusiness.deleteCourse(request.getParameter("id"));
 out.println("刪除成功");
 } 
 catch(Exception e)
 {
 out.println("不存在這個(gè)記錄");
 }
 %>
 

 /**
 *刪除給定ID的course
 */
 public void deleteCourse(String id)throws HibernateException
 {
 beginTransaction(); 
 Course course=(Course)session.load(Course.class,id); 
 session.delete(course);
 endTransaction(true);
 }