/**
* 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;
}
}