📄 in12_db_insert.htm
字号:
<p class="MsoNormal"><span lang="EN-US"> sql+=" = ?";</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</removeIDSQL></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> PreparedStatement ps = null;</span></p>
<p class="MsoNormal"><span lang="EN-US"> try {</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> if (con.isClosed()) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> throw new
IllegalStateException("error.unexpected");</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</span><span style="font-family: 宋体">用</span><span lang="EN-US">SQL
Server</span><span style="font-family: 宋体">请加入下行</span><span lang="EN-US">:
</span></p>
<p class="MsoNormal"><span lang="EN-US"> con.setAutoCommit(true);</span></p>
<p class="MsoNormal"><span lang="EN-US"> //SQL Server</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps = con.prepareStatement(sql);</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> //<setremovekeyIDdata></span></p>
<p class="MsoNormal"><span lang="EN-US">
ps.setInt(1,java.lang.Integer.parseInt(keyID,10));</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</setremovekeyIDdata></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> if (ps.executeUpdate() != 1) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> throw new SQLException (</span></p>
<p class="MsoNormal"><span lang="EN-US"> "error.removed.dbList");</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> } catch (SQLException e) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> e.printStackTrace();</span></p>
<p class="MsoNormal"><span lang="EN-US"> throw new
RuntimeException("error.unexpected");</span></p>
<p class="MsoNormal"><span lang="EN-US"> } finally {</span></p>
<p class="MsoNormal"><span lang="EN-US"> try {</span></p>
<p class="MsoNormal"><span lang="EN-US"> if (ps != null)</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps.close();</span></p>
<p class="MsoNormal"><span lang="EN-US"> } catch (SQLException e) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> e.printStackTrace();</span></p>
<p class="MsoNormal"><span lang="EN-US"> throw new
RuntimeException("error.unexpected");</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-family: 宋体"> </span><b><span style="font-family: 宋体"> 与记录更新、删除和添加无关的代码省略。</span></b></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">}</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">dbListAction.java</span><span style="font-family: 宋体">文件：</span></p>
<p class="MsoNormal"><b><span style="font-family:黑体">。。。。。。。。。。<span lang="EN-US">(省略)</span></span></b></p>
<p class="MsoNormal"><span lang="EN-US">public final class dbListAction extends
Action </span></p>
<p class="MsoNormal"><span lang="EN-US">{</span></p>
<p class="MsoNormal"><span lang="EN-US"> // </span>
<span style="font-family: 宋体">变量定义：</span></p>
<p class="MsoNormal"><span lang="EN-US"> private Log log =
LogFactory.getLog("org.apache.struts.webapp.Example");</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> private ConnectionPool pool;</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> public dbListAction() {</span></p>
<p class="MsoNormal"><span lang="EN-US"> pool =
ConnectionPool.getInstance();</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> //</span><span style="font-family: 宋体">函数定义：</span></p>
<p class="MsoNormal"><span lang="EN-US"> public ActionForward
execute(ActionMapping mapping,</span></p>
<p class="MsoNormal"><span lang="EN-US"> ActionForm
form,</span></p>
<p class="MsoNormal"><span lang="EN-US">
HttpServletRequest request,</span></p>
<p class="MsoNormal"><span lang="EN-US">
HttpServletResponse response)</span></p>
<p class="MsoNormal"><span lang="EN-US"> throws Exception </span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> // Extract attributes and
parameters we will need</span></p>
<p class="MsoNormal"><span lang="EN-US"> Locale locale =
getLocale(request);</span></p>
<p class="MsoNormal"><span lang="EN-US"> MessageResources messages =
getResources(request);</span></p>
<p class="MsoNormal"><span lang="EN-US"> HttpSession session =
request.getSession();</span></p>
<p class="MsoNormal"><span lang="EN-US"> dbListForm m_dbListForm =
(dbListForm) form;</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> Connection con = null;</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> try </span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> con =
pool.getConnection();</span></p>
<p class="MsoNormal"><span lang="EN-US"> dbListDAO m_dbListDAO =
new dbListDAO(con); //</span><span style="font-family: 宋体">定义</span><span lang="EN-US">DAO</span><span style="font-family: 宋体">对象，用于实现数据库的各种操作</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> String
action=request.getParameter("action"); //</span><span style="font-family: 宋体">动作类型</span><span lang="EN-US">
</span></p>
<p class="MsoNormal"><span lang="EN-US"> String
search=request.getParameter("search"); //</span><span style="font-family: 宋体">数据库查找方式</span></p>
<p class="MsoNormal"><span lang="EN-US"> String
expression=request.getParameter("expression"); //</span><span style="font-family: 宋体">参数，这里用于保存记录（行）的</span><span lang="EN-US">ID</span><span style="font-family: 宋体">数据</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">
if(action==null)action="find";</span></p>
<p class="MsoNormal"><span lang="EN-US">
if(search==null)search="UNsearch";</span></p>
<p class="MsoNormal"><span lang="EN-US">
if(expression==null)expression="";</span></p>
<p class="MsoNormal"><span lang="EN-US">
expression=toChinese(expression); //</span><span style="font-family: 宋体">处理中文问题</span><span lang="EN-US">,</span><span style="font-family: 宋体">实现编码转换</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><b><span lang="EN-US" style="font-family:黑体"> if("delete".equals(action))
//删除记录操作</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> {</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
m_dbListDAO.removeID(expression);</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> }</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
////////////</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
if("update".equals(action)||"insert".equals(action)) //更新、添加记录操作</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> {</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
dbList m_dbList= new dbList(); </span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
//<update></span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
m_dbList.set序号(m_dbListForm.get序号());</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
m_dbList.set姓名(m_dbListForm.get⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -