package jdbc.practice;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;

import org.junit.Test;

import jdbc.utils.JDBCUtils;

public class practice4 {
	@Test
	/**
	 * 首先将表格中的三条数据添加到数据库
	 */
	public void demo1() {
		Connection conn=null;
		PreparedStatement pstmt=null;
		try {
			//获得连接
			conn=JDBCUtils.getConnection();
			//编写sql
			String sql="INSERT INTO course(name,category,desp,createTime) VALUES(?,?,?,?)";
			conn.setAutoCommit(false);
			// 预编译SQL:
			pstmt=conn.prepareStatement(sql);
			// 设置参数:
			pstmt.setString(1,"Java零基础");
			pstmt.setString(2,"Java");
			pstmt.setString(3,"Java基础语法");
			pstmt.setDate(4,new Date(System.currentTimeMillis()));
			pstmt.addBatch();
			pstmt.setString(1,"Java Web");
			pstmt.setString(2,"Java");
			pstmt.setString(3,"Jsp和Servlet");
			pstmt.setDate(4,new Date(System.currentTimeMillis()));
			pstmt.addBatch();
			pstmt.setString(1,"前端小白");
			pstmt.setString(2,"J前端");
			pstmt.setString(3,"HTML/CSS/JS");
			pstmt.setDate(4,new Date(System.currentTimeMillis()));
			pstmt.addBatch();
			int num=pstmt.executeUpdate();
			if(num>0) {
				System.out.println("添加成功");
			}
			conn.commit();
			conn.setAutoCommit(true);
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			JDBCUtils.release(pstmt, conn);
		}
	}
}