做淘宝一件代发的网站,书店网站建设个人总结,外国人做的古文字网站,网站常识网上的资料真烂#xff0c;千篇一律的拷贝的#xff0c;根本不能用#xff0c;鄙视#xff01; 正题#xff1a; 到MYSQL网站下载mysql-connector-java-5.0.4.zip文件#xff0c;解压#xff1b; 解压后有一个文件#xff1a;mysql-connector-java-5.0.4-bin.jar 把这个…网上的资料真烂千篇一律的拷贝的根本不能用鄙视 正题 到MYSQL网站下载mysql-connector-java-5.0.4.zip文件解压 解压后有一个文件mysql-connector-java-5.0.4-bin.jar 把这个文件放到应用的lib包里或者写一个classpath确定绝对地址。 package org.sytuyuan; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.sql.ResultSet; public class MySqlTest { public static void main(String[] args) { try { Class.forName(com.mysql.jdbc.Driver); Connection con DriverManager.getConnection( jdbc:mysql://localhost/test, root, 123456); Statement stmt con.createStatement(); // stmt.execute(insert into user values(123,null,null,null) ); ResultSet rs stmt.executeQuery(select * from user); while (rs.next()) { System.out.println(rs.getString(userid)); } rs.close(); con.close(); } catch (ClassNotFoundException e) { System.out.println(e.getMessage()); } catch (SQLException ex) { System.out.println(SQLException: ex.getMessage()); System.out.println(SQLState: ex.getSQLState()); System.out.println(VendorError: ex.getErrorCode()); } } }
