🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

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

#20878
From: sure
Date: Sat, 13 Dec 2003 03:12
23 lines
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();
: .................������ʡ�ԣ�
--
�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.79.107.176]
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!SJTU

Show 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