//define the data source for chiver // String sourceURL="jdbc:odbc:test";
//create connection through the DriverManager // Connection databaseConnection=DriverManager.getConnection(sourceURL); Connection databaseConnection=DriverManager.getConnection(sourceURL,prop);
Statement statement=databaseConnection.createStatement(); ResultSet authorNames=statement.executeQuery( "SELECT au_lname,au_fname FROM pubs.dbo.authors ORDER BY au_lname DESC,au_fname DESC");
ResultSetMetaData metaData=authorNames.getMetaData(); int columns=metaData.getColumnCount(); System.out.println("columns="+columns);
int row=0; while (authorNames.next()) { System.out.print("\nRow"+(++row)+":");
for (int i=1;i<=columns;i++) if (metaData.getColumnType(i)==Types.VARCHAR) //if it is char System.out.print(" "+authorNames.getString(i)); } } catch (ClassNotFoundException cnfe) { System.err.println(cnfe); }
import java.util.Properties;public class MakingAsStatement
{
public static void main(String [] args)
{
//load driver class
// String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
// String sourceURL="jdbc:odbc:test";
String sourceURL="jdbc:microsoft:sqlserver://hostname:1433"; try
{
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName (driverName);
Properties prop=new Properties();
prop.setProperty("user","sa") ;
prop.setProperty("password","pwd");
//define the data source for chiver
// String sourceURL="jdbc:odbc:test";
//create connection through the DriverManager
// Connection databaseConnection=DriverManager.getConnection(sourceURL);
Connection databaseConnection=DriverManager.getConnection(sourceURL,prop);
Statement statement=databaseConnection.createStatement();
ResultSet authorNames=statement.executeQuery(
"SELECT au_lname,au_fname FROM pubs.dbo.authors ORDER BY au_lname DESC,au_fname DESC");
ResultSetMetaData metaData=authorNames.getMetaData();
int columns=metaData.getColumnCount();
System.out.println("columns="+columns);
int row=0;
while (authorNames.next())
{
System.out.print("\nRow"+(++row)+":");
for (int i=1;i<=columns;i++)
if (metaData.getColumnType(i)==Types.VARCHAR) //if it is char
System.out.print(" "+authorNames.getString(i));
}
}
catch (ClassNotFoundException cnfe)
{
System.err.println(cnfe);
}
catch (SQLException sqle)
{
System.err.println(sqle);
}
}
}
!还有一个很菜的问题,您运行以上代码的时候,是new 一个class呢,还是别的application什么的?我都是用class的,这个东西缠了我2个星期了,真的很晕。
可以,不用设置classpath!
可能的情况是你在程序中将类名写错啦