数据记录:
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