JDBC 小程序

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestJdbc {public static void main(String[] args) {ResultSet rs = null;Statement stmt = null;Connection conn = null;try {Class.forName("com.mysql.jdbc.Driver");conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/mysql?" + "user=root&password=huimie");stmt = conn.createStatement();rs = stmt.executeQuery("select * from tablename1");while (rs.next()) {// 根据字段名获取相应的值String name = rs.getString("name");String sex = rs.getString("sex");int age = rs.getInt("age");// 输出查到的记录的各个字段的值System.out.println(name + " " + sex + " " + age);}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {try {if (rs != null) {rs.close();rs = null;}if (stmt != null) {stmt.close();stmt = null;}if (conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}

这是运行的结果

这是我mysql中的tablename1表中的数据