import java.io.*;
import java.sql.*;
public class Test2
{ public static void main(String[] args)
{
String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
String dbURL="jdbc:odbc:master";
String userName="sa";
String userPwd="";
Connection dbConn;
try{
Class.forName(driverName);
dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
Statement stmt=dbConn.createStatement();
System.out.println("Connection Successful!");
ResultSet rs=stmt.executeQuery("SELECT * FROM student");
}
catch(Exception e)
{
e.printStackTrace();
}
while(rs.next())
{
System.out.println(rs.getObject(1)+"->"+rs.getObject(2));
}
}
}
这个程序能连上数据源master,这没问题,但是编译时却提示找不到符号rs,不知道为什么,请高手指点,在此先谢了!!!
import java.sql.*;
public class Test2
{ public static void main(String[] args)
{
String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
String dbURL="jdbc:odbc:master";
String userName="sa";
String userPwd="";
Connection dbConn;
try{
Class.forName(driverName);
dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
Statement stmt=dbConn.createStatement();
System.out.println("Connection Successful!");
ResultSet rs=stmt.executeQuery("SELECT * FROM student");
}
catch(Exception e)
{
e.printStackTrace();
}
while(rs.next())
{
System.out.println(rs.getObject(1)+"->"+rs.getObject(2));
}
}
}
这个程序能连上数据源master,这没问题,但是编译时却提示找不到符号rs,不知道为什么,请高手指点,在此先谢了!!!
import java.io.*;
import java.sql.*;
public class Test2
{ public static void main(String[] args)
{
String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
String dbURL="jdbc:odbc:master";
String userName="sa";
String userPwd="";
Connection dbConn;
ResultSet rs;
try{
Class.forName(driverName);
dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
Statement stmt=dbConn.createStatement();
System.out.println("Connection Successful!");
rs=stmt.executeQuery("SELECT * FROM student");
}
catch(Exception e)
{
e.printStackTrace();
}
while(rs.next())
{
System.out.println(rs.getObject(1)+"-> "+rs.getObject(2));
}
}
}
rs作用域范围限制了。在try{}代码块上面定义ResultSet rs = null;
在try{}代码块内rs = stmt.executeQuery("SELECT * FROM student");
这样都没有问题了。