Article View: cn.bbs.comp.lang.java
Article #21275Re: ��λ���ְ�æ��һ��ResultSet.updateRow()�����⣿
From: javaphp
Date: Wed, 10 Dec 2003 09:52
Date: Wed, 10 Dec 2003 09:52
44 lines
2430 bytes
2430 bytes
jdbc:odbc���ܲ�֧������IJ�����
--
�ս����һ��վ�㣬������ͬ��Ȥ�����Ѽ��ˣ�
http://www.javaphp.com/
--
���ѡ�fireflyjava���ڡ���λ���ְ�æ��һ��ResultSet.updateRow()�����⣿��һ����д��:
><%@ page language="java" import="java.sql.*,com.jspsmart.upload.*"%>
><jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartU
>pload" />
>
><HTML>
><BODY BGCOLOR="white">
>
><H1>jspSmartUpload : Sample 4</H1>
><HR>
>
><%
>try{
>
>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>Connection con;
>con=DriverManager.getConnection("jdbc:odbc:test","sa","123");
>Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CO
>NCUR_UPDATABLE);
>ResultSet rs = stmt.executeQuery("SELECT id,name FROM test WHERE ID=1");
>rs.next();
>rs.updateInt(1,1);//���е���ͳ�����java.lang.NullPointerException
>rs.updateString(2,"ok");
>rs.updateRow();
>
>
>rs.close();
> stmt.close();
> con.close();
>
>
>}
> catch(Exception e)
> {
> out.println("An error occurs 1: " + e.toString());
> System.out.println("An error occurs 1: " + e.toString());
>}
>%>
Technical Details
Message-ID:
<l6rdtvkopu2psukc2t4cjec37ed0v4bdmh@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.gol.com!newsfeed.kreonet.re.kr!kreonet.re.kr!news3.optonline.net!maily.cic.tsinghua.edu.cn!news.cn99.com!news.yaako.com!not-for-mailReferences:
<49QUJ6$ASV@bbs.zju.edu.cn>Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: f6cb0,4fc60b85d45bbdd8 X-Google-Attributes: gidf6cb0,public X-Google-ArrivalTime: 2003-12-10 01:52:00 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.gol.com!newsfeed.kreonet.re.kr!kreonet.re.kr!news3.optonline.net!maily.cic.tsinghua.edu.cn!news.cn99.com!news.yaako.com!not-for-mail From: javaphp <javaphp@sohu.com> Newsgroups: cn.bbs.comp.lang.java Subject: Re: ��λ���ְ�æ��һ��ResultSet.updateRow()�����⣿ Date: Wed, 10 Dec 2003 17:52:42 +0800 Organization: Bentium Ltd. (CN99) Lines: 45 Message-ID: <l6rdtvkopu2psukc2t4cjec37ed0v4bdmh@4ax.com> References: <49QUJ6$ASV@bbs.zju.edu.cn> Reply-To: javaphp@sohu.com NNTP-Posting-Host: 211.157.16.205 Mime-Version: 1.0 Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 8bit X-Trace: news.yaako.com 1071049882 15576 211.157.16.205 (10 Dec 2003 09:51:22 GMT) X-Complaints-To: usenet@news.yaako.com NNTP-Posting-Date: Wed, 10 Dec 2003 09:51:22 +0000 (UTC) X-Newsreader: Forte Agent 1.8/32.548