dboperate.java

列车信息查询系统

package XunYun;
import java.sql.*;

public class DBoperate
{
	String url = "jdbc:odbc:train";
    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 void addStu(String a,String c,String d,String e,String f)
	{
		
		String sql="INSERT INTO USERS VALUES('"+a+"','"+c+"','"+d+"','"+e+"','"+f+"')";
		
     try{
          cmd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
          
          
          cmd.executeUpdate(sql);
          
        }catch(Exception ex){
           System.out.println(ex.getMessage());}
	}
	public void addPWD(String a,String b,String c,String d)
	{
		 String sql="INSERT INTO PWD VALUES('"+a+"','"+b+"','"+c+"','"+d+"','用户')";
		
     try{
          cmd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
          
          
          cmd.executeUpdate(sql);
          
        }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 String[] search(String a,String b)
	{
	   String[] s=new String[8];
	        try{
          cmd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
          
          
          rs=cmd.executeQuery("select * from TRAIN where ROUT like '%"+a+"%"+b+"%'");
          
        while(rs.next()){
          s[0]=rs.getString(1);
          s[1]=rs.getString(2);
          s[2]=rs.getString(3);
          s[3]=rs.getString(4);
          s[4]=rs.getString(5);
          s[5]=rs.getString(6);
          s[6]=rs.getString(7);
          s[7]=rs.getString(8);
         
          }
          
         }catch(Exception ex){
           System.out.println(ex.getMessage());}
     return s;		
	}
		public String[] searchID(String c)
	{
	   String[] s=new String[8];
	        try{
          cmd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
          
          
          rs=cmd.executeQuery("select * from TRAIN where ID ='"+c+"'");
          
        while(rs.next()){
          s[0]=rs.getString(1);
          s[1]=rs.getString(2);
          s[2]=rs.getString(3);
          s[3]=rs.getString(4);
          s[4]=rs.getString(5);
          s[5]=rs.getString(6);
          s[6]=rs.getString(7);
          s[7]=rs.getString(8);
         
          }
          
         }catch(Exception ex){
           System.out.println(ex.getMessage());}
     return s;		
	}
	public void newAdd(String a,String b,String c,String d,String e,String f,String g,String h)
	{
		
		String sql="INSERT INTO TRAIN VALUES('"+a+"','"+b+"','"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"')";
		
     try{
          cmd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
          
          
          cmd.executeUpdate(sql);
          
        }catch(Exception ex){
           System.out.println(ex.getMessage());}
	}
public static void main(String args[]){
//	DBoperate dbo=new DBoperate();
	//dbo.searchID("K24");
//	dbo.search("北京","上海");
	
	
}
}