1,å®è£
JDK
2,å®è£
eclipse (IDE), javaéæå¼åç¯å¢,å½ç¶ä¹æå
¶ä»,读è
èªè¡éæ©.
3,å®è£
JDBC,æ°æ®åºé©±å¨,ä¸è½½å°å
http://cdn.mysql.com/Downloads/Connector-J/mysql-connector-java-5.1.22.zipæªè³ååæ¶ææ°é©±å¨.
ããããæä¸è½½å¥½çæ件解åå°ä»»æç®å½,è¿éæ为äºä¾¿äºç®¡ç,æ¾å¨åJDKä¸èµ·çç®å½å½ä¸,å¦å¾:
ãã
ããããä¹åæmysql-connetor-java-5.1.22æ件夹ä¸çmysql-connector-java-5.1.22-bin.jar æ·»å å°CLASSPATHéé¢
ããæ¾å°CLASSPATHçæ¹å¼ä¸º ããâæççµèâ-> âå±æ§â -> âé«çº§â -> âç¯å¢åéâ
ããããä¹åå¦å¾ç¼è¾:
ãã
ããããä¸è·¯ç¡®å®å³å¯.
4,æ们æ¥æµè¯ä¸ä¸.
ããä¸,ç»å½æ°æ®åº,æ ¼å¼ä¸º mysql -u(ç¨æ·å) -p(å¯ç ); æçæ¯ mysql -uroot -pll;
ããä»è¿éå¯ä»¥çåºæ¥ææ¯ä»¥è¶
级管çåç»å½æ°æ®åºç,å¯ç æ¯ll. ãã使ç¨å½ä»¤show database; åçªå£ååºäºææçå½åçæ°æ®åº,
ãã
ããããå
¶å®,è¿éçtestæ°æ®åºæ¯æ¬äººä¹å建ç空æ°æ®åº,éé¢ä»ä¹é½æ²¡æ,éè¿use test;å½ä»¤. æ们就è¿å
¥äºæ°æ®åºtest,ç¶åç¨å½ä»¤ show tables; åååºå½åæ°æ®åºææç表;
ãã
ããããå¦æä½ ç没æ,é£ä¹ç¨å½ä»¤ create database test; æ¥å»ºä¸ä¸ª,以便äºæµè¯.
ããããç°å¨æè¦ä¸ºæçæ°æ®åºå»ºè¡¨,并为å
¶å¯¼å
¥æ°æ®.æ们è¿é建ä¸ä¸ªå¦ç表,æææåä¸è¡æ²¡æéå·.
1 CREATE TABLE student
2 (
3 StudentNo VARCHAR(20) PRIMARY KEY,
4 Name VARCHAR(10),
5 Phone VARCHAR(20),
6 Age int
7 );
ãã
ããããè¿æ¯ç¨show tables;å°±å¯ä»¥çè§studentäº.
ãã
ãã好ç为å®å¯¼å
¥æ°æ®.é¦å
建ä¸ä¸ªtxtæ件,æ件çå
容å¦å¾,æ¯ä¸é¡¹å
容,ä¸è¡¨ä¸çæ ¼å¼ç¸å¯¹åº,ä¸é´ç¨tabé®éå¼.è¿éæ¬äººåå为student.txt, ä¸å¤å¨Fçæ ¹ç®å½ä¸.
ãã
1 11111111 ä¸éª 11111001 19
2 22222222 è¥¿æ¯ 22222002 20
3 33333333 åå¸ 33333003 30
4 44444444 被ç 44444404 40
5 55555555 ä¸ç¥é 55555505 50
ãããã使ç¨å½ä»¤å¦ä¸å½ä»¤å°å»ºå¥½çtxtæ件导å
¥è¡¨ä¸
1 load data infile 'F:\student.txt' into table student;
ãããã使ç¨å½ä»¤æ¥ç表ä¸çå
容
1 select * from student;
æå建好表äº!ç°å¨å¼å§åæ们çjavaæ件.ççè½ä¸è½åæ°æ®åºè¿è¡è¿æ¥.
5,javaè¿æ¥æ°æ®åº.
ããé¦å
æ¯æ们çjavaæºæ件
1 import java.sql.*;
2 public class JavaMysql
3 {
4 public static void main(String[] args) throws Exception
5 {
6 String driver="com.mysql.jdbc.Driver";
7 String url="jdbc:mysql://127.0.0.1:3306/test";
8 Class.forName(driver);
9 Connection connecter=DriverManager.getConnection(url,"root","ll");
10 if(!connecter.isClosed()) System.out.println("success in getConnetion");
11 Statement statement=connecter.createStatement();
12 ResultSet rs=statement.executeQuery("select * from student");
13 System.out.println("ç¼å·"+"\t"+"åå"+"Phone"+"\t"+"Age");
14 String No=null,Name=null,Phone=null,Age=null;
15 while(rs.next())
16 {
17 No=rs.getString("studentNo");
18 Name=rs.getString("Name");
19 Phone=rs.getString("Phone");
20 Age=rs.getString("Age");
21 System.out.println(No+"\t"+Name+"\t"+Phone+"\t"+Age);
22 }
23 }
24
25 }
æ§è¡: