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()
{

}
}