Hibernate连数据库

1.建数据库，建表（一定要设主码）

create database Hibernate
create table Students(
sno char(10) primary key,
sna char(10),
)

　　

2.打开Myeclipse，建web项目，一定要选java EE6.0

3.先将jar包拷到lib下：

4.用DB Browser连数据库：右击-New，弹出如下对话框：

这样选择：注意Driver JARs添加刚刚拷的jar包

然后点Test Driver出现如下图表示成功连到数据库

然后Next，选第三个Display the selected schemas，然后ADD

然后选择刚建的数据库Hibernate：

然后Finish。

5.右击项目名Hibernate-Myeclipse-Add Hibernate Capabilities，按如图这样选择，然后下一步

下一步，DB Driver选择Hibernate

下一步，建包，完成

这样就添加了HibernateSessionFactory.java和hibernate.cfg.xml

6.回到DB Browser，右击Hibernate-Open connection，打开链接。然后找到自己的表Students

右击表名Students-Hibernate Reverse Engineering，在Java src folder中选Hibernate

下一步

下一步

完成，这是在项目中又添加了Students.java和Students.hbm.xml

7.编代码实现简单的插入

建StudentAdd.html:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form id="form1" action="servlet/StudentAdd" method="post">
学号<input type="text" id="id" name="id">
姓名<input type="text" id="name" name="name">
<input type="submit" value="提交">




</form>



</body>
</html>

建servelet：StudentAdd.java:

package com.aa.orm;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.hibernate.Session;

public class StudentAdd extends HttpServlet {

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		String strid="";
		String strname="";
		
		strid=request.getParameter("id");
		strname=request.getParameter("name");
		
		
		Session ss = HibernateSessionFactory.getSession();
		ss.beginTransaction();
		
		Students s = new Students();
		s.setSno(strid);
     	s.setSna(strname);
     	
     	ss.save(s);
     	System.out.println(strid);
     	ss.getTransaction().commit();
		ss.close();
		
		response.sendRedirect("../index.jsp");
	}

}

结果：

表示插入成功。

 

posted @ 2016-04-18 15:34  非非是  阅读(261)  评论(0)    收藏  举报