各位请指教编译成bean有错

[little23]

package guest;
import java.sql.*;
public class guest
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:guest";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs =null;

public guest()
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("guest(): " + e.getMKessage());
}
}

public ResultSet executeQuery(String sql)
{
rs = null ;
try
{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex)
System.err.println("aq.executeQuery: "+ex.getMessage());
}
return rs;
}

public void executeUpdate(String sql)
{
stmt = null;
rs = null;
try
{
con = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
System.err.ptintln("aq.executeQuery: " + ex.getMessage());
}

public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
将以下编译有 4 个错啊！请指教！ 12行 try 错！还有说{ 有错！
public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}

[xmbareheaded]

是不是多了一个“｝”你再仔细检查一下程序看看

[xmbareheaded]

你的程序中：
public guest()
//////////这一行少了"{"
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("guest(): " + e.getMKessage());
}
}

[tom2005]

public ResultSet executeQuery(String sql)
{
rs = null ;
try
{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex)
//////////这一行也少了"{"

System.err.println("aq.executeQuery: "+ex.getMessage());
}
return rs;
}

[tom2005]

public void executeUpdate(String sql)
{
stmt = null;
rs = null;
try
{
con = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
System.err.ptintln("aq.executeQuery: " + ex.getMessage());
}

[tom2005]

上一个写错了
public void executeUpdate(String sql)
{
stmt = null;
rs = null;
try
{
con = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
这里应加“{”吧
System.err.ptintln("aq.executeQuery: " + ex.getMessage());
这里应加“}”
}

[little23]

多谢！改了几个错误
现在显示一个错误
guest.java:22:cannot resolve symbol
symbol:....
lacation:....
System.err.ptintln("aq.executeQuery: " + ex.getMessage());
^

修改后：
package guest;
import java.sql.*;
public class guest
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:guest";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs =null;

public guest()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("guest(): " + e.getMessage());
}
}


public ResultSet executeQuery(String sql)
{
rs = null ;
try
{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}

public void executeUpdate(String sql)
{
stmt = null;
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.ptintln("aq.executeQuery: " + ex.getMessage());
}
}

public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}

public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}

[tom2005]

System.err.ptintln("aq.executeQuery: " + ex.getMessage());
改为
System.err.println("aq.executeQuery: " + ex.getMessage());

[little23]

请问你改了些什么呢？

[snow_jin]

:-D litte的好学精神很让我感动，不过还是忍不住想笑一下。
ptintln--println
建议 用 Eclipse写程序,比较好找错。

[tom2005]

ptintln 中的 t 改为 r

[little23]

吾好意思啊！大侠！！！
多谢晒！！！！！
因为这是我第一次用jsp的！
做紧个网站会员登陆的后台。
如果有代码希望可以大家分享一下！

[little23]

编译出来提示
guest.java:12:','execpted
try
^
guest.java:22:'class' or 'interface'expected
public ResultSet executeQuery(String sql)
^
guest.java:79:'class' or 'interface'expected
}
^
请指教！

[little23]

现在剩下这两个错误啊！
guest.java:12:','execpted
try
^
guest.java:22:'class' or 'interface'expected
public ResultSet executeQuery(String sql)
^

[little23]

还剩下一个！
guest.java:22:'class' or 'interface'expected
public ResultSet executeQuery(String sql)

[xiaomineer]

把你改完的代码贴出来吧。

[little23]

package guest;
import java.sql.*;
public class guest
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:guest";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs =null;

public guest()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("guest(): " + e.getMKessage());
}
}
}

public ResultSet executeQuery(String sql)
{
rs = null ;
try
{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex)
{
System.err.println("aq.executeQuery: "+ex.getMessage());
}
return rs;
}

public void executeUpdate(String sql)
{
stmt = null;
rs = null;
try
{
con = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.ptintln("aq.executeQuery: " + ex.getMessage());
}
}

public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}

public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}

[little23]

括号搞好了！
剩下一个错误啦！
guest.java:22:'class' or 'interface'expected
public ResultSet executeQuery(String sql)
^
Result R有错？？

[xiaomineer]

public guest()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("guest(): " + e.getMKessage());
}
}
}这个地方的括号要去掉，加这个括号，这个类就完了，下面的方法没在类里面，他当然要提示你需要一个累了阿，你下面还有错误，你先改这个吧，然后再看报什么错。