操作数据库jdbc

步骤:

    1.注册驱动;

    2:获取链接

    3.创建sql语句

    4.创建对象

    5.执行sql语句

    6.获取resultSet结果集

    7.关闭

/**
 * jdbc操作
 * 1.注册驱动
 * 2.获取链接
 * 3.获取语句执行者
 * 4.执行sql语句
 * 5.处理结果
 * 6.释放资源
 * @author Administrator
 *
 */
public class ConnectTest {
	
	@Test
	public void jdbcTest(){
		
		try {
			//1.注册驱动
			Class.forName("com.mysql.jdbc.Driver");
			//2.获取链接
			Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/review","root","1234");
			//3.获取链接语句
			/*Statement state = conn.createStatement();
			String sql="select * from category";
			state.execute(sql);
			ResultSet resultSet = state.getResultSet();//获取结果集
			if(resultSet.next()){
				String cid = resultSet.getString("cid");
				System.out.println(cid);
				
			}*/
			//获取预处理对象
			/*String sql="select * from category";
			PreparedStatement prepared = conn.prepareStatement(sql);
			ResultSet resultSet = prepared.executeQuery();
			while(resultSet.next()){
				String cid = resultSet.getString("cid");
				System.out.println(cid);
				
			}*/
			String updateSql="update category set cname = ? where cid = ?;";
			PreparedStatement  state = conn.prepareStatement(updateSql);
			state.setString(1,"家电1");
			state.setString(2, "c001");
			int executeUpdate = state.executeUpdate();
			System.out.println(executeUpdate);
			state.close();
			conn.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

}