我的第一个hibernate程序

最新推荐文章于 2024-09-29 19:21:13 发布

lingfeng179

最新推荐文章于 2024-09-29 19:21:13 发布

阅读量449

点赞数

分类专栏： java/jsp---J2EE 文章标签： hibernate character collation string email user

本文链接：https://blog.csdn.net/lingfeng179/article/details/4404216

版权

java/jsp---J2EE 专栏收录该内容

3 篇文章 1 订阅

订阅专栏

1.先配置好hibernate 将所需的jar包导入到lib目录下面（包括数据源包）

2.写好数据库（mysql数据库）

# SQL Manager 2007 for MySQL 4.4.0.5 # --------------------------------------- # Host : localhost # Port : 3306 # Database : test /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES latin1 */; SET FOREIGN_KEY_CHECKS=0; CREATE DATABASE `test` CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci'; USE `test`; # # Structure for the `user` table : # CREATE TABLE `user` ( `id` INTEGER(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(20) COLLATE latin1_swedish_ci DEFAULT NULL, `password` VARCHAR(20) COLLATE latin1_swedish_ci DEFAULT NULL, `email` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL, `phone` INTEGER(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) )ENGINE=InnoDB AUTO_INCREMENT=2 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci' COMMENT='InnoDB free: 3072 kB'; # # Data for the `user` table (LIMIT 0,500) # INSERT INTO `user` (`id`, `name`, `password`, `email`, `phone`) VALUES (1,'lingfeng','123456','lingfeng@163.com',0); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

3。编写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>  <property name="connection.username">root</property> <property name="connection.url">jdbc:mysql://localhost:3306/test</property> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <property name="myeclipse.connection.profile">mysql</property> <property name="connection.password">root</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property>  <property name="hibernate.show_sql">true</property>  <property name="hibernate.jdbc.fetch_size">100</property> <mapping resource="User.hbm.xml"/> </session-factory> </hibernate-configuration>

4.写User.java和User.hbm.xml文件

user.java

package vo; public class User { public int id; public String name; public String password; public String email; public int phone; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public int getPhone() { return phone; } public void setPhone(int phone) { this.phone = phone; } }

User.hbm.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" > <hibernate-mapping> <class name="vo.User" table="user"> <id name="id" column="id" type="java.lang.Integer"> <generator class="identity"/> </id> <property name="name" column="name" /> <property name="password" column="password"/> <property name="phone" column="phone"/> <property name="email" column="email"/> </class> </hibernate-mapping>

5。编写测试文件test.java

package vo; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; public class Test { /** * @param args */ SessionFactory sessionFactory; public void add() { sessionFactory = new Configuration().configure().buildSessionFactory(); Session session =sessionFactory.openSession(); Transaction tx = session.beginTransaction(); User user = new User(); user.setName("lingfeng"); user.setPassword("123456"); user.setEmail("lingfeng@163.com"); session.save(user); session.flush(); tx.commit(); } public static void main(String[] args) { Test tt = new Test(); tt.add(); } }

6.运行test。java