日期:2014-05-17  浏览次数:20733 次

用的 是hibernate框架现在出了点问题
代码先行
功能:加入一个sno=1 cno=1的数据到sc表中

package stu.course.com;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

/**
 *
 * @author Administrator
 */
@WebServlet(name = "XuankeServer", urlPatterns = {"/XuankeServer"})
public class XuankeServer extends HttpServlet {


    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletExceptionIOException {
        Configuration cfg = new Configuration().configure();
        SessionFactory sf = cfg.buildSessionFactory();
        Session session = sf.openSession();
        Transaction ts = session.beginTransaction();
        
        SC sc=new SC();
        sc.setSno(1);
        sc.setCno(1);
        session.save(sc);
        ts.commit();
        session.close();
        
    }
}

配置文件
1.hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="connection.url">jdbc:mysql://localhost/ssc</property>
    <property name="connection.username">root</property>