dboperate.java

列车信息查询系统

package XunYun;
import java.sql.*;

public class DBoperate
{
	String url = "jdbc:odbc:pwd";
    Connection conn; 
    Statement cmd=null;             
    PreparedStatement ps;
    ResultSet rs = null; 
	public DBoperate()
	{
     try{
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          conn = DriverManager.getConnection(url, "", "");
        }catch(Exception ex){
           System.out.println(ex.getMessage());
        }		
	}
	
	public boolean denglu(String a,String b)
	{
	 boolean bool=false;
		
     try{
          cmd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
          
          
          rs=cmd.executeQuery("select pwd from pwd where ID='"+a+"'");
          rs.first();
          String s=rs.getString(1);
          if(s.trim().equals(b.trim()))
            bool=true;
        }catch(Exception ex){
           System.out.println(ex.getMessage());}
     return bool;		
	}

public static void main(String args[]){
//	DBoperate dbo=new DBoperate();
	//dbo.searchID("K24");
//	dbo.search("北京","上海");
	
	
}
}