JAVA连接MySQL
2013-02-18 21:35 blue童鞋 阅读(134) 评论(0) 编辑 收藏 举报预先在MYEclipse的安装途径下\MyEclipse 8.5\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\jre\lib放入驱动文件
mysql-connector-java-5.1.22.tar.gz
import java.sql.*; public class Main { final static String connURL = "jdbc:mysql://127.0.0.1/test"; final static String user = "root"; final static String password = "123456"; static Connection conn = null; static Statement statement = null; static ResultSet res = null; public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { conn = DriverManager.getConnection(connURL, user, password); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if (!conn.isClosed()) { System.out.println("连接成功"); } else { System.out.println("连接失败"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { statement = conn.createStatement(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } String sql = "SELECT * FROM test"; try { res = statement.executeQuery(sql); } catch (SQLException e) { // TODO Auto-generated catch block System.out.println("SQL语句有误"); return; // e.printStackTrace(); } try { for (int i = 1; i != res.getMetaData().getColumnCount() + 1; ++i) { System.out.print(res.getMetaData().getColumnName(i) + " "); } System.out.println(); while (res.next()) { for (int i = 1; i != res.getMetaData().getColumnCount() + 1; ++i) { System.out.print(res.getString(i) + " "); } System.out.println(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }