java连接mysql教程_Java连接MySql的文字教程详细介绍

2.可以直接在MySql控制台下创建数据库，也可以在通过执行 ". 绝对路径名"。

“--”是注释符。代码如下:View Codeimport 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 errorsex.printStackTrace();} catch (SQLException ex) {// TODO Auto-generated catch blockSystem.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();}}}}