从网上查看解决方法,基本都做了:下载驱动程序,三个包都下好了,放到lib目录下,然后环境变量里也设置了。sql sp4补丁也打了,可是还是出现下面的问题:
数据库连接已开启
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.zjou.sql.tsgsg.main(tsgsg.java:17)
程序如下:
package com.zjou.sql;import java.sql.*;
import java.util.*;
public class tsgsg {
public static void main(String[] args){
List book_informations=new ArrayList();
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("数据库连接已开启");
String url="jdbc:microsoft:sqlserver//DREAMSKY:1433;DatabaseName=tsglxt";
String user="sa";
String password="1";
Connection conn=DriverManager.getConnection(url,user,password);
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("SELECT * FROM book_information");
while(rs.next())
{
Book_information book_information=new Book_information();
book_information.setBook_ID(rs.getString(1));
book_information.setBook_name(rs.getString(2));
book_information.setBook_author(rs.getString(3));
book_information.setBook_publish(rs.getString(4));
book_information.setReader_ID(rs.getString(5));
book_information.setBook_topic(rs.getString(6));
book_informations.add(book_information);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Iterator it=book_informations.iterator();
while(it.hasNext())
{ Book_information book=(Book_information)it.next();
System.out.println(book.getBook_ID());
System.out.println(book.getBook_name());
}
}}
数据库连接已开启
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.zjou.sql.tsgsg.main(tsgsg.java:17)
程序如下:
package com.zjou.sql;import java.sql.*;
import java.util.*;
public class tsgsg {
public static void main(String[] args){
List book_informations=new ArrayList();
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("数据库连接已开启");
String url="jdbc:microsoft:sqlserver//DREAMSKY:1433;DatabaseName=tsglxt";
String user="sa";
String password="1";
Connection conn=DriverManager.getConnection(url,user,password);
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("SELECT * FROM book_information");
while(rs.next())
{
Book_information book_information=new Book_information();
book_information.setBook_ID(rs.getString(1));
book_information.setBook_name(rs.getString(2));
book_information.setBook_author(rs.getString(3));
book_information.setBook_publish(rs.getString(4));
book_information.setReader_ID(rs.getString(5));
book_information.setBook_topic(rs.getString(6));
book_informations.add(book_information);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Iterator it=book_informations.iterator();
while(it.hasNext())
{ Book_information book=(Book_information)it.next();
System.out.println(book.getBook_ID());
System.out.println(book.getBook_name());
}
}}
中的
DREAMSKY是什么?
到下边去看一下吧!
http://hi.baidu.com/ljx0305/blog/item/d39c5b8d34af1e13b21bba1d.html
不过建议你写Exception不要只写一个,这样不好找错。
改为
com.microsoft.sqlserver.jdbc.SQLServerDriver
试下!
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.zjou.sql.tsgsg.main(tsgsg.java:17)
error while performing database login with the Myeclipse derby driver
java.net.connectException :连接到端口1527上的服务器localhost时出错,消息为connection refused:connect.