使用 show table status 顯示:Name Type Row_format c_test MyISAM Dynamic
解决方案 »
- 给定一段字符串,其中有a-Z的52个字母组成,其中单词是靠回车或制表符或空格分割,请统计这段文件中有多少个单词
- swt窗口之间的数据传递,请高手帮忙!
- 实现类似word的插入对象-难题求解!
- 各位csdn的高手,有把一个字节数组的值复制到另外一个字节数组的类方法吗?
- 问一下?输出所有ASCII码?
- 如何改变JOptionPane类创建的简单对话框的字体?有没有方法?
- 求救,如何在Jbuilder中拖控件
- 请问什么叫支持JAVA的浏览器
- 侯捷译的《java编程思想》99元,太狠了吧,人家原版可是免费下载的!!!
- 我想下在ULtraEdit-32软件,请给一个网址好吗?多谢!
- 请问开发移动通讯软件应该掌握什么知识,请大家赐教!!!!!!!
- java与C++在面向对象方面有哪些不同?
Variable_name Value
have_bdb YES
have_gemini NO
have_innodb NO
have_isam YES
have_raid NO
have_ssl NO
-------------------------------------------------
con.setAutoCommit(false);
String strSql="INSERT INTO c_test (group_code, group_name) VALUES (?, ?)";
PreparedStatement stmt=con.prepareStatement(strSql);
stmt.setString(1,"8");
stmt.setString(2,"8");
stmt.executeUpdate();
con.rollback();
con.setAutoCommit(true);
----------------------------------------------
顺便一句,con.rollback();应该放在try{..}catch里,你的代码本身也就有问题.找点JDBC的资料看看吧.
---------文件开始------------This File was made using the WinMySQLAdmin 1.3 Tool
#2002-6-11 23:15:49 #Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions [mysqld]
#bind-address=218.242.22.100
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
basedir=C:/mysql
datadir=D:/mysql/data
default-character-set=gbk innodb_data_file_path = ibdata1:10M:autoextend
innodb_data_home_dir = c:/mysql/ibdata
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:/mysql/iblogs
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:/mysql/iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
#set-variable = key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe
user=admin
password=admin
QueryInterval=10
--------------------------------------------------
CREATE TABLE c_test(
id char(1) NOT NULL default '',
name varchar(16) NOT NULL default '',
PRIMARY KEY (id),
KEY id (id)
) TYPE=BerkeleyDB;
--------------------------------------------------
關鍵在於最後一行。 TYPE=BerkeleyDB;如果是4.0之後則使用 TYPE=InnoDB;大家可以試試.