JBoss4.0.5+Mysql5.0.41 JNDI

来源：互联网发布：电脑里的淘宝网交电费编辑：程序博客网时间：2024/05/21 12:45

jboss配置 mysql数据库连接池实例
1 :配置: JDK 1.5 + JBoss4.0.4 + Mysql5.0

2:建立数据库:create database test;use test;DROP TABLE IF EXISTS `test`;CREATE TABLE `test` ( `Test_id` int(11) NOT NULL auto_increment, `Test_name` varchar(45) NOT NULL default '', `Test_password` varchar(45) NOT NULL default '', PRIMARY KEY (`Test_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO `test` VALUES (1,'test','test'),(2,'test2','test');

3:Copy MySQL的JDBC驱动放到jboss-4.0.4/server/default/lib 可到MYsql网站下载www.mysql.com

4:在 jboss-4.0.4/server/default/deploy下新建文件mysql-ds.xml 可从jboss-4.0.4/docs/examples/jca copy 修改想配置多个连接池只要多加一个<local-tx-datasource /></local-tx-datasource /> 其中内容如下:

<jndi-name />test</jndi-name />

<connection-url />jdbc:mysql://127.0.0.1:3306/test</connection-url />

<driver-class />com.mysql.jdbc.Driver</driver-class />

<user-name />root</user-name />

<password />xxxxxxxx</password />

<exception-sorter-class-name/>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name />

<type-mapping />mySQL</type-mapping />

5:修改jboss-4.0.4/server/default/conf/ standardjaws.xml

<type-mapping />mySql</type-mapping />

.....</jaws />

修改jboss-4.0.4/server/default/conf/ standardjbosscmp-jdbc.xml

<jbosscmp-jdbc />

<datasource-mapping />mySql</datasource-mapping />

</defaults></jbosscmp-jdbc />

修改jboss-4.0.4/server/default/conf/ login-config.xml

<application-policy name = "mysqldbrealm" />

<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required"> <module-option name ="principal" />test</module-option />

<module-option name ="username" />root</module-option />

<module-option name ="password" />xxxxxxxx</module-option />

<module-option name ="managedconnectionfactoryname" />

jboss.jca:service=LocalTxCM,name=test </module-option />

6:Myeclispe 新建Web project 命名为:UseTest

DatabaseConn.javapackage com.db;

import java.sql.*;

import javax.naming.*;

import javax.sql.DataSource;

public class DatabaseConn {

public static synchronized Connection getConnection()

{

try {

Context envCtx = new InitialContext();

DataSource ds = (DataSource) envCtx.lookup("java:/test");

return ds.getConnection();

} catch (SQLException e) {

System.out.println("数据源配置发生错误" + e.toString());

return null;

} catch (NamingException e2) {

System.out.print("数据源配置" + e2.toString());

return null; }

}

public static void close(ResultSet rs, Statement st, Connection conn) {

try {

if (rs != null)

rs.close();

} catch (SQLException ex) { } ;

try {

if (st != null)

st.close();

} catch (SQLException ex) { } ;

try {

if (conn != null)

conn.close();

} catch (SQLException ex) { } ; }}

7:新建JSP页面:MyJsp.jsp

<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>

<%@ page import="java.sql.*"%>

<%@ page import="com.db.*"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>My JSP 'MyJsp.jsp' starting page</title>

<!--

-->

</head>

<body>

Connection conn = DatabaseConn.getConnection();

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery("select * from test");

while(rs.next())

{

out.println(rs.getInt("Test_id"));

out.println(rs.getString("Test_name"));

out.println(rs.getString("Test_password"));

}

DatabaseConn.close(rs,stmt,conn);

</body>

</html>

8 :部署Web project9:重新启动服务器

10:访问: http://127.0.0.1:8080/UseTest/MyJsp.jsp