import java.sql.*;
class jdbccharujilu{
public static void main(String args[]){
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}catch(ClassNotFoundException ce){
		System.out.println("SQLException:"+ce.getMessage());
		}
try{
	Connection conn=
	DriverManager.getConnection("jdbc:odbc:mylibDB");
	Statement stmt=conn.createStatement();  //A
	//¼
	String sql="insert into book values('85492','java 2 ʵ','Ž','2008-2-2',4,34.5)";
	stmt.executeUpdate(sql);
	stmt.executeUpdate("insert into book values('12345','ԭ','',
'2000-4-2',1,16.5)");
	//ʾеļ¼Ƿɹ¼
	ResultSet rs=stmt.executeQuery("select * from book");
 	while(rs.next())
	{
		//еļ¼ʾֶ
		 System.out.println(":"+rs.getString("no")+"\t"+":"+rs.getString
("name")+"\t"+ "ߣ"+rs.getString("author")+"\t"+"ڣ"+
rs.getDate(4)+"\t"+"Σ"+rs.getInt(5)+"\t"+"۸"+rs.getFloat(6));
		 }
		 //ر
		 rs.close();
		 stmt.close();
		 }catch(SQLException ce){
		 	  System.out.println("SQLException"+ce.getMessage());
		 	  }
	 }
}   
