5.16

周四

/**
 * function: 设置学习目标
 */

public static boolean tar(String title1,String main11,String t_s1,String t_e1,String p_n1,String p_p1,String room1,String account) {


    // 根据数据库名称，建立连接
    Connection connection = JDBCUtils.getConn();
    try {
        String sql = "insert into meeting (MeetingName, MeetingContent,MeetingBegin,MeetingEnd,MeetingNum,Participants ,MeetroomId ,UserID) values (?,?,?,?,?,?, ?, ?)";
        if (connection != null) { // connection 不为null表示与数据库建立了连接
            PreparedStatement ps = connection.prepareStatement(sql);


            if (ps != null) {
                System.out.println("12345678");

                ps.setString(1, title1);
                ps.setString(2, main11);
                ps.setString(3, t_s1);
                ps.setString(4, t_e1);
                ps.setString(5, p_n1);
                ps.setString(6, p_p1);
                ps.setString(7, room1);

                ps.setString(8, account);


                // 执行sql查询语句并返回结果集
                int rs = ps.executeUpdate();
                if (rs > 0)
                    return true;
                else
                    return false;
            } else {
                return false;
            }
        } else {
            return false;
        }
    } catch (Exception e) {
        e.printStackTrace();

        return false;
    }

}