e代劍客——溫柔一刀

生活就像海洋，只有意志堅強的人，才能到達彼岸

:: 首頁 :: 新隨筆 :: 聯系 :: 聚合

:: 管理 ::

76 隨筆 :: 7 文章 :: 215 評論 :: 0 Trackbacks

隨筆分類(78)

隨筆檔案(76)

搜索

閱讀排行榜

評論排行榜

移動查詢

?

移動查詢

<% @?page?contentType = " text/html;charset=GB2312 " ? %>

<% @?page?import = " java.sql.* " ? %>

< HTML >

< BODY >

? <% ?Connection?con;

????Statement?sql;?

????ResultSet?rs;

????try

????{

??????Class.forName( " com.microsoft.jdbc.sqlserver.SQLServerDriver " );

????}

????catch(ClassNotFoundException?e)

????{

??????out.print( " 類找不到！ " );

????}

????try?

????{??

?????????con = DriverManager.getConnection( " jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse " , " sa " , " 6599996 " );

?????????sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

?????????rs = sql.executeQuery( " SELECT?*?FROM?userTable " );

?????????rs.last(); // 移動到最后一行

????????? int ?rowNumber = rs.getRow(); // 得到最后一行的行號

?????????out.print( " <Table?Border> " );

?????????out.print( " <TR><td?colspan=8?align=center>用戶數據(逆序輸出，共 " + rowNumber + " 條記錄)</td></tr> " );???

?????????out.print( " <TR> " );

????????????out.print( " <Td?width=100?> " + " 用戶ID號 " );

????????????out.print( " <Td?width=50?> " + " 用戶名 " );

????????????out.print( " <Td?width=100> " + " 用戶真實姓名 " );

????????????out.print( " <Td?width=50> " + " 年齡 " );

????????????out.print( " <Td?width=50> " + " 性別 " );

????????????out.print( " <Td?width=100> " + " 聯系地址 " );

????????????out.print( " <Td?width=100> " + " 聯系電話 " );

????????????out.print( " <Td?width=100> " + " 添加時間 " );

?????????out.print( " </TR> " );

???????rs.afterLast(); // 移動到最后一行的后面

??????? while (rs.previous())

???????{?out.print( " <TR> " );

?????????????out.print( " <TD?> " + rs.getLong( 1 ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getString( 2 ) + " </TD> " );?

?????????????out.print( " <TD?> " + rs.getString( 4 ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getInt( " user_age " ) + " </TD> " );?

?????????????out.print( " <TD?> " + rs.getString( " user_sex " ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getString( " user_address " ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getString( " user_telephone " ) + " </TD> " );

?????????????out.print( " <TD?> " + rs.getString( " add_time " ) + " </TD> " );

????????out.print( " </TR> " )?;?

????????}

???????rs.absolute( 2 ); // 移動到第2行

???????out.print( " <TR><td?colspan=8?align=center>指定輸出第2個用戶的數據</td></tr> " );

???????out.print( " <TR> " );