菜鸟问javabean的弱智问题

Question

看下，放在SS下的shadow.java
package ss;import java.sql.*;
import java.sql.ResultSet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import ss.db.DBConnect;
public class shadow {
  
  public shadow() {
  }
 Connection con = null ;  public String ex_chinese(String str){
     if(str==null){
     str  ="" ;
     }
     else{
         try {
        str = new String(str.getBytes("iso-8859-1"),"gb2312") ;
         }
         catch (Exception ex) {
         }
     }
     return str ;
  } public String gettime() {
    String datestr =  "" ;
    try {
    java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy年MM月dd日 HH点ss分");
    java.util.Date date = new java.util.Date() ;
    datestr = df.format(new java.util.Date()) ;
    }
    catch (Exception ex) {    }    return datestr ;
  }
   public static void loginAdmin(HttpServletRequest httpservletrequest)throws Exception
    {
        boolean flag = false;
//shadow bb=new shadow();
       DBConnect dbconnect = new DBConnect();
        String s = "";
 
        if(!flag)
        {
            dbconnect.prepareStatement("SELECT * FROM db1");      
            ResultSet resultset = dbconnect.executeQuery();
            if(resultset.next())
            {
              
                
String name=resultset.getString("name");
String password=resultset.getString("password");               HttpSession session = httpservletrequest.getSession( true );                //HttpSession httpsession = httpservletrequest.getSession(true);

               session.setAttribute( "name", name );
                   session.setAttribute( "password", password );
 
                resultset.close();
                statement.close();
con.close();
            } else
            {
                s = s + "□ 您输入的用户名或密码错误！<br>□ 五秒钟后会自动返回登录页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
                flag = true;
            }
        }
        if(flag)
            throw new Exception(s);
        else
            return;
    }
}放在ss/db下的DBConnect.java// Source File Name:   DBConnect.javapackage ss.db;import java.sql.*;// Referenced classes of package org.mybo.third.po.db:
//            DBConnectionManagerpublic class DBConnect
{    private Connection con;
    private Statement statement;
    //private PreparedStatement prepstmt;
    //private DBConnectionManager dcm;  public DBConnect()throws Exception
    {
 try
         {
              Class.forName("sun.jdbc.odbc.JdbcOdbcDrive");
               con=DriverManager.getConnection("jdbc:odbc:shadow","","");
   Statement statement=con.createStatement() ;
         }
catch(ClassNotFoundException e)
        {
             strExc="数据库驱动没有找到，错误提示：<br>" +e.toString();
        }
}
}运行报错
Note: sun.tools.javac.Main has been deprecated.
E:\MyBO\server\doc\WEB-INF\classes\ss\shadow.java:7: Class ss.db.DBConnect
not found in import.
import ss.db.DBConnect;
       ^
1 error, 1 warning

Answer 1

现在的错误是
Note: sun.tools.javac.Main has been deprecated.
E:\MyBO\server\doc\WEB-INF\classes\ss\shadow.java:50: Method prepareStatement(java.lang.String)
not found in class ss.db.DBConnect.
            dbconnect.prepareStatement("SELECT * FROM db1");
                                      ^
E:\MyBO\server\doc\WEB-INF\classes\ss\shadow.java:53: Method executeQuery()
not found in class ss.db.DBConnect.
            ResultSet resultset = dbconnect.executeQuery();
                                                        ^
E:\MyBO\server\doc\WEB-INF\classes\ss\shadow.java:69: Undefined variable
or class name: statement
                statement.close();
                ^
E:\MyBO\server\doc\WEB-INF\classes\ss\shadow.java:70: Can't make a static
reference to nonstatic variable con in class ss.shadow.
con.close();
^
4 errors, 1 warning

Answer 2

dbconnect.prepareStatement   ->  dbconnect.preparedStatement