day14_结构化数据库代码_以mysql为例_包含db.properties,JdbcUtils.java等

package com.hongwei.jdbc; import com.hongwei.bean.User; import com.hongwei.utils.JdbcUtils; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import org.junit.Test; import com.hongwei.utils.JdbcUtils; public class Demo3_insert { public void insert() throws SQLException{ Connection conn = null; Statement st = null; ResultSet rs = null; try{ conn = JdbcUtils.getConnection(); st = conn.createStatement(); String sql ="insert into users(id,name,password,email,birthday) values('4','zhouqiqi','123456','123@qq.com','1992-10-14')"; int num = st.executeUpdate(sql); if(num>0){ System.out.println("插入成功！"); } }finally{ JdbcUtils.release(rs, st, conn); } } @Test public void update() throws SQLException{ Connection conn = null; Statement st = null; ResultSet rs = null; try{ conn = JdbcUtils.getConnection(); st = conn.createStatement(); String sql = "update users set name='zhouxiaowei'"; int num = st.executeUpdate(sql); if(num>0){ System.out.println("修改成功！"); } }finally{ JdbcUtils.release(rs, st, conn); } } @Test public void delete() throws SQLException{ Connection conn = null; Statement st = null; ResultSet rs = null; try{ conn = JdbcUtils.getConnection(); st = conn.createStatement(); String sql ="delete from users where id='1'"; int num = st.executeUpdate(sql); if(num>0){ System.out.println("删除成功！"); } }finally{ JdbcUtils.release(rs, st, conn); } } @Test public void getAll() throws SQLException{ Connection conn = null; Statement st = null; ResultSet rs = null; try{ conn = JdbcUtils.getConnection(); st = conn.createStatement(); String sql ="select * from users"; rs = st.executeQuery(sql); ArrayList<User> list = new ArrayList<User>(); while(rs.next()){ User user = new User(); user.setId(rs.getInt("id")); user.setName(rs.getString("name")); user.setPassword(rs.getString("password")); user.setEmail(rs.getString("email")); user.setDate(rs.getDate("birthday")); list.add(user); } System.out.println(list); }finally{ JdbcUtils.release(rs, st, conn); } } }