untitled1.java

北大青鸟的内部测试题（感兴趣的一定要看看哦 ）

package kaoshi.dao;
import kaoshi.bean.beantest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.PreparedStatement;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Untitled1 {
    public Untitled1() {
    }
    public boolean daotest(beantest into){
        boolean f=false;
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
            Connection conn=DriverManager.getConnection("jdbc:odbc:accp") ;
            String sql="insert into dbo.USERS (username, password)values (?,?)";
            PreparedStatement pst=conn.prepareStatement(sql) ;
            pst.setString(1,into.getUsername() ) ;
            pst.setString(2,into.getPassword() ) ;
            int a=pst.executeUpdate() ;
            if(a==1){
                f=true;
            }
            pst.close() ;
            conn.close() ;
        }catch(Exception e){
            e.printStackTrace() ;
        }

        return f;
    }
    public boolean selecttest(String name){
        boolean f=false;
        try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
           Connection conn=DriverManager.getConnection("jdbc:odbc:accp") ;
           String sql="select * from USERS where name=?";
           PreparedStatement pst=conn.prepareStatement(sql) ;
           pst.setString(1,name) ;
           //pst.setString(2,into.getPassword() ) ;
           int a=pst.executeUpdate() ;
           if(a==1){
               f=true;
           }
           pst.close() ;
           conn.close() ;
       }catch(Exception e){
           e.printStackTrace() ;
       }
        return f;
    }

}