在JBOSS 4.0中配置MsSqlServer 数据源

数据记录：

1bitanbbbbbbbbbbb0x00000000000000CA
2helenhhhhhhhhhhh0x00000000000000CB
3susanssssssssss0x00000000000000CC
4kathykkkkkkkkkk0x00000000000000CD

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