jdbc向数据库中插入数据.docxVIP

jdbc向数据库中插入数据 使用jdbc链接mysql数据库，并实现数据的批量插入 public boolean insertFrom(Person per){ boolean flag = false; Connection conn = null; conn = JdbcCon.jdbcConMysql(); PreparedStatement ps = null; String sql = insert into person(name,birthday,sex) values(?,?,?); try { ps = conn.prepareStatement(sql); ps.setString(1, per.getName()); ps.setDate(2, per.getBirthday()); ps.setInt(3, per.getSex()); int i = ps.executeUpdate(); if(i != 0){ flag = true; } } catch (SQLException e) { e.printStackTrace(); } finally { JdbcCon.closeAll(null, ps, conn); } return flag; } public boolean updateFrom(int id,int sex,String name){ boolean flag = false; Connection conn = null; conn = JdbcCon.jdbcConMysql(); String sql = update person set sex=?,name=? where id=?; PreparedStatement ps = null; try { ps = conn.prepareStatement(sql); ps.setInt(1, sex); ps.setString(2, name); ps.setInt(3, id); int i = ps.executeUpdate(); if(i != 0){ flag = true; } } catch (SQLException e) { e.printStackTrace(); } finally { JdbcCon.closeAll(null, ps, conn); } return flag; } public boolean deleteFrom(int id){ boolean flag = false; Connection conn = null; conn = JdbcCon.jdbcConMysql(); PreparedStatement ps = null; String sql= delete from person where id=?; try { ps = conn.prepareStatement(sql); ps.setInt(1, id); int i = ps.executeUpdate(); if(i != 0){ flag = true; } } catch (SQLException e) { e.printStackTrace(); } finally { JdbcCon.closeAll(null, ps, conn); } return flag; } public Person selectFrom(String name,int id){ Person per = null; Connection conn = null; conn = JdbcCon.jdbcConMysql(); String sql = select * from person where id=? and name=?; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(sql); ps.setInt(1, id); ps.setString(2,