package com.studentmanager.dao;
import com.studentmanager.bean.NoteBean;
import com.studentmanager.util.DatabaseUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class NoteDao {
public static boolean addNote(String title, String inputText) {
Connection connection = DatabaseUtil.getConnectDB();
String sql = "INSERT INTO `note` (`title`, `note`) VALUES (?, ?)";
int values;
PreparedStatement preparedStatement = null;
try {
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, title);
preparedStatement.setString(2, inputText);
values = preparedStatement.executeUpdate();
return values != 0;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
// public static boolean queryNote(String id) {
// Connection connection = DatabaseUtil.getConnectDB();
// String sql = "SELECT * FROM `note` where id=?";
// ResultSet queryResultSet;
//
// PreparedStatement preparedStatement;
// try {
// preparedStatement = connection.prepareStatement(sql);
// preparedStatement.setString(1, id);
// queryResultSet = preparedStatement.executeQuery();
// return queryResultSet.next();
// } catch (SQLException e) {
// e.printStackTrace();
// return false;
// }
// }
public static ArrayList queryNote(String id) {
ArrayList noteArrayList = new ArrayList<>();
Connection connection = DatabaseUtil.getConnectDB();
String sql = "SELECT * FROM `note` where id=?";
ResultSet queryResultSet;
PreparedStatement preparedStatement;
try {
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, id);
queryResultSet = preparedStatement.executeQuery();
while (queryResultSet.next()) {
NoteBean noteBean = new NoteBean();
noteBean.setId(queryResultSet.getString("id"));
noteBean.setUid(queryResultSet.getString("uid"));
noteBean.setTitle(queryResultSet.getString("title"));
noteBean.setNote(queryResultSet.getString("note"));
noteArrayList.add(noteBean);
}
queryResultSet.close();
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
return noteArrayList;
}
public static ArrayList noteList() {
ArrayList noteArrayList = new ArrayList<>();
Connection connection = DatabaseUtil.getConnectDB();
String sql = "SELECT * FROM `note`";
ResultSet queryResultSet;
PreparedStatement preparedStatement;
try {
preparedStatement = connection.prepareStatement(sql);
queryResultSet = preparedStatement.executeQuery();
while (queryResultSet.next()) {
NoteBean noteBean = new NoteBean();
noteBean.setId(queryResultSet.getString("id"));
noteBean.setUid(queryResultSet.getString("uid"));
noteBean.setTitle(queryResultSet.getString("title"));
noteBean.setNote(queryResultSet.getString("note"));
noteArrayList.add(noteBean);
}
queryResultSet.close();
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
return noteArrayList;
}
public static boolean deleteNote(String id) {
Connection connection = DatabaseUtil.getConnectDB();
String sql = "DELETE FROM `note` WHERE id=?";
int result;
PreparedStatement preparedStatement;
try {
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, id);
result = preparedStatement.executeUpdate();
return result != 0;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
public static boolean updateNote(String id, String title, String inputText) {
Connection connection = DatabaseUtil.getConnectDB();
String sql = "UPDATE `note` SET `title` = ?, `note` = ? WHERE `id` = ?";
int result;
PreparedStatement preparedStatement;
try {
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, title);
preparedStatement.setString(2, inputText);
preparedStatement.setString(3, id);
result = preparedStatement.executeUpdate();
return result != 0;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
}
content_1670595351672.zip （73个子文件） 
NoteManagerJSP 
StudentManagerJSP.iml 1KB src com studentmanager dao AuthDao.java 2KB NoteDao.java 5KB bean NoteBean.java 667B servlet UpdateNoteServlet.java 1KB QueryNoteServlet.java 1KB ShowNoteServlet.java 1KB AddNoteServlet.java 1KB RegisterServlet.java 1KB DeleteNoteServlet.java 1KB LoginServlet.java 1KB util DatabaseUtil.java 2KB .idea dataSources.xml 542B uiDesigner.xml 9KB misc.xml 271B modules.xml 274B workspace.xml 8KB .gitignore 182B dataSources.local.xml 1012B artifacts StudentManagerJSP_war_exploded.xml 531B inspectionProfiles Project_Default.xml 542B sqldialects.xml 227B dataSources f1b9637a-2ee5-4894-bfc4-9db73813efba storage_v2 _src_ schema performance_schema.kIw0nw.meta 76B information_schema.FNRwLQ.meta 76B mysql.osA4Bg.meta 63B f1b9637a-2ee5-4894-bfc4-9db73813efba.xml 55KB student_jsp.sql 1KB out production StudentManagerJSP com studentmanager dao AuthDao.class 2KB NoteDao.class 3KB bean NoteBean.class 1KB servlet LoginServlet.class 2KB AddNoteServlet.class 2KB ShowNoteServlet.class 2KB UpdateNoteServlet.class 2KB DeleteNoteServlet.class 2KB RegisterServlet.class 2KB QueryNoteServlet.class 2KB util DatabaseUtil.class 3KB artifacts StudentManagerJSP_war_exploded notelist.jsp 4KB noteupdate.jsp 5KB style main.css 1KB about.jsp 4KB notequery.jsp 5KB WEB-INF web.xml 402B classes com studentmanager dao AuthDao.class 2KB NoteDao.class 3KB bean NoteBean.class 1KB servlet LoginServlet.class 2KB AddNoteServlet.class 2KB ShowNoteServlet.class 2KB UpdateNoteServlet.class 2KB DeleteNoteServlet.class 2KB RegisterServlet.class 2KB QueryNoteServlet.class 2KB util DatabaseUtil.class 3KB lib 
mysql-connector-j-8.0.31.jar 2.4MB notedelete.jsp 4KB dashboard.jsp 5KB login.jsp 2KB querynote.jsp 4KB register.jsp 2KB notequety.jsp 4KB web notelist.jsp 4KB noteupdate.jsp 5KB style main.css 1KB about.jsp 4KB notequery.jsp 5KB WEB-INF web.xml 402B lib mysql-connector-j-8.0.31.jar 2.4MB notedelete.jsp 4KB dashboard.jsp 5KB login.jsp 2KB register.jsp 2KB资源评论
