🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: [java��]jdbc����

#20961
From: sure
Date: Sat, 13 Dec 2003 01:57
23 lines
2102 bytes
�ҿ���������롣����һ���ط����Եģ�
PreparedStatement prepare=dbConn.prepareStatement(Connection conn,String sql
)
��Ȼ���õ���PreparedStatement,�������jdbc��Ԥ�����࣬�����ڱ����ʱ�򣬶���
�е�
sql������Ԥ���?��������Ժ�ӵģ��൱�ڶ�̬��
��Statement�Ǿ�̬��dbConn.prepareCall �����ǵ���һ��CallableStatement��
��������Һ����õģ��ǵ��ô洢��̵��࣬���᳣�õġ�

�� �� apollow.bbs@Freecity.dhs.org (apollo) �Ĵ������ᵽ: ��
: Class.forName(jdbcDriver).newInstance(); //load driver
: Connection  dbConn = DriverManager.getConnection(dbURL); //connect
: String sql = "insert into infor(ID,PASS) values(?,?)";
: PreparedStatement prepare=dbConn.prepareCall(sql);
: prepare.clearParameters();
: prepare.setInt(1,200004);
: prepare.setString(2,"456");
: int result =prepare.executeUpdate();
: ʡȥ��catch()
: sun��sample code��:
: .................������ʡ�ԣ�
--
�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.79.107.176]
Technical Details
Message-ID: <49cbHS$9CL@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: f6cb0,31cf01cc6187e9c5
X-Google-Attributes: gidf6cb0,public
X-Google-ArrivalTime: 2003-12-12 18:00:01 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU
From: mysure.bbs@bbs.sjtu.edu.cn (sure)
Newsgroups: cn.bbs.comp.lang.java
Subject: Re: [java��]jdbc����
Date: 13 Dec 2003 01:57:21 GMT
Organization: ��ˮ˼Դ
Message-ID: <49cbHS$9CL@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: Java/M.1071280204.A
Lines: 23