网站开发登录链接,网络科技有限公司和科技有限公司的区别,35个好的网站设计,wordpress 08影院2.0花了一个小时的时间#xff0c;搞了一下jboss4。0下mysql数据源的配置。下面是一些具体过程 1、首先安装mysql数据库并将其驱动程序考到jboss的server\default\lib下面 2、将mysql-ds.xml文件放置到server\default\deploy下面 内容如下#xff1a; datasources搞了一下jboss4。0下mysql数据源的配置。下面是一些具体过程 1、首先安装mysql数据库并将其驱动程序考到jboss的server\default\lib下面 2、将mysql-ds.xml文件放置到server\default\deploy下面 内容如下 datasources local-tx-datasource jndi-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost:3306/test/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-nameroot/user-name passwordqwe123/password !-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -- metadata type-mappingmySQL/type-mapping /metadata /local-tx-datasource /datasources 3、建立一个自己的war包 testds.war 内含有META-INF/jbosscmp-jdbc.xml, 重载默认的数据源 jbosscmp-jdbc defaults datasourcejava:/MySqlDS/datasource datasource-mappingmySql/datasource-mapping /defaults /jbosscmp-jdbc 4、建立一个servlet进行测试,放在上面的包中 package test; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql.*; import javax.naming.*; import javax.sql.*; import java.io.*; /** * author Administrator * * TODO To change the template for this generated type comment go to * Window - Preferences - Java - Code Style - Code Templates */ public class myservlet extends HttpServlet { /* (non-Javadoc) * see javax.servlet.http.HttpServlet#doGet(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse) */ protected void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { // TODO Auto-generated method stub //super.doGet(arg0, arg1); PrintWriter out res.getWriter(); Connection conn null; Statement stmt null; ResultSet rs null; try { Context initCtx new InitialContext(); DataSource ds (DataSource)initCtx.lookup(java:/MySqlDS); conn ds.getConnection(); if (conn ! null) out.println(ok); else out.println(error); } catch(Exception e) { System.out.println(Exceptione); } } } web.xml ?xml version1.0 encodingISO-8859-1? !DOCTYPE web-app PUBLIC -//Sun Microsystems, Inc.//DTD Web Application 2.3//EN http://java.sun.com/dtd/web-app_2_3.dtd web-app servlet servlet-namemy Servlet/servlet-name servlet-classtest.myservlet/servlet-class /servlet servlet-mapping servlet-namemy Servlet/servlet-name url-pattern/*/url-pattern /servlet-mapping /web-app 呵呵。启动jboss,在浏览器中键入http://localhost:8080/testds/ 显示OK,成功 转载于:https://www.cnblogs.com/tran/archive/2004/12/25/81842.html
