java使用mysql---jdbc链接示例
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class jdbc { public static void main (String[] args) { Connection conn = null; String url = "jdbc:mysql://xx.xx.xx.xx:3306/xx?" -------- 指定要读取的数据库地址和database + "useUnicode=true&characterEncoding=UTF8"; try { Class.forName("com.mysql.jdbc.Driver"); System.out.println("成功加载MySQL驱动程序"); conn = DriverManager.getConnection(url, "user", "pwd"); ------- 数据库的用户和密码 Statement stmt = conn.createStatement(); String sql = "select * from Students"; ------- 要使用的查找、插入或更新等语句 ResultSet getInfo = stmt.executeQuery(sql); while (getInfo.next()) { Logger.print(getInfo.getString(1) + ":" + getInfo.getString(2)); ---- 遍历读取的数据并打印 } } catch (SQLException e) { Logger.print("MySQL操作错误"); e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }}