myeclipse配置hibernate连接mysql_MyEclipse+Struts+Hibernate+Mysql开发环境配置

电玩女神 2022-10-25 00:48 200阅读 0赞

软件：

jdk-6u22-windows-x64.exe

apache-tomcat-6.0.29.exe

mysql-5.1.51-winx64.exe

myeclipse-8.6.0-win32.exe

安装：

1.安装jdk。

2.安装tomcat。

3.安装mysql。

在test数据库下创建t\_user表，三个字段，id(key，Integer)，name(Varchar)，sex(Varchar)。

CREATE TABLE \`test\`.\`t\_user\` (

\`id\` INTEGER UNSIGNED NOT NULL

AUTO\_INCREMENT,

\`name\` VARCHAR(45) NOT NULL,

\`sex\` VARCHAR(45) NOT NULL,

PRIMARY KEY (\`id\`)

)

ENGINE = InnoDB;

![403c22073c68c7040106c7d395103ac7.png][]

4.安装myeclipse。

配置myeclipse的Tomcat服务器：

window->Preferences->Myeclipse->Servers->Tomcat->Tomcat

6.x

Tomcat server : Enable

Tomcat home directory: C:\\Program

Files\\Apache Software Foundation\\Tomcat 6.0

![9270344fc4294d3e70a4a9b90925b992.png][]

测试：

在菜单图标中选择Run/Stop/Restart Myeclipse Servers中的Tomcat

6.x的Start，打开浏览器，输入http://127.0.0.1:8080进行测试。

![968a0aeb92f1ec624afb4b49be4a122a.png][]![c2a4a12733e6a89fe9f8e9f659e00681.png][]

实例：

大致步骤：

1.创建web工程；

2.建立数据库连接；

3.建立hibernate框架；

4.编写hibernate代码；

5.建立struts框架；

6.测试并发布工程。

详细步骤：

1.创建web工程

File->New->Web Project

![e2261bc130f5cf022c3c526d9c82ef2c.png][]

Peoject Name: myexample，其它值使用默认设置，点Finish。

![95b5306171cde5d301b8bfd1d5d4c270.png][]

如果操作正常，会在Package Exporler看到新建的myexample工程。

![478f477904db224f9d01420d2dcaf85a.png][]

设置工程myexample的字符集：

![38c03e92c3744548ff42ed36fc4d50b3.png][]

设置工程myexample的Filter属性：![5d04f551ad68f86e56cd08402e60055c.png][]

2.建立数据库连接

选择MyEclipse Database Explorer

![8f297b1f8607877a2c973a4804e995de.png][]![062a24141133e5ae334af03ef4e49f8a.png][]

在弹出的Database Driver窗口中填入所需信息，

![756c67000db2259bbcf8ce05549052f3.png][]点击Test Driver查看是否连接成功。

3.建立hibernate框架

鼠标右击工程myexample->Myeclipse->Add  Hibernate  Capabilities，

![aadb96805e3c6147cbfc3927a6182f22.png][]![02d7e0b268c395c6953c935482c5f6fe.png][]

![68ab1a0fa410a11ca545151c9a142f83.png][]

![a75c511876f27c719ae520da9b3546a3.png][]

![b147f829f142ab5af2a154887f24ddf7.png][]

![171cfbbe1a125b44d99031dbacfb2380.png][]

![126029ca08cccf0413c013cf2b684afd.png][]

以上建立的只是hibernate的空框架，还没有涉及到具体的表的映射，下面将完成映射。

回到Myeclipse Database Explorer视图，选择前面建立的t\_user表，鼠标右键选择Hibernate

Reverse Engineering...。

![023b40a9b7af6017ce0a3695b51c5c74.png][]![83aa443b19179814676784a74b968850.png][]

4.编写hibernate代码

回到Myeclipse Java Enterprise视图，myexample->src->com.myeclipse.hibernate，右击鼠标新建class，名TUserDAOFactory。

![f752cb81897e536d78ad79f54bc0eb98.png][]![872cb0acc93b983ba775a00499de4407.png][]

代码如下：

package com.myeclipse.hibernate;

import org.hibernate.HibernateException;

import org.hibernate.Transaction;

public class TUserDAOFactory

public void addUser(TUser

user) throws HibernateException

Transaction

tx = null;      //creat transaction

TUserDAO

dao = new TUserDAO(); //creat dao

try

= dao.getSession().beginTransaction();

dao.save(user);          //保存用户

tx.commit();             //提交

catch(HibernateException

he)

if(tx!=null)

tx.rollback();           //如果提交失败回滚

throw he;

finally

dao.getSession().close();   //关闭session

5.建立struts框架

鼠标右击工程myexample->Myeclipse->Add Struts Capabilities

![c7bc86df08f6cb4ff55360a064d4a5a6.png][]![02074049890c8f1d8545f231abe5c657.png][]

鼠标右键选择WebRoot/WEB-INF/struts-config.xml文件，New->Other...

![6e25466926b7d11cf51188a2eeb4351e.png][]

选择Struts 1.3 Form,Action & JSP

![8d4f07040bf4adea45af7d18a609270c.png][]

Next,

![fcaf209076d81aa5121107d04ba9e9d1.png][]![8f6eadc42bb2718581ff42214adbd552.png][]

选择jsp选项卡

![b14b2969ca4bdd0732395800a941d4ba.png][]

点Finish，在WebRoot/form下会生成addUser.jsp文件。

![5bb22d37f1edfea24bf534a591bd6b0d.png][]

在form下建立success.jsp页面。

鼠标右键选择addUser->Properties，

![e092ce2f88f3bf413df9cac6a59339d7.png][]

选择Forwords选项卡，点add，如下图填写，然后finish。

![7efd498bf04448f1b9041dec9842b11a.png][]

生成success.jsp文件，鼠标右键myexample->WebRoot->form，New->File。

![e6dde3affa6c8d2a410bb95a96abfcdb.png][]![7feb2331dad8083d4e5a6e1783c48cb8.png][]

success.jsp代码内容：

Insert records successfully!

![e9ef418293a11ca75777d563cd84dbbb.png][]

图中所示逻辑关系：

addUser.jsp接受用户信息提交给addUserForm，处理成功转向success.jsp。

编辑com.myeclipse.struts.action下的AddUserAction.java。

![0fa2d8e111809a378d9b7c64087d011b.png][]

代码如下：

package com.myeclipse.struts.action;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;

import org.apache.struts.action.ActionForm;

import org.apache.struts.action.ActionForward;

import org.apache.struts.action.ActionMapping;

import com.myeclipse.hibernate.TUser;

import com.myeclipse.hibernate.TUserDAOFactory;

import com.myeclipse.struts.form.AddUserForm;

public class AddUserAction extends Action

public ActionForward

execute(ActionMapping mapping, ActionForm form,

HttpServletRequest

request, HttpServletResponse response)

AddUserForm

addUserForm = (AddUserForm) form;// TODO Auto-generated method stub

//添加用户

TUser

user = new TUser();

//addAdminForm是用户窗体，下面接受用户输入的姓名和性别

user.setId(5);

user.setName(addUserForm.getName());

user.setSex(addUserForm.getSex());

//调用dao将用户存入数据库

TUserDAOFactory

userDAOFactory = new TUserDAOFactory();

userDAOFactory.addUser(user);

return mapping.findForward("success");

运行测试：

![afa0d727e0c04511ca33c1d9eb976a12.png][]![e8054e59470dfb4468f12e1be2951db6.png][]

在IE中输入：http://localhost:8080/myexample/form/addUser.jsp

![a4bea32f206a0d2dfbc232b4d3039c7f.png][]

点击Submit，

检查数据库库，检查记录是否被添加。

![a26c5eb8a90c217485374394bd18b82d.png][]

6.测试并发布工程

鼠标右击myexample，选择Myeclipse->Add and Remove Project Deployments

![e4bb6b3c65d33be233b082f0876aa7d8.png][]![1078cdcc016a52bcdb182fe81cbb654d.png][]通过Add/Remove/Redeploy/Brows进行管理。

在C:\\Program Files\\Apache Software Foundation\\Tomcat 6.0\\webapps有个myexample文件夹，说明成功发布该工程。

[403c22073c68c7040106c7d395103ac7.png]: /images/20221024/8a0906e9bc884ebba609a45065909fee.png
[9270344fc4294d3e70a4a9b90925b992.png]: /images/20221024/6f3bf82ee72a45bcb2314b913738210f.png
[968a0aeb92f1ec624afb4b49be4a122a.png]: https://img-blog.csdnimg.cn/img_convert/968a0aeb92f1ec624afb4b49be4a122a.png
[c2a4a12733e6a89fe9f8e9f659e00681.png]: /images/20221024/ecca558eb9cd462a802240f54232617c.png
[e2261bc130f5cf022c3c526d9c82ef2c.png]: /images/20221024/808ad3ef7aef4456890f03c3808d57f8.png
[95b5306171cde5d301b8bfd1d5d4c270.png]: /images/20221024/7ce8967ce7134bc8ad6b08da923ec104.png
[478f477904db224f9d01420d2dcaf85a.png]: /images/20221024/1dd73ee40a6940768bc7b743a4d51e8c.png
[38c03e92c3744548ff42ed36fc4d50b3.png]: /images/20221024/dac8cd9c96b548b1bbb657c23ae80552.png
[5d04f551ad68f86e56cd08402e60055c.png]: /images/20221024/0d7617b2a8c0477a9ca5593b2abfeb69.png
[8f297b1f8607877a2c973a4804e995de.png]: https://img-blog.csdnimg.cn/img_convert/8f297b1f8607877a2c973a4804e995de.png
[062a24141133e5ae334af03ef4e49f8a.png]: /images/20221024/2c33304ae237473bb46bd9eb27875225.png
[756c67000db2259bbcf8ce05549052f3.png]: /images/20221024/4071f51565cb46f98b0393a79316da27.png
[aadb96805e3c6147cbfc3927a6182f22.png]: https://img-blog.csdnimg.cn/img_convert/aadb96805e3c6147cbfc3927a6182f22.png
[02d7e0b268c395c6953c935482c5f6fe.png]: /images/20221024/54104168d7bb453e8635dbc6aff97452.png
[68ab1a0fa410a11ca545151c9a142f83.png]: /images/20221024/4c07511fec3a47b3a9a832460d2a9419.png
[a75c511876f27c719ae520da9b3546a3.png]: /images/20221024/2b782587558040e699fd063e7f179528.png
[b147f829f142ab5af2a154887f24ddf7.png]: /images/20221024/1a1a254a512343128a2922a3e9151f24.png
[171cfbbe1a125b44d99031dbacfb2380.png]: /images/20221024/1b5008d889c44b979d560de29e1ee52b.png
[126029ca08cccf0413c013cf2b684afd.png]: /images/20221024/7fc2b7f8502b40a3b220a08ec7e25bf7.png
[023b40a9b7af6017ce0a3695b51c5c74.png]: https://img-blog.csdnimg.cn/img_convert/023b40a9b7af6017ce0a3695b51c5c74.png
[83aa443b19179814676784a74b968850.png]: /images/20221024/644c39d53c7743c3ad05ed2355528a0c.png
[f752cb81897e536d78ad79f54bc0eb98.png]: https://img-blog.csdnimg.cn/img_convert/f752cb81897e536d78ad79f54bc0eb98.png
[872cb0acc93b983ba775a00499de4407.png]: /images/20221024/6eac5526709e4085835488c7bcc9fd31.png
[c7bc86df08f6cb4ff55360a064d4a5a6.png]: https://img-blog.csdnimg.cn/img_convert/c7bc86df08f6cb4ff55360a064d4a5a6.png
[02074049890c8f1d8545f231abe5c657.png]: /images/20221024/f159170a0ded45fe9991bf30130c3384.png
[6e25466926b7d11cf51188a2eeb4351e.png]: /images/20221024/19c8e30df7294008bf58bab187774fd4.png
[8d4f07040bf4adea45af7d18a609270c.png]: /images/20221024/1406b02381b44b0c8733440760720667.png
[fcaf209076d81aa5121107d04ba9e9d1.png]: https://img-blog.csdnimg.cn/img_convert/fcaf209076d81aa5121107d04ba9e9d1.png
[8f6eadc42bb2718581ff42214adbd552.png]: /images/20221024/7d097aa6315e41b19494b89707162eff.png
[b14b2969ca4bdd0732395800a941d4ba.png]: /images/20221024/6e19fd38dd5243c681718767ed40c91e.png
[5bb22d37f1edfea24bf534a591bd6b0d.png]: /images/20221024/60419e776b1241fe93c9ae5e1ffd41b1.png
[e092ce2f88f3bf413df9cac6a59339d7.png]: /images/20221024/b968073e39f8444bb8cccfe398736c56.png
[7efd498bf04448f1b9041dec9842b11a.png]: /images/20221024/c716174f61704250a96e45dcb92433d8.png
[e6dde3affa6c8d2a410bb95a96abfcdb.png]: https://img-blog.csdnimg.cn/img_convert/e6dde3affa6c8d2a410bb95a96abfcdb.png
[7feb2331dad8083d4e5a6e1783c48cb8.png]: /images/20221024/b61e903d81f340fb8130942df59b4bd7.png
[e9ef418293a11ca75777d563cd84dbbb.png]: /images/20221024/f9b51efc090a48abb56ceba80f25d42f.png
[0fa2d8e111809a378d9b7c64087d011b.png]: /images/20221024/4e47d44293494166bb4cc74de225dae8.png
[afa0d727e0c04511ca33c1d9eb976a12.png]: https://img-blog.csdnimg.cn/img_convert/afa0d727e0c04511ca33c1d9eb976a12.png
[e8054e59470dfb4468f12e1be2951db6.png]: /images/20221024/92e7f063140048e08db85e51995367ce.png
[a4bea32f206a0d2dfbc232b4d3039c7f.png]: /images/20221024/c58801f476e848569d56d60601a7ac9a.png
[a26c5eb8a90c217485374394bd18b82d.png]: /images/20221024/6a630d9f31e04606b72389509ae02bca.png
[e4bb6b3c65d33be233b082f0876aa7d8.png]: https://img-blog.csdnimg.cn/img_convert/e4bb6b3c65d33be233b082f0876aa7d8.png
[1078cdcc016a52bcdb182fe81cbb654d.png]: /images/20221024/d3f06548c04e4a0c9db5cf0119ad9ba8.png