package org.local.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.PreparedStatement; import java.util.Date; public class Base2 { /** * @param args * @throws SQLException */ public static void main(String[] args) throws SQLException { // TODO Auto-generated method stub //Test(); // create(); //read("test"); //create("jinyong",new Date(),500.0f); read("jinyong"); } static void Test() throws SQLException{ //Connection conn = JdbcUtil.getConnection(); long start = System.currentTimeMillis(); Connection conn = JdbcUtilSingle.getInstance().getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from user"); while (rs.next()) { System.out.println(rs.getObject(1) + "/t" + rs.getObject(2) + "/t" + rs.getObject(3) + "/t" + rs.getObject(4)); } long end = System.currentTimeMillis(); System.out.println("time:"+(end-start));//计算执行时间ms } public static void create(String name, Date birthday, float money) throws SQLException{ Connection conn = JdbcUtilSingle.getInstance().getConnection(); String sql = "INSERT INTO user VALUES(id,?,?,?)"; PreparedStatement stmt = conn.prepareStatement(sql); stmt.setString(1, name); stmt.setDate(2, new java.sql.Date(birthday.getTime()));//将java.util.Date的时间戳转换为java.sql.Date才能存入数据库 stmt.setFloat(3, money); int i = stmt.executeUpdate(); System.out.println("受影响的行数:"+i); } public static void read(String name) throws SQLException{ long start = System.currentTimeMillis(); Connection conn = JdbcUtilSingle.getInstance().getConnection(); Date birthday = null; PreparedStatement ps = conn .prepareStatement("SELECT * FROM user WHERE name=?"); ps.setString(1, "test"); ResultSet rs = ps.executeQuery(); while (rs.next()) { birthday = rs.getDate("birthday"); System.out.println(rs.getObject(1) + "/t" + rs.getObject(2) + "/t" + rs.getObject(3) + "/t" + rs.getObject(4)); System.out.println("生日"+birthday); } long end = System.currentTimeMillis(); System.out.println("time:" + (end - start));//计算执行时间ms } } 注:Jdbc连接是使用之前文章中的单例类来操作的. 进入JDBC通过Single模式连接Mysql