12.16.6 本部分程序中用到的辅助类方法

public void insert() throws Exception {
DB db = new DB(DBUtil.connectToDB());
title = new String(title.getBytes("GB2312"), "ISO-8859-1");
content = new String(content.getBytes("GB2312"), "ISO-8859-1");
String strSql = "INSERT INTO notice(title, content) values('" + title
+ "','" + content + "')";
try {
db.ExecSql(strSql);
} catch (Exception ex) {
System.err.println(ex.getMessage());
throw ex;
}finally{
try {
System.out.println("finally语句表示无论是否出现异常，都得执行!");
db.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}

public class DBUtil {
static String driverName = "org.gjt.mm.mysql.Driver";
static String dbUrl = "jdbc:mysql://";
static String dbUser = "root";
static String dbPwd = "root";
public DBUtil() {
}
public static java.sql.Connection connectToDB(String hostName,
String databaseName) throws Exception {
String connName = dbUrl + hostName + ":3306/"
+ databaseName;
Class.forName(driverName).newInstance();
Connection connection = DriverManager.getConnection(connName, dbUser,
dbPwd);
return connection;
}
public static java.sql.Connection connectToDB() throws Exception {
return (connectToDB("localhost", "noticemanager"));
}
｝

public DB(Connection connection) {
this.connection = connection;
}

public int ExecSql(String sql) {
int result = 0;
try {
statement = connection.createStatement();
result = statement.executeUpdate(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
}

 public void close() {
if (connection != null) {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (statement != null) {
statement.close();
statement = null;
}
if (connection != null) {
connection.close();
connection = null;
}
} catch (SQLException ex) {
System.err.println(ex.getMessage());
}
}
}
}