📄 _action__jsp.java
字号:
pstmt.setInt( 2, id );
ResultSet rst = pstmt.executeQuery();
if ( rst.next() ) {
if ( caption.equals( rst.getString( "caption" ) ) ) {
SkinUtil.alert( out, "标题重复！" );
}
}
else {
sql = "update tbl_info_template set caption=?,content=? where id=?";
cnn = facade.getConnection();
pstmt = cnn.prepareStatement( sql );
pstmt.setString( 1, caption );
pstmt.setString( 2, content );
pstmt.setInt( 3, id );
pstmt.execute();
response.sendRedirect( "template.jsp" );
}
}
}
if ( action.equals( "del_template" ) ) {
int id = ParamUtil.getIntParameter( request, "id", -1 );
sql = "delete from tbl_info_template where id=" + id;
facade.executeUpdate( sql );
response.sendRedirect( "template.jsp" );
}
if ( action.equals( "add_article" ) ) {
String title = ParamUtil.getStringParameter( request, "title" );
String via_title = ParamUtil.getStringParameter( request, "via_title" );
String content = ParamUtil.getStringParameter( request, "content" );
String derivation = ParamUtil.getStringParameter( request, "derivation" );
String about = ParamUtil.getStringParameter( request, "about" );
String author = ParamUtil.getStringParameter( request, "author" );
int category_id = ParamUtil.getIntParameter( request, "category_id" );
int template_id = ParamUtil.getIntParameter( request, "template_id" );
int root_id = ParamUtil.getIntParameter( request, "root_id" );
String category_caption = ParamUtil.getStringParameter( request, "category_caption" );
boolean has_check = ParamUtil.getCheckboxParameter( request, "has_check" );
boolean has_pic = ParamUtil.getCheckboxParameter( request, "has_pic" );
boolean is_recommend = ParamUtil.getCheckboxParameter( request, "is_recommend" );
boolean allow_html = ParamUtil.getCheckboxParameter( request, "allow_html" );
content = StringUtil.replace( content, "[img]", "<img src=\"\\admin\\info\\show_img.jsp?id=" );
content = StringUtil.replace( content, "[/img]", "\">" );
int article_id = -1;
if ( title.equals( "" ) ) {
SkinUtil.alert( out, "请输入标题！" );
}
else if ( content.equals( "" ) ) {
SkinUtil.alert( out, "请输入内容！" );
}
else {
cnn = facade.getConnection();
cnn.setAutoCommit( false );
sql = "select seq_info.nextval from dual";
ResultSet rst = facade.executeQuery( sql );
rst.next();
article_id = rst.getInt( 1 );
sql = "insert into tbl_info_article( id, category_id, template_id, title, derivation, about, author, has_check, has_pic, is_recommend, create_on, allow_html, via_title ) values( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )";
pstmt = cnn.prepareStatement( sql );
pstmt.setInt( 1, article_id );
pstmt.setInt( 2, category_id );
pstmt.setInt( 3, template_id );
pstmt.setString( 4, title );
pstmt.setString( 5, derivation );
pstmt.setString( 6, about );
pstmt.setString( 7, author );
pstmt.setInt( 8, has_check ? 1 : 0 );
pstmt.setInt( 9, has_pic ? 1 : 0 );
pstmt.setInt( 10, is_recommend ? 1 : 0 );
pstmt.setDate( 11, DateTimeUtil.parseDate( new java.util.Date() ) );
pstmt.setInt( 12, allow_html ? 1 : 0 );
pstmt.setString( 13, via_title );
pstmt.execute();
facade.updateClob( "tbl_info_article", "id", String.valueOf( article_id ), "content", content );
response.sendRedirect( "add_article.jsp?root_id=" + root_id + "&category_id=" + category_id + "&category_caption=" + java.net.URLEncoder.encode( category_caption ) );
}
}
if ( action.equals( "check_article" ) ) {
int category_id = ParamUtil.getIntParameter( request, "category_id", -1 );
int id = ParamUtil.getIntParameter( request, "id", -1 );
sql = "update tbl_info_article set can_pass = 1 where id=" + id;
facade.executeUpdate( sql );
response.sendRedirect( "article.jsp?category_id=" + category_id );
}
if ( action.equals( "edit_article" ) ) {
String title = ParamUtil.getStringParameter( request, "title" );
String content = ParamUtil.getStringParameter( request, "content" );
String via_title = ParamUtil.getStringParameter( request, "via_title" );
int id = ParamUtil.getIntParameter( request, "id", -1 );
int page_no = ParamUtil.getIntParameter( request, "page_no", 1 );
int category_id = ParamUtil.getIntParameter( request, "category_id", -1 );
boolean has_pic = ParamUtil.getCheckboxParameter( request, "has_pic" );
if ( title.equals( "" ) ) {
SkinUtil.alert( out, "请输入标题！" );
}
else if ( content.equals( "" ) ) {
SkinUtil.alert( out, "请输入内容" );
}
else if ( id == -1 ) {
SkinUtil.alert( out, "丢失ID号" );
}
else {
sql = "update tbl_info_article set title=?, has_pic=?, via_title=? where id=?";
cnn = facade.getConnection();
cnn.setAutoCommit( false );
pstmt = cnn.prepareStatement( sql );
pstmt.setString( 1, title );
pstmt.setInt( 2, has_pic ? 1 : 0 );
pstmt.setString( 3, via_title );
pstmt.setInt( 4, id );
pstmt.execute();
facade.updateClob( "tbl_info_article", "id", String.valueOf( id ), "content", content );
response.sendRedirect( "article.jsp?category_id=" + category_id + "&page_no=" + page_no );
}
}
if ( action.equals( "del_article" ) ) {
int id = ParamUtil.getIntParameter( request, "id", -1 );
int page_no = ParamUtil.getIntParameter( request, "page_no", 1 );
int category_id = ParamUtil.getIntParameter( request, "category_id", -1 );
sql = "delete from tbl_info_article where id=" + id;
facade.executeUpdate( sql );
response.sendRedirect( "article.jsp?category_id=" + category_id + "&page_no=" + page_no );
}
if ( action.equals( "del_pic" ) ) {
int id = ParamUtil.getIntParameter( request, "id" );
String pic_id = ParamUtil.getStringParameter( request, "pic_id" );
int category_id = ParamUtil.getIntParameter( request, "category_id", -1 );
Storage.dropById( id );
if ( pic_id.equals( "" ) )
response.sendRedirect( "maintain_pic.jsp?category_id=" + category_id );
else
response.sendRedirect( "upload_pic.jsp?category_id=" + category_id + "&pic_id=" + java.net.URLEncoder.encode( pic_id ) );
}
}
finally {
facade.close();
}
} catch (java.lang.Throwable _jsp_e) {
pageContext.handlePageException(_jsp_e);
} finally {
JspFactory.getDefaultFactory().releasePageContext(pageContext);
}
}
private com.caucho.java.LineMap _caucho_line_map;
private java.util.ArrayList _caucho_depends = new java.util.ArrayList();
public boolean _caucho_isModified()
{
if (_caucho_isDead)
return true;
if (com.caucho.util.CauchoSystem.getVersionId() != 2057024144)
return true;
for (int i = _caucho_depends.size() - 1; i >= 0; i--) {
com.caucho.vfs.Depend depend;
depend = (com.caucho.vfs.Depend) _caucho_depends.get(i);
if (depend.isModified())
return true;
}
return false;
}
public long _caucho_lastModified()
{
return 0;
}
public com.caucho.java.LineMap _caucho_getLineMap()
{
return _caucho_line_map;
}
public void destroy()
{
_caucho_isDead = true;
super.destroy();
}
public void init(com.caucho.java.LineMap lineMap,
com.caucho.vfs.Path appDir)
throws javax.servlet.ServletException
{
com.caucho.vfs.Path resinHome = com.caucho.util.CauchoSystem.getResinHome();
com.caucho.vfs.MergePath mergePath = new com.caucho.vfs.MergePath();
mergePath.addMergePath(appDir);
mergePath.addMergePath(resinHome);
mergePath.addClassPath(getClass().getClassLoader());
_caucho_line_map = new com.caucho.java.LineMap("_action__jsp.java", "/admin/info/action.jsp");
_caucho_line_map.add(12, 1);
_caucho_line_map.add(1, 36);
_caucho_line_map.add(8, 42);
_caucho_line_map.add(12, 45);
com.caucho.vfs.Depend depend;
depend = new com.caucho.vfs.Depend(mergePath.lookup("file:/e:/jnjt/admin/info/action.jsp"), 1030254895965L, 13391L);
_caucho_depends.add(depend);
}
private static byte []_jsp_string1;
private static byte []_jsp_string0;
static {
try {
_jsp_string1 = "\r\n\r\n".getBytes("GB2312");
_jsp_string0 = "\r\n".getBytes("GB2312");
} catch (java.io.UnsupportedEncodingException e) {
e.printStackTrace();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -