JDBC执行多个sql语句dao层代码

去博客设置页面，选择一款你喜欢的代码片高亮样式，下面展示同样高亮的 代码片.

【添加购物车】    AND 【为zsale数据库的salescount字段+1】
			public void updateCarDao(Car c) throws ClassNotFoundException, SQLException{
				//1.加载驱动
				Class.forName("oracle.jdbc.driver.OracleDriver");
				//2.创建连接
				Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");
				
				
				//3.执行SQL语句
				PreparedStatement ps = connection.prepareStatement("insert into zcar values(?,?,?)");
				ps.setInt(1, c.getNum()); 		//1是定位sql语句中第一个“？”，将第二个参数传入“？”中
				ps.setString(2, c.getName());
				ps.setInt(3, c.getPrice());
				//4.处理结果集
				ps.executeUpdate();
				
				//3.执行SQL语句2    
				PreparedStatement ps2 = connection.prepareStatement("update zsale set salescount=salescount+1 where drinkname=?");		
				ps2.setString(1, c.getName());
				
				//4.处理结果集2
				ps2.executeUpdate();
				
				//5.关闭资源
				ps.close();
				connection.close();
			
			}