🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.lang.java
Article #21275

Re: ��λ���ְ�æ��һ��ResultSet.updateRow()�����⣿

#21275
From: javaphp
Date: Wed, 10 Dec 2003 09:52
44 lines
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-mail
References: <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