缺少方法主体，或声明对象 找不到符号

Question

package ebBeans;
import java.io.PrintStream;
import java.sql.*;
public class bka
{
String sDBDriver;
String sConnStr;
Connection conn;
ResultSet rs;
public bka();
{
sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
sConnStr="jdbc:odbc:test";
conn=null;
rs=null;
try{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println("bka():"+classnotfoundexception.getMessage());
}
}
public ResultSet executeQuery(String s)
{
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr,"admin","admin");
Statement statement=conn.creatStatement();
rs=statement.executeQuery(s);
}
catch(SQLException SQLexception)
{
System.err.println("aq.executeQuery:"+SQLexception.getMessage());
}
return rs;
}
}

Answer 1

public bka();   这个最后的分号哪来的？

Answer 2

package ebBeans;
import java.io.PrintStream;
import java.sql.*;
public class bka
{
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:test";
Connection conn=null;
ResultSet rs=null;public bka(){
} public ResultSet executeQuery(String s)
{
rs=null;
try{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println("bka():"+classnotfoundexception.getMessage());
}
try
{
conn=DriverManager.getConnection(sConnStr,"admin","admin");
Statement statement=conn.createStatement();
rs=statement.executeQuery(s);
}
catch(SQLException SQLexception)
{
System.err.println("aq.executeQuery:"+SQLexception.getMessage());
}
return rs;
}
}
这样改后可以编译成功，
你的conn.creatStatement();这个语句有问题注意看看怎么错了

Answer 3

package ebBeans;
import java.io.PrintStream;
import java.sql.*;
public class bka
{
String sDBDriver;
String sConnStr;
Connection conn;
ResultSet rs;
public bka()
{
sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
sConnStr="jdbc:odbc:test";
conn=null;
rs=null;
try{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println("bka():"+classnotfoundexception.getMessage());
}
}
public ResultSet executeQuery(String s)
{
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr,"admin","admin");
Statement statement=conn.createStatement();
rs=statement.executeQuery(s);
}
catch(SQLException SQLexception)
{
System.err.println("aq.executeQuery:"+SQLexception.getMessage());
}
return rs;
}
}
这样也可以编译成功  那个“public bka();  ”分号去掉
conn.creatStatement();改成 conn.createStatement();