e1705.java

java小程序

import java.sql.*;
public class E1705
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from mailTab");
while(rs.next())
{
System.out.println(rs.getString("name")+"\t"+rs.getString("sex")+"\t"+rs.getString("birthday")+"\t"+rs.getString("tel")+"\t"+rs.getString("email")+"\t"+rs.getString("remark")+"\n");
}
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
}
}