Apusic1.2+SQL Server2000的配置

时间：2014-05-04 10:34:30 来源：JSP天空网作者：未知

1)下载安装APUSIC1.2
2)下载安装SQLSERVER2000JDBC DRIVER(http://www.microsoft.com/sql/downloads/2000/jdbc.asp)
3)修改APUSIC的DATASOURCES.XML(以下是我自己的配置)
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE datasources
PUBLIC ´-//Apusic//DTD Apusic Data Source Configuration 1.0//EN´
´;http://www.apusic.com/dtds/datasources_1_0.dtd´;>

<datasources>
<datasource name="SampleDB"
jndi-name="jdbc/sample"
driver-class="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:apusic"
>
<property name="user" value="scott"/>
<property name="password" value="tiger"/>
</datasource>

<datasource name="Sample"
jndi-name="jdbc/mysample"
driver-class="com.microsoft.jdbc.sqlserver.SQLServerDriver"
driver-classpath="D:apusic-1.2b2libmssqlserver.jar;D:apusic-1.2b2libmsbase.jar;D:apusic-1.2b2libmsutil.jar"
url="jdbc:microsoft:sqlserver://localhost:1169;DatabaseName=pubs"
>
<property name="user" value="sa"/>
<property name="password" value=""/>
</datasource>
</datasources>
注意:
a)driver-classpath是APUSIC1.2特性,你无须在系统的classpath中指定JDBC DRIVER,APUSIC会在这里找.
b)1169是SQLSERVER2000缺省的端口.

4)测试页面CONNTEST.JSP:
<%-- ***************** ConnTest.jsp ************** --%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>

<%
InitialContext ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("jdbc/mysample");
Connection con = ds.getConnection("sa","");

String selectStatement = "select fname" + " from employee where job_id = ? " ;
PreparedStatement prepStmt = con.prepareStatement(selectStatement);

prepStmt.setInt(1, 13);

ResultSet rs = prepStmt.executeQuery();

if (rs.next()) {
out.println(rs.getString(1));
}
else {
out.println("No rows found.");
}

prepStmt.close();
con.close();
%>
把此页面放在APUSICHOMEapplicationsdefaultpublic_html目录下.

5)启动APUSIC,在浏览器中输入http://localhost:6888/conntest.jsp
浏览器出现Paolo 表示正确.

备:此JDBC DRIVER 用在SQL SERVER7上有问题.　

来顶一下

返回首页

推荐资讯

滨海近地生产厂房1500	科比专为大场面而生
“最美清洁工”原是《	尹馨大胆亮相《男人装

相关文章

无相关信息

栏目更新

栏目热门