sun2.java

来自「java 的小的程序 可以对sun编程了解的」· Java 代码 · 共 55 行

import java.sql.*;
public class sun2
{
public static void main(String args[])
{
Connection con;
Statement sql;
ResultSet rs;
try{  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{System.out.println(""+e);}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT name,english FROM chengjibiao ");
rs.last();
int number=rs.getRow();
System.out.println("该表共有"+number+"条记录");
rs.afterLast();
while(rs.previous())
{

String name=rs.getString("name");

int  english=rs.getInt("english");

System.out.println("xingming:"+name);


System.out.println("yingyu:"+english);
}
System.out.println("单独输出第5记录");
rs.absolute(5);
String name=rs.getString("name");

int  english=rs.getInt("english");

System.out.println("xingming:"+name);


System.out.println("yingyu:"+english);
con.close();

}
catch(SQLException e)
{System.out.println(e);}

}

 

}