摘要:CodeChargeStudio ABC.
//參數設定
String SqlStr="";
String conn_str = "jdbc:sqlserver://127.0.0.1:1433;databaseName=PMPIMS;user=PMPIMS;password=31$ynct;";
Connection conn = null;
//建立連線
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection(conn_str);
Statement stmt = conn.createStatement();
Statement stmt2 = conn.createStatement();
PreparedStatement pstmt ;
ResultSet rs ;
ResultSet rsV ;
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
//// ◆session
String ██ = Utils.convertToString(SessionStorage.getInstance(e.getPage().getRequest()).getAttributeAsString("▲▲"));
SessionStorage.getInstance(e.getPage().getRequest()).setAttribute("●●",██);
//// ◆DB data
String ██ = Utils.convertToString(DBTools.dLookUp("Field", "Table", "▲▲='"+▲▲+"'", "SynctConn"));
if( !StringUtils.isEmpty(██) ){
e.getRecord().getControl("●●").setValue(██);
}
//// ◆control
String ██ = Utils.convertToString(e.getRecord().getControl("▲▲").getValue());
e.getRecord().getControl("●●").setValue(██);
//// ◆Request
String ██ = e.getPage().getHttpGetParams().getParameter("▲▲");
//// ◆判斷 新增或修改
if (!e.getRecord().isEditMode()) {
//Insert mode
}else{
//Edit mode
}
//// ◆SQL execute
String orderno = Utils.convertToString(((SqlParameter)e.getParameter("ORDERNO")).getValue());
String Sql = "DELETE ORDER_DETAIL WHERE ORDERNO = '" + orderno + "'";
String ConnName = Utils.convertToString(SessionStorage.getInstance(e.getPage().getRequest()).getAttribute("DBConnection"));
JDBCConnection Conn = JDBCConnectionFactory.getJDBCConnection(ConnName);
Conn.executeUpdate(Sql);
Conn.closeConnection();
//// ◆新增/修改成功訊息
//BeforeShow
String UserMessage = Utils.convertToString(
SessionStorage.getInstance(e.getPage().getRequest()).getAttribute("UserMessage"));
if (!UserMessage.equals("")) {
SessionStorage.getInstance(e.getPage().getRequest()).setAttribute("UserMessage", "");
e.getRecord().addError(UserMessage);
}
//After Execute Insert(Update, Delete)
//// ◆alert
String ██="▲▲";
Utils.printMessage(██,e.getPage().getResponse());
////判斷 空值 Null
if (!██.equals("")) {
}
if( !StringUtils.isEmpty(██) ){
}