Nodry's X-File

테스트)-------------------------------------------------------------
C:\j2sdk1.4.2_01\jre\lib\ext 에 mysql-connector-java-3.0.9-stable-bin.jar를 넣어준다.

mysql-connector-java-3.0.9-stable-bin.jar 이 파일은 http://mmmysql.sourceforge.net/ 에서 찾는다

''a
--------------------------------------------------------------------
테스트를 하기 위해서 아래의 자바파일을 컴파일 해준 뒤

import java.sql.*;

class CreateTestMsql {
public static void main (String args []) throws Exception {

// JDBC 드라이버를 로드한다.
Class.forName("org.gjt.mm.mysql.Driver");

// 데이터베이스에 접속한다. 적절한 JDBC URL 설정한다.
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","tester","1234");

//3306 mysql의 포트번호

Statement stmt = con.createStatement();
stmt.executeUpdate("CREATE TABLE student " + "(num int, name char(20), addr char(50), " +

"average float)");
stmt.close();
con.close();
}
}
-----------------------------------------------------
tester로 접속하여 확인해 본다

C:\mysql\bin>mysql -u localhost -u tester -p1234 test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 4.0.16-max-de

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)

mysql> use test
Database changed

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| student |
+----------------+
1 row in set (0.00 sec)

mysql> select * from student;
Empty set (0.00 sec)

mysql> desc student;
+---------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| num | int(11) | YES | | NULL | |
| name | char(20) | YES | | NULL | |
| addr | char(50) | YES | | NULL | |
| average | float | YES | | NULL | |
+---------+----------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql>