package Lesson3;
import java.sql.*;class Test
{
Connection con;
Statement sta;
ResultSet rs; String driver;
String url;
String user;
String pwd;
public Test()
{
driver = "sun.JDBC.odbc.JDBCOdbcDriver";
url = "JDBC:odbc:store_manager";
user = "share";
pwd = "share";
init();
}
public void init()
{
try
{
Class.forName(driver);
System.out.println("driver is ok");
con = DriverManager.getConnection
(url,user,pwd);
System.out.println("conection is ok");
sta = con.createStatement();
rs = sta.executeQuery("select * from room");
while(rs.next())
System.out.println
(rs.getInt("roomNum"));
}
catch(Exception e)
{
e.printStackTrace();
}
}
}public class DBTest
{
public static void main(String[] args)
{
new Test();
}
}
import java.sql.*;class Test
{
Connection con;
Statement sta;
ResultSet rs; String driver;
String url;
String user;
String pwd;
public Test()
{
driver = "sun.JDBC.odbc.JDBCOdbcDriver";
url = "JDBC:odbc:store_manager";
user = "share";
pwd = "share";
init();
}
public void init()
{
try
{
Class.forName(driver);
System.out.println("driver is ok");
con = DriverManager.getConnection
(url,user,pwd);
System.out.println("conection is ok");
sta = con.createStatement();
rs = sta.executeQuery("select * from room");
while(rs.next())
System.out.println
(rs.getInt("roomNum"));
}
catch(Exception e)
{
e.printStackTrace();
}
}
}public class DBTest
{
public static void main(String[] args)
{
new Test();
}
}
Statement sta;
ResultSet rs;
这三个变量没有被初始化,可以改成:
Connection con=null;
Statement sta=null;
ResultSet rs=null;
Connection con; Statement sta; ResultSet rs; String driver; String url; String user; String pwd; public Test() {
driver = "sun.JDBC.odbc.JDBCOdbcDriver";
url = "JDBC:odbc:store_manager";
user = "share";
pwd = "share";
init();
} public void init() {
try {
Class.forName(driver);
System.out.println("driver is ok");
con = DriverManager.getConnection(url, user, pwd);
System.out.println("conection is ok");
sta = con.createStatement();
rs = sta.executeQuery("select * from room");
while (rs.next()) {
System.out.println(rs.getInt("roomNum"));
} } catch (Exception e) {
e.printStackTrace();
}
}
}class DBTest {
public static void main(String[] args) {
new Test();
}
}
然后编译不过。
然后我把你的格式调了一下,仅仅是格式。然后就好了。
是不是很奇怪。