运行平台是Eclipse.代码如下:package database;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class testSQL { public static void main(String[] args) throws ClassNotFoundException, InstantiationException, IllegalAccessException
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String password="123456";
try{
Connection connection=DriverManager.getConnection(url,user,password);
Statement statement=connection.createStatement();
ResultSet rs=statement.executeQuery("select * from authors");
while(rs.next())
{
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
}
catch(SQLException ex){
System.out.print(ex.getMessage());
}
}
}
运行结果是:172-32-1176 White Johnson
213-46-8915 Green Marjorie
238-95-7766 Carson Cheryl
267-41-2394 O'Leary Michael
274-80-9391 Straight Dean
341-22-1782 Smith Meander
409-56-7008 Bennet Abraham
427-17-2319 Dull Ann
472-27-2349 Gringlesby Burt
486-29-1786 Locksley Charlene
527-72-3246 Greene Morningstar
648-92-1872 Blotchet-Halls Reginald
672-71-3249 Yokomoto Akiko
712-45-1867 del Castillo Innes
722-51-5454 DeFrance Michel
724-08-9931 Stringer Dirk
724-80-9391 MacFeather Stearns
756-30-7391 Karsen Livia
807-91-6654 Panteley Sylvia
846-92-7186 Hunter Sheryl
893-72-1158 McBadden Heather
899-46-2035 Ringer Anne
998-72-3567 Ringer Albert这样的结果表明我的数据库驱动是安装正确的吗?
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class testSQL { public static void main(String[] args) throws ClassNotFoundException, InstantiationException, IllegalAccessException
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String password="123456";
try{
Connection connection=DriverManager.getConnection(url,user,password);
Statement statement=connection.createStatement();
ResultSet rs=statement.executeQuery("select * from authors");
while(rs.next())
{
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
}
catch(SQLException ex){
System.out.print(ex.getMessage());
}
}
}
运行结果是:172-32-1176 White Johnson
213-46-8915 Green Marjorie
238-95-7766 Carson Cheryl
267-41-2394 O'Leary Michael
274-80-9391 Straight Dean
341-22-1782 Smith Meander
409-56-7008 Bennet Abraham
427-17-2319 Dull Ann
472-27-2349 Gringlesby Burt
486-29-1786 Locksley Charlene
527-72-3246 Greene Morningstar
648-92-1872 Blotchet-Halls Reginald
672-71-3249 Yokomoto Akiko
712-45-1867 del Castillo Innes
722-51-5454 DeFrance Michel
724-08-9931 Stringer Dirk
724-80-9391 MacFeather Stearns
756-30-7391 Karsen Livia
807-91-6654 Panteley Sylvia
846-92-7186 Hunter Sheryl
893-72-1158 McBadden Heather
899-46-2035 Ringer Anne
998-72-3567 Ringer Albert这样的结果表明我的数据库驱动是安装正确的吗?
select * from authors,这句话的authors在哪里?