1、安装Microsoft Sqlserver Driver for JDBC,可从微软网站上下载。
2、设置classpath,下面是我自己的,仅供参考。
classpath:
D:\program files\Microsoft SQL Server\jdbc\lib\msbase.jar;D:\program files\Micro
soft SQL Server\jdbc\lib\mssqlserver.jar;D:\program files\Microsoft SQL Server\j
dbc\lib\msutil.jar;D:\Project\java
3、用下面的代码测试,我的代码使用JDBC而不是JDBC-ODBC bridge.
import java.sql.*;
public class T {
public static void main(String[] args) throws Exception {
String sql = "select * from tb";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://home:3017","steven","steven");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
Student s = new Student();
s.name = rs.getString(1);
s.id = rs.getInt(2);
System.out.println(s);
}
rs.close();
stmt.close();
}
}
class Student {
String name;
int id;
public String toString() {
return "Student--> name:[" + name + "], id:[" + id + "]";
}
}
4、祝你愉快。
2、设置classpath,下面是我自己的,仅供参考。
classpath:
D:\program files\Microsoft SQL Server\jdbc\lib\msbase.jar;D:\program files\Micro
soft SQL Server\jdbc\lib\mssqlserver.jar;D:\program files\Microsoft SQL Server\j
dbc\lib\msutil.jar;D:\Project\java
3、用下面的代码测试,我的代码使用JDBC而不是JDBC-ODBC bridge.
import java.sql.*;
public class T {
public static void main(String[] args) throws Exception {
String sql = "select * from tb";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://home:3017","steven","steven");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
Student s = new Student();
s.name = rs.getString(1);
s.id = rs.getInt(2);
System.out.println(s);
}
rs.close();
stmt.close();
}
}
class Student {
String name;
int id;
public String toString() {
return "Student--> name:[" + name + "], id:[" + id + "]";
}
}
4、祝你愉快。
连接源码FAQ里有
mabase.jar、msutil.jar、mssqlserver.jar拷贝到
tomcat\server\lib
tomcat\lib
<title>New Page 1</title>
</head>
<body>
<%@ page language="java" import="java.sql.*" contentType="text/html;charSet=gb2312"%>
<%String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String password="";
String sqlstr="select * from jobs";
Connection conn=null;
Statement lstmt=null;
ResultSet rs=null;
Class.forName(driver).newInstance();
try{
conn=DriverManager.getConnection(url,user,password);
}
catch(Exception e){
out.println(e.toString());
}
try{
lstmt=conn.createStatement();
rs=lstmt.executeQuery(sqlstr);
}
catch(Exception e){
out.println(e.toString());
}
while (rs.next()){
out.println("<tr><td>"+rs.getString("job_desc")+"</tr></td>");
}
rs.close();
lstmt.close();
conn.close();
%>
%>
</body>
</html>
首先你要下载jdbc驱动,(mssqlserver.jar msutil.jar msbase.jar)
把三个jar文件放到lib文件夹下就可以了!
先建立odbc
String MM_sa_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
String MM_sa_USERNAME = "sa";
String MM_sa_PASSWORD = "sa";
String MM_sa_STRING = "jdbc:odbc:test";
Driver DriverRecordset1 = (Driver)Class.forName(MM_sa_DRIVER).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection(MM_sa_STRING,MM_sa_USERNAME,MM_sa_PASSWORD);
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM dbo.tb_test");
ResultSet Recordset1 = StatementRecordset1.executeQuery();
高手帮忙,关于tomcat+ms sql的,另开贴给分。http://expert.csdn.net/Expert/topic/1526/1526349.xml?temp=.9729578
liuflei3139(驿动的心) 非常用心地回答
Hackevin(小土)
hitywt(@_@) 非常用心地回答
hitywt(@_@)
cdk(快乐的程序员) 感谢你提供的小技巧
wilsonGao(笑傲江湖) 感谢你的参与 没有想到这么多热心的朋友,分不多,以后有机会补!