if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CUSTOMERS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CUSTOMERS]
GO
CREATE TABLE [dbo].[CUSTOMERS] (
[ID] [bigint] NOT NULL ,
[NAME] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EMAIL] [varchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[PASSWORD] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[PHONE] [int] NULL ,
[ADDRESS] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
hibernate.dialect=net.sf.hibernate.dialect.SQLServerDialect
hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver
hibernate.connection.url=jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Hibernate
hibernate.connection.username=sa
hibernate.connection.password=bb
hibernate.show_sql=true
<?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.bean.Customer" table="CUSTOMERS">
<id name="id" column="ID" type="long">
<generator class="increment"/>
</id>
<property name="name" column="NAME" type="string" not-null="true" />
<property name="email" column="EMAIL" type="string" not-null="true" />
<property name="password" column="PASSWORD" type="string" not-null="true"/>
<property name="phone" column="PHONE" type="int" />
<property name="address" column="ADDRESS" type="string" />
</class>
</hibernate-mapping>
/*
* 创建日期 2005-6-28
*
* 更改所生成文件模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
package com.bean;
/**
* @author Administrator
*
* 更改所生成类型注释的模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
import java.io.Serializable;
public class Customer implements Serializable {
private Long id;
private String name;
private String email;
private String password;
private int phone;
private String address;
public Customer(){}
public Long getId(){
return id;
}
public void setId(Long id){
this.id = id;
}
public String getName(){
return name;
}
public void setName(String name){
this.name=name;
}
public String getEmail(){
return email;
}
public void setEmail(String email){
this.email =email ;
}
public String getPassword(){
return password;
}
public void setPassword(String password){
this.password =password ;
}
public int getPhone(){
return phone;
}
public void setPhone(int phone){
this.phone =phone ;
}
public String getAddress(){
return address;
}
public void setAddress(String address){
this.address =address ;
}
}
package com.service;
import net.sf.hibernate.*;
import net.sf.hibernate.cfg.Configuration;
import java.util.*;
import com.util.FactorySession;
import javax.servlet.*;
import javax.servlet.http.*;
import com.bean.*;
import java.io.*;
public class CustomerService extends HttpServlet{
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
{
Session session=null;
Transaction tx=null;
try {
session=FactorySession.getSession();
tx=session.beginTransaction();
Customer c=new Customer();
c.setName("zmbb");
c.setEmail("zhengmenbb@163.com");
c.setPassword("81101123");
c.setPhone(13808);
c.setAddress("13808749810");
session.save(c);
tx.commit();
}catch (Exception e) {
try{
tx.rollback();
}catch (Exception ex) {System.out.println("test");}
}finally {
try{
session.close();
}catch (Exception ex) {System.out.println("test");}
}
}
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
{
doGet(request,response);
}
}
package com.util;
import net.sf.hibernate.*;
import net.sf.hibernate.cfg.Configuration;
import com.bean.Customer;
public class FactorySession
{
public static SessionFactory sessionFactory;
static
{
try
{
Configuration config = new Configuration();
config.addClass(Customer.class);
sessionFactory = config.buildSessionFactory();
}
catch(Exception e){e.printStackTrace();}
}
public static Session getSession() throws Exception
{
Session session = sessionFactory.openSession();
return session;
}
public static void closeSession(Session session) throws Exception
{
if(session!=null)
session.close();
}
}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN"
"http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
<web-app>
<display-name>HelloApp Struts Application</display-name>
<!-- The Usual Welcome File List -->
<servlet>
<servlet-name>
test
</servlet-name>
<servlet-class>
com.service.CustomerService
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>
test
</servlet-name>
<url-pattern>/hello</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
