首先下载MySQL,
链接地址:http://211.136.10.56/videoplayer/mysql-5.6.20-winx64.zip?ich_u_r_i=879efd4292adc5f47df77d24ded47523&ich_s_t_a_r_t=0&ich_e_n_d=0&ich_k_e_y=1545118924751063232402&ich_t_y_p_e=1&ich_d_i_s_k_i_d=6&ich_u_n_i_t=1
具体安装过程参照网址:http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html
安装好后,要修改root的默认密码,
格式:mysql> set password for 用户名@localhost = password('新密码');
例子:mysql> set password for root@localhost = password('123');
1. 准数据库文件
创建一个LearnJava数据库:
M:\Documents and Settings\apple>mysql -uroot -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.22-community-nt
Query OK, 1 row affected (0.02 sec)
mysql> use LearnJava;
Database changed
mysql> create table UserInfo(
-> UserName varchar (20) not null,
-> UserPwd varchar (20) not null
-> );
Query OK, 0 rows affected (0.06 sec)
插入一条数据:
mysql> insert into UserInfo values ('zieckey','123456');
Query OK, 1 row affected (0.03 sec)
这里我是将mysql-connector-java-5.0.3-bin.jar放在java的安装目录下,
然后导入到CLASSPATH环境变量中,例如:
.;%JAVA_HOME%\lib\tools.jar;%JAVA_HOME%\lib\mysql-connector-java-5.0.3-bin.jar;%JAVA_HOME%\lib\dt.jar;
|
E:\JavaLesson\MySQLTest\test>javac QueryJDBC.java -d .
success loading mysql Driver....
UserName
UserPwd
zieckey 123456
该程序很可能运行出现异常,提示找不到org.gjt.mm.mysql.Driver,
这个可以通过 Project->Properties->Java Build Path->Libraries 选择 Add Extenal JARs,
然后就可以选择第三方jar包:mysql-connector-java-5.0.3-bin.jar
这样程序就可以正常运行了。