精通J2EE--ECLIPSE、STRUTS、HIBERNATE及SPRING整合应用案例代码-ch06-2

package nm.model; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class NoticeBean { // 成员变量，对应于数据库里的ID、标题title、内容content三个字段ֶ� int ID; String title; String content; /** * ����Ϊ��������Ա����get/set���� */ /** * @return Returns the iD. */ public int getID() { return ID; } /** * @param id * The iD to set. */ public void setID(int id) { ID = id; } /** * @return Returns the content. */ public String getContent() { return content; } /** * @param content * The content to set. */ public void setContent(String content) { this.content = content; } /** * @return Returns the title. */ public String getTitle() { return title; } /** * @param title * The title to set. */ public void setTitle(String title) { this.title = title; } // 默认构造函数 public NoticeBean() { } // 构造函数 public NoticeBean(String title, String content) { this.title = title; this.content = content; } // insert方法将NoticeBeanr的属性值持久化到数据库中 public void insert() throws Exception { // 本例中采用MySQL数据库，下面是连接时用到的一些参数 // JDBC驱动名 String driverName = "org.gjt.mm.mysql.Driver"; // 连接字符串 String connName = "jdbc:mysql://localhost:3306/javaweb?useUnicode=true&characterEncoding=gb2312"; // 登录用户名 String dbUser = "root"; // 登录密码 String dbPwd = "root"; Class.forName(driverName).newInstance(); // 生成一个连接 Connection con = DriverManager.getConnection(connName, dbUser, dbPwd); PreparedStatement pStmt = null; try { // 执行SQL语句 pStmt = con.prepareStatement("INSERT INTO notice(title, content)" + " values(?, ?)"); con.setAutoCommit(false); pStmt.setString(1, title); pStmt.setString(2, content); pStmt.executeUpdate(); con.commit(); System.out.println("远程文件修改1"); } catch (Exception ex) { try { con.rollback(); } catch (SQLException sqlex) { sqlex.printStackTrace(System.out); } throw ex; } finally { try { // 关闭连接 pStmt.close(); con.close(); } catch (Exception e) { e.printStackTrace(); } } } }