james19790619
![](images/star2.gif) ![](images/star1.gif) ![](images/star1.gif) ![](images/star1.gif)
发贴: 15
积分: 0
|
于 2005-06-02 22:56
![user profile](images_zh_CN/icons/icon_profile.gif) ![send a private message to user](images_zh_CN/icons/icon_pm.gif) ![search all posts by](images_zh_CN/icons/icon_find.gif) ![select and copy to clipboard.
ie only, sorry for netscape users:-)](images_zh_CN/icons/icon_copy.gif)
import java.sql.*;
public class testRoll { public static void main(String [] args) { String url="jdbc:microsoft:sqlserver://localhost:1433;"+"DatabaseName=xscj"; Connection con; Statement st; try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); } catch(ClassNotFoundException e) { System.out.println("Driver can't be loaded"); System.out.println(e.getMessage()); } String username="sa"; String password="001301"; try { con=DriverManager.getConnection(url,username,password); st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); ResultSet rs=st.executeQuery("SELECT * FROM XS"); rs.absolute(4); int rowNum=rs.getRow(); System.out.println("rowNum:\t"+rowNum); rs.relative(-3); rowNum=rs.getRow(); System.out.println("rowNum:\t"+rowNum); rs.absolute(1); System.out.println("after last?"+rs.isAfterLast()); if(!rs.isAfterLast()) { int nID=rs.getInt("学号"); String strName=rs.getString(" 姓名"); System.out.println("id:"+nID+"\tname:"+strName); } rs.close(); st.close(); con.close(); } catch(SQLException se) { System.out.println("SQLException:"+se.getMessage()); } } }
|