源代码如下: import java.sql.*; public class Test {
public Test() {
} public static void main(String args[]) {
try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String password = " ";
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
String sql = "select * from dbo.authors";
ResultSet rs = stmt.executeQuery(sql); while (rs.next()) {
System.out.println("TestName:" + rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
} catch (Exception ex) {
ex.printStackTrace();
System.out.println("-------");
System.err.println(ex.getMessage());
}
}
}
SQL Server2000安装完成,并且启动。三个连接包也已经导入。异常如下:
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at onLine.struts.Test.main(Test.java:14) 请达人赐教到底是哪里出了问题,谢谢了
public Test() {
} public static void main(String args[]) {
try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String password = " ";
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
String sql = "select * from dbo.authors";
ResultSet rs = stmt.executeQuery(sql); while (rs.next()) {
System.out.println("TestName:" + rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
} catch (Exception ex) {
ex.printStackTrace();
System.out.println("-------");
System.err.println(ex.getMessage());
}
}
}
SQL Server2000安装完成,并且启动。三个连接包也已经导入。异常如下:
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at onLine.struts.Test.main(Test.java:14) 请达人赐教到底是哪里出了问题,谢谢了
解决方案 »
- axis 1.3 获取请求和返回报文时出现编码问题
- 在html中使用struts2标签
- spring jboss 使用定时发送邮件
- tomacat问题急??????
- 我想问一下 JAVA 是如何读取一个XML文件的 有知道的可以告诉我一下读取的方法
- struts中.do问题 请大家多多指教
- 各位前辈,小弟ejb书籍(中文版),有的给俺发过来吧,谢谢啊([email protected])
- HttpClient 中ssl访问的问题2
- 取Weblogic连接池问题
- 在JAVA中,怎么将一个记录集合转换成XML?
- 请问下:如何调试Struts啊?我的环境是Myeclipse+tomcat
- 期待来鸟给予帮助,求助!
测试通过,代码没问题结果如下
TestName:White
TestName:Green
TestName:Carson
TestName:O'Leary
TestName:Straight
TestName:Smith
TestName:Bennet
TestName:Dull
TestName:Gringlesby
TestName:Locksley
TestName:Greene
TestName:Blotchet-Halls
TestName:Yokomoto
TestName:del Castillo
TestName:DeFrance
TestName:Stringer
TestName:MacFeather
TestName:Karsen
TestName:Panteley
TestName:Hunter
TestName:McBadden
TestName:Ringer
TestName:Ringer
代码如下:<%@ page import="java.sql.*"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //这两个中的间距不能为空,很重要哦?
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url, user, password); String sql = "select * from dbo.authors";
PreparedStatement pds=con.prepareStatement(sql);ResultSet rs = stmt.executeQuery(); while (rs.next()) {
string str1=rs.getString("au_id");
string str2=rs.getString("au_lname");
out.println(str1+" "+str2+"<br />");
}
catch (Exception ex) {
ex.printStackTrace();
System.out.println("-------");
System.err.println(ex.getMessage());
}
%>试试看吧...
<%@ page import="java.sql.*"%>
<html>
<body bgcolor="#ffffff">
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=pubs";
String name="sa";
String password="";
Connection con=DriverManager.getConnection(url,name,password); Statement stm=con.createStatement();
String str="select * from authors";
ResultSet rs=stm.executeQuery(str);
while(rs.next()){
String str1=rs.getString("au_id");
String str2=rs.getString("au_lname");
out.println(str1+" "+str2+"<br />");
}
%>
</body>
</html>刚才马上去做了下,这个是正确的代码;供你参考下;