diff options
author | David A. Madore <david+git@madore.org> | 2014-10-12 21:03:33 +0200 |
---|---|---|
committer | David A. Madore <david+git@madore.org> | 2014-10-12 21:03:33 +0200 |
commit | 6c4cab0a9f5dbc019d81eeaeae46c8f17c7bdca7 (patch) | |
tree | dc5c645bc34c95feb9fd1b26cb670880e2a72dcf /org/madore/damlengine/WeblogServlet.java | |
parent | af3d007e78246144f2f50aaadc05f81bae000f84 (diff) | |
download | damlengine-6c4cab0a9f5dbc019d81eeaeae46c8f17c7bdca7.tar.gz damlengine-6c4cab0a9f5dbc019d81eeaeae46c8f17c7bdca7.tar.bz2 damlengine-6c4cab0a9f5dbc019d81eeaeae46c8f17c7bdca7.zip |
Rename the "do_single_page" database column to "special_name", and update Java variables accordingly.
The SQL command is:
ALTER TABLE entries RENAME do_single_page TO special_name ;
Diffstat (limited to 'org/madore/damlengine/WeblogServlet.java')
-rw-r--r-- | org/madore/damlengine/WeblogServlet.java | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/org/madore/damlengine/WeblogServlet.java b/org/madore/damlengine/WeblogServlet.java index 2ceb448..0f7341c 100644 --- a/org/madore/damlengine/WeblogServlet.java +++ b/org/madore/damlengine/WeblogServlet.java @@ -34,7 +34,7 @@ import javax.servlet.http.HttpServletResponse; public class WeblogServlet extends HttpServlet { - private static final long serialVersionUID = 2014101203L; + private static final long serialVersionUID = 2014101204L; @Override public void init(ServletConfig cfg) @@ -79,17 +79,17 @@ public class WeblogServlet extends HttpServlet { try { final Connection conn = WeblogDatabaseConnection.getConnection(); final PreparedStatement selSt - = conn.prepareStatement("SELECT id , extract(epoch from mdate) , do_single_page FROM entries WHERE edate=? AND id=?"); + = conn.prepareStatement("SELECT id , extract(epoch from mdate) , special_name FROM entries WHERE edate=? AND id=?"); selSt.setString(1,date); selSt.setInt(2,number); final ResultSet selRes = selSt.executeQuery(); if ( selRes.next() ) { int id = selRes.getInt(1); double mdate = selRes.getDouble(2); - String doSinglePage = selRes.getString(3); + String specialName = selRes.getString(3); if ( id != number ) throw new ServletException("this cannot happen"); - if ( extra != null && ! extra.equals(doSinglePage) ) + if ( extra != null && ! extra.equals(specialName) ) return new NoSuchPath(); long lastModified = (long)(mdate*1000); long thisLastModified; @@ -120,7 +120,7 @@ public class WeblogServlet extends HttpServlet { try { final Connection conn = WeblogDatabaseConnection.getConnection(); final PreparedStatement selSt - = conn.prepareStatement("SELECT id FROM entries WHERE edate=? AND do_single_page=?"); + = conn.prepareStatement("SELECT id FROM entries WHERE edate=? AND special_name=?"); selSt.setString(1,date); selSt.setString(2,extra); final ResultSet selRes = selSt.executeQuery(); |