Article View: cn.bbs.comp.lang.java
Article #19382[ת��] ���ڹ�ϵ��ݿ�洢���
From: �Ԩ
Date: Mon, 05 Jan 2004 10:40
Date: Mon, 05 Jan 2004 10:40
49 lines
2850 bytes
2850 bytes
[1;37m�� ��������ת���� [32mOpenSource [37m������ ��
�� ԭ����[32m compl[37m ��� ��[m
��������һ������, ������ʱ�����������ʱ��, �еı��
��������ݿ�ʵ�ֵ��Զ���������, ����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
֮���, ��λ�����������澭��ĸ�ָ��һ��, лл!
--
�� Ҫ֪�� ��������
[m[1;37m�� ��Դ:��Ʈ��ˮ�Ƽ� freecity.cnzju.net��[FROM: compl][m
--
[m[1;37m�� ת��:��Ʈ��ˮ�Ƽ� freecity.cnzju.net��[FROM: compl][m
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!FreecityShow 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