Article View: cn.bbs.comp.lang.java
Article #20878Re: [java��]jdbc����
From: sure
Date: Sat, 13 Dec 2003 03:12
Date: Sat, 13 Dec 2003 03:12
23 lines
1924 bytes
1924 bytes
: Class.forName(jdbcDriver); //�����Ѿ�ʵ���ˣ���Ҫ��newInstance : Connection dbConn = DriverManager.getConnection(dbURL); //connect : String sql = "insert into infor(ID,PASS) values(?,?)"; : PreparedStatement prepare=dbConn.preparedStatement(dbConn,sql); : prepare.setLong(1,200004);//200004�Ѿ�����int��Χ : prepare.setString(2,"456"); : int result =prepare.executeUpdate();' good luck �� �� snoppy.bbs@Freecity.dhs.org (û���dz�) �Ĵ������ᵽ: �� : ����ЩSample Code�������µİ��� : �� �� apollow (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(); : .................������ʡ�ԣ� -- [m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.79.107.176][m
Technical Details
Message-ID:
<49cdNF$A4P@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-05!sn-xit-09!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,GB X-Google-Thread: f6cb0,31cf01cc6187e9c5 X-Google-Attributes: gidf6cb0,public X-Google-ArrivalTime: 2003-12-12 19:15:01 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-05!sn-xit-09!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU From: tianmingjie.bbs@bbs.sjtu.edu.cn (sure) Newsgroups: cn.bbs.comp.lang.java Subject: Re: [java��]jdbc���� Date: 13 Dec 2003 03:12:50 GMT Organization: ��ˮ˼Դ Message-ID: <49cdNF$A4P@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: Java/M.1071285087.A