bitscn.com
　1.
现在工程(不是src)上右键--build path--add external archives,选择驱动下的那个jar包，这是release版本，bin目录下的是debug版本。
示例在docs下的connector-j.html，里面有例子（其中的test是数据库名，换位自己的）。
import java.sql.connection;
 import java.sql.drivermanager;
 import java.sql.sqlexception;
 connection conn = null;
 ...
 try {
     conn =
        drivermanager.getconnection(jdbc:mysql://localhost/test? +
                                    user=monty&password=greatsqldb);
     // do something with the connection
    ...
 } catch (sqlexception ex) {
     // handle any errors
     system.out.println(sqlexception: + ex.getmessage());
     system.out.println(sqlstate: + ex.getsqlstate());
     system.out.println(vendorerror: + ex.geterrorcode());
 }
2.可以直接在mysql控制台下创建数据库，也可以在通过执行 /. 绝对路径名。
“--”是注释符。
view code
 import java.sql.connection;
 import java.sql.drivermanager;
 import java.sql.resultset;
 import java.sql.sqlexception;
 import java.sql.statement;
public class mysql {
/**
      * @param args
      */
     public static void main(string[] args) {// 多个try合并到一块,然后使用source --- format
         // todo auto-generated method stub
         //若是用到finally则需要把声明放在try外边
         connection conn = null;
         statement stmt = null;
         resultset rs = null;
try {
             class.forname(com.mysql.jdbc.driver);// 后面若是加上.newinstance则还需要加上几个抛出异常
             conn = drivermanager.getconnection(jdbc:mysql://localhost/mydata?
                     + user=root&password=root);
             /*
              * java.sql.statement; 不是com.mysql这个包； 二者不可以同时存在
              */
             stmt = conn.createstatement();
             rs = stmt.executequery(select * from info);
while (rs.next()) {
                 system.out.println(rs.getstring(name));
}
// do something with the connection
         } catch (classnotfoundexception ex) {
             // handle any errors
             ex.printstacktrace();
} catch (sqlexception ex) {
             // todo auto-generated catch block
             system.out.println(sqlexception: + ex.getmessage());
             system.out.println(sqlstate: + ex.getsqlstate());
             system.out.println(vendorerror: + ex.geterrorcode());
         } finally {
             try {
                 if(null!= rs) {
                     rs.close();
                     rs = null;
                 }
if(null!= stmt) {
                     stmt.close();
                     stmt = null;
                 }
if(null!= conn) {
                     conn.close();
                     conn = null;
                 }
} catch(sqlexception e) {
                 e.printstacktrace();
             }
         }
}
}
bitscn.com