🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

[ת��] ���ڹ�ϵ��ݿ�洢���

#19382
From: �Ԩ
Date: Mon, 05 Jan 2004 10:40
49 lines
2850 bytes
�� ��������ת���� OpenSource ������ ��
�� ԭ���� compl ��� ��
��������һ������, ������ʱ�������󵽱����ʱ��, �еı��
��������ݿ�ʵ�ֵ��Զ���������, ����ORACLE ������sequence,
MySQL�����auto_increment��. ����Ļ���Щ�е�ֵҲ��Ҫ��ӳ
��java����ݶ�����, ������һ��, ֻ�ҵ���һ���ÿɸ�����ݼ�
�İ취�������Ȼ�����ϻ���²����е�������ֵ�İ취, ���ҶԲ�ͬ
��ݿ⻹����ȫ����. �������´���: ��ݿ�ΪMySQL

      Connection con = ds.getConnection();
      Statement stmt =
         con.createStatement(
            ResultSet.TYPE_SCROLL_INSENSITIVE,
            ResultSet.CONCUR_UPDATABLE);
      ResultSet rs = stmt.executeQuery("SELECT * FROM TEST WHERE 1 = 
2");
      if (rs != null)
      {
         rs.moveToInsertRow();
         rs.updateString("NAME", "xixi");
         rs.updateInt("TYPE", 8);
         rs.insertRow();
         rs.last();
         rs.refreshRow();
         System.err.println("Inserted id is: " + rs.getInt("ID"));
         rs.close();
      }
      else
      {
         System.err.println("No result set returned.");
      }
      stmt.close();
      con.close();

����ű�Ϊ:

CREATE TABLE TEST (ID INTEGER auto_increment, NAME VARCHAR(30), TYPE SMALLINT,
   PRIMARY KEY (ID));

��֪�����еĴ洢�����û�н����������, ����JDO, Hibernate
֮���, ��λ�����������澭��ĸ�ָ��һ��, лл!

--

�� Ҫ֪�� ��������

�� ��Դ:��Ʈ��ˮ�Ƽ� freecity.cnzju.net��[FROM: compl]
--
�� ת��:��Ʈ��ˮ�Ƽ� freecity.cnzju.net��[FROM: compl]
Technical Details
Message-ID: <4A91Wh$A8S@freecity.cnzju.net>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!c03.atl99!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!Freecity

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: f6cb0,770e7298b16ea45d,start
X-Google-Attributes: gidf6cb0,public
X-Google-ArrivalTime: 2004-01-05 02:37:27 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!c03.atl99!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!Freecity
From: compl.bbs@freecity.cnzju.net (�Ԩ)
Newsgroups: cn.bbs.comp.lang.java
Subject: [ת��] ���ڹ�ϵ��ݿ�洢���
Date: 05 Jan 2004 10:40:43 GMT
Organization: Ʈ��ˮ�Ƽ�
Message-ID: <4A91Wh$A8S@freecity.cnzju.net>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: Java/M.1073299243.A