肯请高手帮我程序提优化，规范一下，谢谢

[netwar]

/*
这个类主要是连接数据库，暂是不用连接池
*/
package com.chainjee;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.Iterator;


public class MyDatabase {
private Connection conn=null;
private PreparedStatement comm=null;

public MyDatabase(){
connectDB();
}

public void connectDB(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
}catch(Exception ex){
System.out.println(ex.toString());
}
}

public void setPrepareSQL(String strSQL) throws Exception{
comm=conn.prepareStatement(strSQL);
}

public void setString(int cols,String defaultValue) throws Exception{
comm.setString(cols,defaultValue);
}

public void setInt(int cols,int defaultValue) throws Exception{
comm.setInt(cols,defaultValue);
}

public Connection getConnection(){
return this.conn;
}

public int executeUpdate(){
int recordAffected=0;
try{
recordAffected=comm.executeUpdate();
}catch(Exception ex){
}
return recordAffected;
}

/*以arrayList的形式返回数据库记录列表*/
public ArrayList executeQuery() {
ArrayList arrayList=new ArrayList();
ResultSet res1=null;
try{
res1=comm.executeQuery();
ResultSetMetaData rsm=res1.getMetaData();
while(res1.next()){
Hashtable hb=new Hashtable();
for(int i=1;i<=rsm.getColumnCount();i++){
String name=rsm.getColumnName(i);
Object value=res1.getObject(i);
hb.put(name,""+value);
}
arrayList.add(hb);
}
}catch(Exception ex){
return null;
}finally{
try{
res1.close();
}catch(Exception e){}
}
return arrayList;
}

/*System Test*/
public static void main(String[] args) throws Exception{
}
}

[netwar]

/*
* *****************************************************************
* 通用信息发布类
* Author:Huang
* Date:2006/10/24
* addArticle:添加相关信息
******************************************************************
*/
package com.chainjee;

import java.util.ArrayList;
import java.util.Hashtable;
import java.util.Iterator;

public class MyArticle {
private String title="";
private String content="";
private int hits=0;
private MyDatabase myDatabase=null;
private String author="";

public MyArticle(){
myDatabase=new MyDatabase();
}


public String getAuthor() {
return author;
}


public String getContent() {
return content;
}


public int getHits() {
return hits;
}


public String getTitle() {
return title;
}


public void setAuthor(String author) {
this.author = author;
}


public void setContent(String content) {
this.content = content;
}


public void setHits(int hits) {
this.hits = hits;
}


public void setTitle(String title) {
this.title = title;
}


public int addArticle(){
String strSQL="insert into article(title,content,author,hits) values(?,?,?,?)";
try{
myDatabase.setPrepareSQL(strSQL);
myDatabase.setString(1,this.title);
myDatabase.setString(2,this.content);
myDatabase.setString(3,this.author);
myDatabase.setInt(4, this.hits);
return myDatabase.executeUpdate();
}catch(Exception ex){
System.out.println("Error"+ex.toString());
return 0;
}
}

public Iterator getArticleList(int ClassId) throws Exception{
String strSQL="SELECT * FROM Article WHERE 1=1 ";
myDatabase.setPrepareSQL(strSQL);
ArrayList arrayList=myDatabase.executeQuery();
ArrayList articles=new ArrayList();
for(int i=0;i<arrayList.size();i++){
Hashtable hb=(Hashtable)(arrayList.get(i));
MyArticle myArticle=new MyArticle();
myArticle.setTitle((String)hb.get("title"));
articles.add(myArticle);
}
return articles.iterator();
}


public static void main(String[] args) {

try {
Iterator a=new MyArticle().getArticleList(25);
while(a.hasNext()){
MyArticle m=(MyArticle)a.next();
System.out.println("huangls"+m.getTitle());
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

这个是新闻发布类，
功能虽然达到了，但是看得是分难受，请高手指点一下,本人感激不尽