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这样就行了
<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这样就行了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货