Article View: cn.bbs.comp.lang.java
Article #20961Re: [java��]jdbc����
From: sure
Date: Sat, 13 Dec 2003 01:57
Date: Sat, 13 Dec 2003 01:57
23 lines
2102 bytes
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��: : .................������ʡ�ԣ� -- [m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.79.107.176][m
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!SJTUShow 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