dbutil.java

用java连接数据库的最基本入门代码

//读取数据库中的数据
import java.sql.*; 

public class DBUtil 
{ 
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
String sConnStr = "jdbc:odbc:test";  //test是用ODBC创建的，本例中的数据库是用acess建立的，很简单的一个表，里面只有两个字段
Connection conn = null; 
ResultSet rs = null; 

public DBUtil() 
{ 
try 
{ 
Class.forName(sDBDriver); 
} 
catch(java.lang.ClassNotFoundException e) 
{ 
System.err.println("testJDBC(): " + e.getMessage()); 
} 
} 

public ResultSet executeQuery(String testJDBC) 
{ 
rs = null; 
try 
{ 
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement(); 
rs = stmt.executeQuery(testJDBC); 
} 
catch(SQLException ex) 
{ 
System.err.println("aq.executeQuery: " + ex.getMessage()); 
} 
return rs; 
} 
public static void main(String[] args) throws SQLException 
{
 DBUtil dbu=new DBUtil();


    String str_name;
    String str_gender;
    ResultSet rs = dbu.executeQuery("select * from testinfo");
    while(rs.next())
    {
        str_name = rs.getString("name");
        str_gender = rs.getString("gender");
        System.out.println("从数据库中取出数据：：：");
        System.out.println("name is:"+str_name);
        System.out.println("gender is:"+str_gender);
    }	
   
}
}