安裝MYSQL并用ECLIPSE開發(fā)程序連接

1、MYSQL是免費(fèi)的數(shù)據(jù)庫（Community版本免費(fèi)，Enterprise版本收費(fèi)）一、MYSQL Community Server數(shù)據(jù)庫的下載點(diǎn)擊“Download”點(diǎn)擊“Community”選擇“MySQL Community Server”選擇“Windows (x86, 32-bit), ZIP Archive(mysql-5.6.25-win32.zip)”下載(343.8M)需要注冊O(shè)racal賬戶用戶名：，密碼：注冊登錄后下載二、安裝(此版本不需要安裝， 只需要解壓后放在C盤即可，沒有Setup.exe文件，同TOMCAT安裝方式)mysql-5.6.25-win32.zip文件

2、大?。?43M解壓ZIP文件，放在C盤根目錄中。將里面的數(shù)據(jù)庫文件夾拷貝的C盤根目錄將my-default.ini復(fù)制一份命名為my.ini,注意此文件路徑。打開my.ini，進(jìn)行相關(guān)配置。將相關(guān)的#去掉，并進(jìn)行路徑和字符集配置(端口默認(rèn)3306，主機(jī)地址為，主機(jī)名為localhost，用戶名root，密碼為空) ，這里編碼方式為UTF8，同時(shí)要保證編碼方式都相同# For advice on how to change settings please see# # * DO NOT EDIT THIS FILE. It's a template which will

3、 be copied to the# * default location during install, and will be replaced if you# * upgrade to a newer version of MySQL.mysqld# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_si

4、ze = 128M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required. basedir = "C:mysql-5.6.25-win32" datadir = "C:mysql-5.6.25-win32data"# port = .#

5、server_id = .# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M sql_mode=N

6、O_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES#服務(wù)端的編碼方式character-set-server=UTF8client#客戶端編碼方式，最好和服務(wù)端保持一致loose-default-character-set= UTF8WinMySQLadminServer="C:mysql-5.6.25-win32binmysqld.exe"到DOS命令行下對MYSQL進(jìn)行注冊開始運(yùn)行cmd，然后cd到mysql安裝目錄的bin下面，我的目錄就是“C:mysql-5.6.25-win32bin”。然后執(zhí)行mysqld install 提示服務(wù)

7、安裝成功！運(yùn)行services.msc，確實(shí)有一個(gè)名為MySQL的服務(wù)了，啟動(dòng)它。啟動(dòng)MYSQL數(shù)據(jù)庫（“已啟動(dòng)”）MySQL的默認(rèn)用戶名是root，密碼為空。怎么登錄？還是開始運(yùn)行cmd，cd到bin目錄下，然后執(zhí)行“mysql -u root -p”，提示輸入密碼，由于第一次運(yùn)行，密碼為空可以直接回車。修改密碼。運(yùn)行C: mysql-5.6.25-win32binmysqladmin u root -p password <新密碼> ，然后按回車。（這里將密碼設(shè)置為1234）設(shè)置好密碼之后，推出exit;(要加;)然后重新登錄MYSQL：先到bin路徑下，輸入mysql u r

8、oot p回車，輸入密碼1234后回車，即可登錄。輸入exit即可推出（要加“;”）相關(guān)操作實(shí)例：(首先要進(jìn)入mysql中，mysql命令都要加“;”，不區(qū)分大小寫)1.創(chuàng)建一個(gè)新的數(shù)據(jù)庫create database student;2.顯示所有數(shù)據(jù)庫show databases;3.查看某個(gè)數(shù)據(jù)庫中的表（比如查看數(shù)據(jù)庫mysql中的表）use mysql;show tables;三、在ECLIPSE中配置MYSQL1. 免費(fèi)下載MYSQL的JDBC驅(qū)動(dòng)程序輸入網(wǎng)址: 選擇ZIP下載（8.4M）mysql-connector-java-5.0.8.zip將下載好的JDBC驅(qū)動(dòng)程序解壓。2.

9、配置eclipse(每次新建一個(gè)JAVA APPLICATION工程都需要將JDK和驅(qū)動(dòng)程序加載一次)注意：下面的例子是針對JAVA APPLICATIO工程，如果是JAVA WEB工程，則應(yīng)該把驅(qū)動(dòng)程序首先要?jiǎng)?chuàng)建一個(gè)JAVA APPLICATION工程(這里命名為MysqlJdbc)右鍵點(diǎn)擊工程名稱，選擇“Build Path-Configure Build Path”點(diǎn)擊“Add External JARS”找到驅(qū)動(dòng)程序點(diǎn)擊OK即可，自動(dòng)加載到自動(dòng)生成的Referenced Libraries文件夾中。3. 測試程序 首先創(chuàng)建數(shù)據(jù)庫和表mysql>CREATE DATABASE te

10、st1; /創(chuàng)建一個(gè)數(shù)據(jù)庫mysql>use test1; /指定test為當(dāng)前要操作的數(shù)據(jù)庫mysql>CREATE TABLE user (name VARCHAR(20),password VARCHAR(20); /創(chuàng)建一個(gè)表user，設(shè)置兩個(gè)字段。mysql>INSERT INTO user VALUES('zhu','123'); /插入一條數(shù)據(jù)到表中創(chuàng)建一個(gè)JAVA工程（MysqlJdbc ），創(chuàng)建一個(gè)包（mm）和類（MysqlJdbc1 ）import java.sql.*;public class MysqlJdbc publ

11、ic static void main(String args) try Class.forName("com.mysql.jdbc.Driver"); /加載MYSQL JDBC驅(qū)動(dòng)程序 /Class.forName("org.gjt.mm.mysql.Driver"); System.out.println("Success loading Mysql Driver!"); catch (Exception e) System.out.print("Error loading Mysql Driver!");

12、e.printStackTrace(); try Connection connect = DriverManager.getConnection( "jdbc:mysql:/localhost:3306/test1","root","1234"); /連接URL為 jdbc:mysql/服務(wù)器地址/數(shù)據(jù)庫名 ，后面的2個(gè)參數(shù)分別是登陸用戶名和密碼 System.out.println("Success connect Mysql server!"); Statement stmt = connect.create

13、Statement(); ResultSet rs = stmt.executeQuery("select * from user"); /user 為你表的名稱while (rs.next() System.out.println(rs.getString("name"); catch (Exception e) System.out.print("get data error!"); e.printStackTrace(); 出現(xiàn)上面結(jié)果，說明你連接數(shù)據(jù)庫成功。Success loading Mysql Driver!Succes

14、s connect Mysql server!zhu 下面的例子，往MySQL的user表中插入100條數(shù)據(jù)(創(chuàng)建類Myjproject)package mm;import java.sql.*;public class Myjproject public static void main(String args) try Class.forName("com.mysql.jdbc.Driver"); /加載MYSQL JDBC驅(qū)動(dòng)程序 /Class.forName("org.gjt.mm.mysql.Driver"); System.out.

15、println("Success loading Mysql Driver!"); catch (Exception e) System.out.print("Error loading Mysql Driver!"); e.printStackTrace(); try Connection connect = DriverManager.getConnection( "jdbc:mysql:/localhost:3306/test1","root","1234"); int num=100;

16、PreparedStatement Statement=connect.prepareStatement("INSERT INTO user VALUES(?,?)"); for(int i=0;i<num;i+) /定義個(gè)100次的循環(huán)，往表里插入一百條信息。 Statement.setString(1,"chongshi"+i); Statement.setString(2,"bo"+i); Statement.executeUpdate(); / catch (ClassNotFoundException e) / TOD

17、O Auto-generated catch block / System.out.println("An error has occurred:"+e.toString(); / e.printStackTrace(); catch(SQLException e) 打開MySQL數(shù)據(jù)庫進(jìn)行查看 mysql> show databases;  /查看所數(shù)據(jù)庫mysql> use  test1;    /使test1為當(dāng)前要操作的數(shù)據(jù)庫mysql> show tables; /查看當(dāng)前數(shù)據(jù)庫的所有表

18、mysql> select *from user;  /查看當(dāng)前表（user）的所有信息例3：創(chuàng)建JAVA WEB工程，連接數(shù)據(jù)庫。（使用上面的數(shù)據(jù)庫test1中的user表）1、 創(chuàng)建JAVA WEB工程工程名稱為6-4-12.加載MYSQL數(shù)據(jù)庫驅(qū)動(dòng)程序復(fù)制驅(qū)動(dòng)程序（CTRL+C）mysql-connector-java-5.0.8-bin.jar將此驅(qū)動(dòng)程序拷貝到WebContentWEB-INFlib文件夾下。3.創(chuàng)建JSP文件在WebContent目錄下創(chuàng)建JSP文件，名為testdb.jsp在testdb.jsp中輸入<% page language=&quo

19、t;java" contentType="text/html; charset=gb2312" pageEncoding="gb2312" import="java.sql.*,java.io.*"%><!DOCTYPE html PUBLIC "-/W3C/DTD HTML 4.01 Transitional/EN" "/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><