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">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="show_sql">true</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="myeclipse.connection.profile">
yohn/MySQL5.0
</property>
<property name="connection.url">
jdbc:mysql://localhost:3306/test
</property>
<property name="connection.username">root</property>
<property name="connection.password">admin</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<mapping class="com/yohn/hibernate/Students.java" />
</session-factory>
</hibernate-configuration>
pojo类
package com.yohn.hibernate;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import org.hibernate.annotations.AccessType;
@Entity
@Table(name="students")
public class StudentsAnnont implements java.io.Serializable
{
// Fields
@Id
@AccessType(value = "property")//注意这里
@Column(name = "s_id")//实际做的时候没有这一行,用了其他技巧自动转换名字为group_id
@GeneratedValue(strategy=GenerationType.AUTO)
private Integer SId;
@AccessType(value = "property")
@Column(name="s_name")
private String SName;
// Constructors
/** default constructor */
public StudentsAnnont()
{
}
/** full constructor */
public StudentsAnnont(String SName)
{
this.SName = SName;
}
// Property accessors
public Integer getSId()
{
return this.SId;
}
public void setSId(Integer SId)
{
this.SId = SId;
}
public String getSName()
{
return this.SName;
}
public void setSName(String SName)
{
this.SName = SName;
}
}
Test.类
import org.hibernate.Session;
import org.hibernate.cfg.AnnotationConfiguration;
public class Test2
{
public static void main(String[] args)
{
Session session = new AnnotationConfiguration().configure(
"/hibernate.cfg.xml").buildSessionFactory().openSession();
StudentsAnnont stu = new StudentsAnnont();
stu.setSName("**'");
session.beginTransaction();
session.save(stu);
List<StudentsAnnont> lst = (List<StudentsAnnont>) session.createCriteria(StudentsAnnont.class).list();
System.out.println(lst.size());
for (StudentsAnnont s : lst)
{
System.out.println(s.getSName());
}
session.beginTransaction().commit();
}
}
create table if not exists students;
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(1, 'aaa');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(2, 'bbb');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(3, 'ccc');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(7, 'fff');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(8, 'ee');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(9, '愉快的');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(10, '/*/*');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(11, '78*');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(12, '[][[]');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(13, '[][[]');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(14, '[][[]');
INSERT INTO students
(`s_id`, `s_name`)
VALUES
(15, '**\'');