TA的每日心情 | 开心 2021-3-12 23:18 |
---|
签到天数: 2 天 [LV.1]初来乍到
|
到微软的网站下载jdbc for sqlserver的驱动程序,共3个文件:
msbase.jar;
mssqlserver.jar;
msutil.jar
将这三个文件放入Tomcat 5commonlib目录下或
你的应用程序的WEB-INFlib下,用下面的jsp代码测试:
<%@ page contentType="text/HTML; charset=GB2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
String url =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testjdbc";
String user = "sa";
String password = "";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=
DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from myBook");
stmt = conn.createStatement();
while(rs.next()){
out.print(rs.getString(1)+"<br>");
out.print(rs.getString(2)+"<br>");
}
}catch(Exception e){
e.printStackTrace();
out.println(e);
}
%>
以上在Tomcat 5下通过测试。
源码下载:http://file.javaxxz.com/2014/10/11/005945296.zip |
|