struts-config.xml
<action
      attribute="testForm"
      input="/index.jsp"
      name="testForm"
      path="/test"
      scope="request"
      type="com.web.struts.action.TestAction">
      <exception
        key="exception.sql.insert"
        path="/index.jsp"
        type="java.sql.SQLException" />
      <forward name="success" path="/success.jsp" />
      <forward name="fail" path="/index.jsp" />
    </action>action部分代码
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@10.5.7.10:1521:ora9";
String userName = "ssh";
String passWord = "ok";
conn = DriverManager.getConnection(url,userName,passWord);
Statement stmt = conn.createStatement();
/**
 * 
 * 更新数据
 * 用来测试Action对例外的处理
 */
/*
String sql = "insert into users(id,name,password) values('"+testForm.getUserName()+"','"+testForm.getUserName()+"','"+testForm.getPassWord()+"')";
stmt.executeUpdate(sql);
*/
/*
 * 获取用户列表,测试logic标签
 */

String sql1 = "select * from users";
ResultSet rs = stmt.executeQuery(sql1);
TestForm tf = null;

while(rs.next()){
tf = new TestForm();
tf.setUserName(rs.getString("name"));
tf.setPassWord(rs.getString("password"));
list.add(tf);
}
}
catch(SQLException e){
throw e;
}
catch(ClassNotFoundException ex){
throw ex;
}
finally{
if(conn != null){
conn.close();
}
}ApplicationResources.properties文件添加
exception.sql.insert=This UseName is already exist这样就行了