在JBOSS 4.0中配置MsSqlServer 数据源

数据记录：

1 bitan bbbbbbbbbbb 0x00000000000000CA
2 helen hhhhhhhhhhh 0x00000000000000CB
3 susan ssssssssss 0x00000000000000CC
4 kathy kkkkkkkkkk 0x00000000000000CD

 

K:/jboss/server/default/deploy/mssql-ds.xml:

 

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
    <local-tx-datasource>
        <jndi-name>MsSqlServer</jndi-name>
        <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydata</connection-url>
        <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
        <user-name>sa</user-name>
        <password></password>
    </local-tx-datasource>
</datasources>

 

将sqlserver for JDBC的三个驱动包拷到

K:/jboss/server/default/lib

 

K:/jboss/server/default/deploy/test1.war/t1.jsp

<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*"%>
<%
    try {
        javax.naming.InitialContext ic = new javax.naming.InitialContext();
        javax.sql.DataSource ds = (javax.sql.DataSource) ic.lookup("java:/MsSqlServer");
        Connection conn = ds.getConnection();
        Statement stmt = conn.createStatement();
        for (ResultSet rs = stmt.executeQuery("SELECT * FROM users"); rs.next();) {
            int id = rs.getInt(1);
            String name = rs.getString(2);
            String password = rs.getString(3);
            String time = rs.getString(4);
            out.println("id=" + id + " name=" + name + " password=" + password + " time=" + time + "<br>");  
        }
    } catch (java.sql.SQLException se) {
    } catch (javax.naming.NamingException ne) {
    }
%>

 

结果：

 

http://localhost:4000/test1/t1.jsp

 

id=1 name=bitan password=bbbbbbbbbbb time=00000000000000CA
id=2 name=helen password=hhhhhhhhhhh time=00000000000000CB
id=3 name=susan password=ssssssssss time=00000000000000CC
id=4 name=kathy password=kkkkkkkkkk time=00000000000000CD