JDBC工具类（含增删改查）

“获得数据库连接”操作，将在以后的增删改查所有功能中都存在，可以封装工具类JDBCUtils。提供获取连接对象的方法，从而达到代码的重复利用。
该工具类提供方法：public static Connection getConn ()。代码如下：

public class JdbcUtils {
	
	private static String driver = "com.mysql.jdbc.Driver";
	private static String url = "jdbc:mysql://localhost:3306/webdb_4";
	private static String user = "root";
	private static String password = "root";
	
	static{
		try {
			//注册驱动
			Class.forName(driver);
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
		
	}
	
	/**
	 * 获得连接
	 * @return
	 * @throws SQLException 
	 */
	public static Connection getConnection() throws  SQLException{
		//获得连接
		Connection conn = DriverManager.getConnection(url, user, password);
		return conn;
	}
	
	/**
	 * 释放资源
	 * @param conn
	 * @param st
	 * @param rs
	 */
	public static void closeResource(Connection conn , Statement st , ResultSet rs){
		
		if(rs != null){
			try {
				rs.close();
			} catch (SQLException e) {
			}
		}
		
		if(st != null){
			try {
				st.close();
			} catch (SQLException e) {
			}
		}

		if(conn != null){
			try {
				conn.close();
			} catch (SQLException e) {
			}
		}
		
	}

JDBC增删改查操作（含工具类）

1.插入

@Test
public void demo01(){
	//添加
	
	Connection conn = null;
	Statement st = null;
	ResultSet rs = null;
	
	try {
		//1 获得连接
		conn = JdbcUtils.getConnection();
		
		//操作
		//1) 获得语句执行者
		st = conn.createStatement();
		//2) 执行sql语句
		int r = st.executeUpdate("insert into category(cname) values('测试')");
		
		//3) 处理结果
		System.out.println(r);
		
	} catch (Exception e) {
		throw new RuntimeException(e);
	} finally{
		//释放资源
		JdbcUtils.closeResource(conn, st, rs);
	}
	
}

2.修改

@Test
public void demo02(){
	//修改
	Connection conn = null;
	Statement st = null;
	ResultSet rs = null;
	
	try {
		conn = JdbcUtils.getConnection();
		
		st = conn.createStatement();
		int r = st.executeUpdate("update category set cname='测试2' where cid = 4");
		System.out.println(r);
		
	} catch (Exception e) {
		throw new RuntimeException(e);
	} finally{
		JdbcUtils.closeResource(conn, st, rs);
	}
	
}

3.删除

@Test
public void demo03(){
	//删除	
	Connection conn = null;
	Statement st = null;
	ResultSet rs = null;
	
	try {
		conn = JdbcUtils.getConnection();
		
		//操作
		st = conn.createStatement();
		int r = st.executeUpdate("delete from category where cid = 4");
		System.out.println(r);
		
	} catch (Exception e) {
		throw new RuntimeException(e);
	} finally{
		JdbcUtils.closeResource(conn, st, rs);
	}
	
}

4.查询（通过id查询详情）

@Test
public void demo04(){
	//通过id查询详情
	Connection conn = null;
	Statement st = null;
	ResultSet rs = null;
	
	try {
		conn = JdbcUtils.getConnection();
		
		//操作
		st = conn.createStatement();
		rs = st.executeQuery("select * from category where cid = 30");
		
		if(rs.next()){
			String cid = rs.getString("cid");
			String cname = rs.getString("cname");
			System.out.println(cid + " @ " + cname );
		} else {
			System.out.println("没有数据");
		}
		
	} catch (Exception e) {
		throw new RuntimeException(e);
	} finally{
		JdbcUtils.closeResource(conn, st, rs);
	}
}

（查询所有）

@Test
public void demo05(){
	//查询所有
	Connection conn = null;
	Statement st = null;
	ResultSet rs = null;
	
	try {
		conn = JdbcUtils.getConnection();
		
		//操作
		st = conn.createStatement();
		rs = st.executeQuery("select * from category");
		
		while(rs.next()){
			String cid = rs.getString("cid");
			String cname = rs.getString("cname");
			System.out.println(cid + " @ " + cname );
		}
		
	} catch (Exception e) {
		throw new RuntimeException(e);
	} finally{
		JdbcUtils.closeResource(conn, st, rs);
	}
}