A-ASK.rar_A-a_健康_健康管理系统

package com.neusoft.ask.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.neusoft.ask.util.CheckUser; /** * Create on 2009-12-10 * Title 健康管理系统--有问必答 * Description 问题的操作类 * Company * @author daijy * @update 2010-01-10 daijy * @version 1.0 * */ public class QuestionDao { private static String SQL_ADD = "insert into neusoft_question (question_name,question_user) values(?,?)"; private static String SQL_CHANGE = "update neusoft_question set question_content=? where question_name=?"; private static String SQL_REMOVE = "delete from neusoft_question where question_name=?"; /** * Create on 2010-01-10 * Description 添加问题 * @param questionName 问题名称 * @param questionUser 提问者 * @return 是否成功 * @author daijy * @update */ public static boolean add(String questionName,String questionUser){ Connection con = null; PreparedStatement pstmt = null; String rolename = null; try { con = new CheckUser().getConnection();//连接数据库 pstmt = con .prepareStatement(SQL_ADD);//向数据库发送SQL语句 //参数进行设定 pstmt.setString(1, questionName); pstmt.setString(2, questionUser); //让执行数据库SQL ,判断返回值 if (pstmt.executeUpdate()>0) { return true; } } catch (Exception e) { e.printStackTrace(); } finally { try { if (pstmt != null) { pstmt.close(); } if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return false; } public static boolean changeByQName(String questionName,String questionContent){ Connection con = null; PreparedStatement pstmt = null; String rolename = null; try { con = new CheckUser().getConnection();//连接数据库 pstmt = con .prepareStatement(SQL_CHANGE);//向数据库发送SQL语句 //参数进行设定 pstmt.setString(1, questionContent); pstmt.setString(2, questionName); //让执行数据库SQL ,判断返回值 if (pstmt.executeUpdate()>0) { return true; } } catch (Exception e) { e.printStackTrace(); } finally { try { if (pstmt != null) { pstmt.close(); } if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return false; } public static boolean removeByQName(String questionName){ Connection con = null; PreparedStatement pstmt = null; String rolename = null; try { con = new CheckUser().getConnection();//连接数据库 pstmt = con .prepareStatement(SQL_REMOVE);//向数据库发送SQL语句 //参数进行设定 pstmt.setString(1, questionName); //让执行数据库SQL ,判断返回值 if (pstmt.executeUpdate()>0) { return true; } } catch (Exception e) { e.printStackTrace(); } finally { try { if (pstmt != null) { pstmt.close(); } if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return false; } }