Article View: cn.bbs.comp.lang.java
Article #23612Re: �����PreparedStatement��java��ʵ����ݿ��
From: yes
Date: Wed, 23 Jul 2003 10:09
Date: Wed, 23 Jul 2003 10:09
17 lines
1725 bytes
1725 bytes
ԭ�����
3x!
�� �� samba (�չ���) �Ĵ������ᵽ: ��
: ��ʵ��
: UPDATE count set index��index��n WHERE count.no��m
: ���ǰ�count���б��Ϊm���е�index�е�ֵ��ԭ�л��ϼ�n��m,n������ж�̬ȷ����
: ʹ��PreparedStatement�������ݿ��е���ݣ�����Ҫд���������
: PreparedStatement pstmt=
: conn.prepareStatement("UPDATE count SET index=�� WHERE count.no=?");
: pstmt.setInt(1,2);
: pstmt.setInt(2,2)
: pstmt.executeUpdate();
: ����pstmt.setInt����ֻ��ָ��ȷ����ֵ�����ʵ����ԭ�л��ϼ�һ����
: ...........................
--
[m[1;34m�� ��Դ:������δ��վ bbs.pku.edu.cn��[FROM: 159.226.76.116][m
Technical Details
Message-ID:
<47NFfV$B4V@bbs.pku.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!nnxp1.twtelecom.net!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!news.happynet.org!PKUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: f6cb0,6703d2ed2fb54b7c X-Google-Attributes: gidf6cb0,public X-Google-ArrivalTime: 2003-07-23 03:12:03 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!nnxp1.twtelecom.net!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!news.happynet.org!PKU From: coooool@bbs.pku.edu.cn (yes) Newsgroups: cn.bbs.comp.lang.java Subject: Re: �����PreparedStatement��java��ʵ����ݿ�� Date: 23 Jul 2003 10:09:37 GMT Organization: ����δ��վ Message-ID: <47NFfV$B4V@bbs.pku.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: Java/M.1058954959.A Lines: 17