Using JDBC with MySQL, Getting Started
http://www.developer.com/java/data/article.php/3417381/Using-JDBC-with-MySQL-Getting-Started.htm#Preface
Preface
Purpose
The purpose of this lesson is to get you beyond the initial hurdles involved in:
Downloading and installing a MySQL database server.
Preparing that database for use with JDBC.
Writing and testing your first JDBC programs to administer the database and to manipulate the data stored in the MySQL database.
What is JDBC?
Post a comment
Email Article
Print Article
Share Articles
JDBC technology is an API (included in both J2SE and J2EE) that provides cross-DBMS connectivity to a wide range of SQL databases and access to other tabular data sources, such as spreadsheets or flat files.
What is MySQL?
The MySQL database server is probably the world's most popular open source database software, with more than five million active installations as of September 2004.
The database server software from MySQL is available under a "dual licensing" model. Under this model, users may choose to use MySQL products under the free software/open source GNU General Public License (commonly known as the "GPL") or under a commercial license.
A powerful combination
Simply stated, JDBC makes it possible to write platform independent Java programs that can be used to manipulate the data in a wide range of SQL databases without the requirement to modify and/or recompile the Java programs when moving from platform to platform or from DBMS to DBMS.
MySQL is available for a wide variety of platforms.
Since both JDBC and MySQL are freely available for many purposes, the combination of JDBC and MySQL is a powerful combination that should be of interest for a wide variety of applications.
Viewing tip
You may find it useful to open another copy of this lesson in a separate browser window. That will make it easier for you to scroll back and forth among the different listings and figures w
相关文档：
I found a solution to anyone else who may be having this problem.
First start mysql using skip grant tables
root@ns1 [/var/lib/mysql/mysql]# service mysql start --skip-grant-tables
Starting MySQL [ OK ]
now with mysql started, you can repair the mysql/user table
root@ns1 [/var/lib/mysql ......
这几天所作的工作涉及到数据库行转列的问题
记录一下出现的错误，以免以后再犯
举网上最通俗的例子吧
Name Subject Result
张三 语文 80
张三 数学 90
张三 物理 &n ......
MySQL Migration Toolkit是MySQL出的数据迁移工具(适用于MySQL5.0或以上)，使用并不复杂，支持Oracle,Microsoft SQL Server,Microsoft Access,Sybase,MaxDB到MySQL之间的转换。以下实例是Oracle到MySQL的。
1. 安装jdk1.6
装完MySQL Migration Toolkit还需安装jdk1.6，需要jre1.5.0.8以上的支持。
2. 运行MySQL Mi ......
一、乱码产生原因
mysql字符编码是版本4.1引入的,支持多国语言,而且一些特性已经超过了其他的数据库系统。可以在MySQL Command Line Client 下输入如下命令查看mysql的字符集
mysql> SHOW CHARACTER SET;
+----------+-----------------------------+---------------------+--------+
| Charset | Descr ......
solaris下mysql安装完毕后执行如下操作，可以修改数据库字符集，设置MySQL在Solaris上表名不区分大小写
1.拷贝文件如下：
cp /usr/sfw/share/mysql/my-medium.cnf /etc/my.cnf
把文件只读属性去掉
chmod +w my.cnf
2 设置mysql的字符集：在/etc/my.cnf中的mysqld段和client段加入代码：
[client]
de ......
