本文共 1850 字,大约阅读时间需要 6 分钟。
预先在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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 | import java.sql.*; public class Main { final static String connURL = "jdbc:" ; 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(); } } } |
转载地址:http://kgyvb.baihongyu.com/