struts文件上传:struts构建文件上传( 7)

来源: 发布时间:星期四, 2009年1月15日浏览:37次评论:0

package tester.business.maitain;
import tclcc.tester.business.maitain.Trainplan;
import tclcc.tester.util.DBConn;
import java.sql.*;
import java.util.*;
public  TrainPlanDAO {
private DBConn dbconn = null;
private Connection conn = null;
private  final String ADD_TRAINPLAN=
"INSERT INTO KS_TRAINPLAN (p_id,p_title,issue_time,issuer,p_content,p_accessory) VALUES (lpad(SEQ_P_ID.nextVal,10,´0´),?,?,to_date(?,´yyyy-mm-dd´),?,?,?)";
private final  String UPDATE_TRAINPLAN=
"UPDATE KS_TRAINPLAN  p_id=?,p_title=?,post_index=?,issue_time=to_date(?,´yyyy-mm-dd´),issuer=?,p_content=?,p_accessory=? where p_id=?";
/**
* get a connection from a DB pool
* @ Connection
*/
public TrainPlanDAO {
try {
dbconn =  DBConn;
conn = dbconn.getConnection;
} catch (Exception ex) {
ex.prStackTrace;
}
}
/**
* add a row o DB
* @param examinee Examinee
* @throws SQLException
*/
public void addTrainPlan(Trainplan trainPlan) throws SQLException {
PreparedStatement pstmt = null;
try {
pstmt = conn.prepareStatement(ADD_TRAINPLAN);
pstmt.String(1, trainPlan.getP_title);
pstmt.String(2, trainPlan.getIssue_time);
pstmt.String(3, trainPlan.getIssuer);
pstmt.String(4, trainPlan.getP_content);
pstmt.String(5, trainPlan.getP_accessory);
pstmt.executeUpdate;
} catch (SQLException ex) {
ex.prStackTrace;
} finally {
try {
pstmt.close;
//conn.close;
} catch (SQLException ex1) {
}
}
}
/**
* remove a row from DB
* @param trainPlan TrainPlan
* @throws SQLException
*/
public void removeTrainPlan(Trainplan trainPlan) throws SQLException {
this.removeTrainPlan(trainPlan.getP_id);
}
/**
* remove a row from DB
* @param p_id 
* @throws SQLException
*/
public void removeTrainPlan( p_id) throws SQLException {
Statement stmt = null;
try {
stmt = conn.createStatement;
stmt.execute("DELETE FROM ks_trainplan WHERE p_id=" + p_id);
} catch (SQLException ex) {
ex.prStackTrace;
throw  SQLException("SQLExction _disibledevent=  Trainplan;
trainPlan.P_id(rs.getInt("P_ID"));
trainPlan.P_title(rs.getString("P_TITLE"));
trainPlan.Post_index(rs.getInt("POST_INDEX"));
trainPlan.Issue_time(rs.getString("ISSUE_TIME"));
trainPlan.Issuer(rs.getString("ISSUER"));
trainPlan.P_content(rs.getString("P_CONTENT"));
trainPlan.P_accessory(rs.getString("P_ACCESSORY"));
list.add(trainPlan);
}
} catch (SQLException ex) {
} finally {
try {
conn.close;
} catch (SQLException ex1) {
ex1.prStackTrace;
}
 list;
}
}
public  String toString(Trainplan trainPlan){
 trainPlan.getP_title;
}
/**
* for test
* @param args String
*/
}