java对数据库的操作

  首先新建一access数据库,名为test.mdb.有一张表basicInfor.有五个字段分别是

name varchar(20);password varchar(20);id varchar(10);email varchar(50);handset varchar(11).同时建数据源名为TestData指向test.mdb

下面是java操作代码:

import java.io.* ;
import java.sql.* ;

public class userTest
{
 Connection con=null;
    ResultSet rs=null;
 //实例化，装载jdbc驱动程序

    String name = null ;
    String password = null ;
    String id = null ;
    String email = null ;
    String handset = null ;
 
 public userTest()
 {
    try{
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }
        catch(ClassNotFoundException e){
         System.out.println("发生错误");
         }
    }
   
    public int setInformation( String name ,String password,String id,String email,String handset )
    {
     try{
       this.name = name ;
       this.password = password ;
       this.id = id ;
       this.email = email ;
       this.handset = handset ;
        }catch(Exception e )
        {
         
        }
    }
   
    public int insertInformation()
    {
     try{
     
     String sql = "insert into basicInfor (name,password,id,email,handset) values ("+
     "'"+this.name+"','"+"'"+this.password+"','"+"'"+this.id+"','"+"'"+this.email+"','"+
     "'"+this.handset+"',' )" ;
     
     String url="jdbc:odbc:TestData";
        String username="";
        String password="";
       
        con=DriverManager.getConnection(url,username,password);
        Statement stmt=con.createStatement();
        rs=stmt.executeQuery(sql);
        }catch(Exception e){ }
       
        return 1 ;
    }
   
    public int queryInformation()
    {
     
    }    
 }