ASCII码 ASCII码

AJAX 自学练习 无刷新提交并修改数据库数据并显示

发布于：2022-04-02 10:37:13  栏目：技术文档
  1. AJAX 自学练习 无刷新提交并修改数据库数据并显示
  1. 对应在数据库中表格 rocars表的msg_id,ccrn两个字段。现在要实现在界面上修改ccrn的值，ajax提交到response.jsp页面，并调用RocarsEntiy.updateCcrn方法更新对应的ccrn，最后无刷新显示
  2. request.jsp页面中有rocarsId,和ccrn两个text。
  3. 对应在数据库中表格 rocars表的msg_id,ccrn两个字段。现在要实现在界面上修改ccrn的值，ajax提交到response.jsp页面，并调用RocarsEntiy.updateCcrn方法更新对应的ccrn，最后无刷新显示
  4. 代码：
  5. request.jsp
  2. <%@ page language="java" contentType="text/html; charset=ISO-8859-1" 
  3. pageEncoding="ISO-8859-1"%> 
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
  5. <html> 
  6. <head> 
  7. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 
  8. <title>Insert title here</title> 
  9. <script language="javascript"><!-- 
  10. function GetXmlHttpObject(){ 
  11.     var xmlHttp = null; 
  12.     try{ 
  13.         xmlHttp = new XMLHttpRequest(); 
  14.     }catch(e){ 
  15.         try{ 
  16.             xmlHttp = new ActiveXObject("Msxml2.XMLHTTP"); 
  17.         }catch(e){ 
  18.             xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); 
  19.         } 
  20.     } 
  21.     return xmlHttp; 
  23. } 
  24. function updateCcrn(rocarsId,ccrn){ 
  25. alert(rocarsId) 
  26. alert(ccrn) 
  27.     xmlHttp = GetXmlHttpObject(); 
  28.     if(xmlHttp == null){ 
  29.         alert ("you browser don't support the ajax"); 
  30.          return; 
  31.     } 
  32.     var url = "./response.jsp"; 
  33.     url = url + "?rocarsId="+ rocarsId; 
  34.     url = url + "&ccrn="+ ccrn; 
  35.     url = url + "&sid ="+ Math.random(); 
  36.     xmlHttp.onreadystatechange = stateChanged; 
  37.     xmlHttp.open("GET", url, true); 
  38.     xmlHttp.send(null); 
  39. } 
  40. function getCcrn(str){ 
  41.     xmlHttp = GetXmlHttpObject(); 
  42.     if(xmlHttp == null){ 
  43.         alert ("you browser don't support the ajax"); 
  44.          return; 
  46.     } 
  47.     var url = "./response.jsp"; 
  48.     url = url + "?q="+ str; 
  49.     url = url + "&sid ="+ Math.random(); 
  50.     xmlHttp.onreadystatechange = stateChanged; 
  51.     xmlHttp.open("GET", url, true); 
  52.     xmlHttp.send(null); 
  53. } 
  54. function stateChanged() 
  55. { 
  56.     if(xmlHttp.readyState==4) 
  57.     { 
  58.         document.getElementById("rocarsccrn").value = xmlHttp.responseText; 
  59.     } 
  60. } 
  61. // --></script> 
  62. </head> 
  63. <body> 
  64. <form name="form1" action="" method="post"> 
  65.     <label>rocarsId:</label><input type="text" name="rocarsId" value="140" /> 
  66.     <label>ccrn:</label><input type="text" id="rocarsccrn" name="rocarsccrn" onchange="updateCcrn(document.form1.rocarsId.value,this.value)"/> 
  67. </form> 
  68. </body> 
  69. </html>
  1. response.jsp
  2. <%@ page language="java" contentType="text/plain; charset=UTF-8" 
  3. pageEncoding="UTF-8"%> 
  4. <%@ page import="com.lwf.eus.util.*,java.util.*,com.lwf.eus.entity.*,com.lwf.eus.bean.*" %> 
  5. <% 
  6.     String rocarsId = request.getParameter("rocarsId"); 
  7.     String ccrn = request.getParameter("ccrn"); 
  8.     System.out.println("rocarsId:" + rocarsId); 
  9.     System.out.println("ccrn:" + ccrn); 
  10.     RocarsEntity.updateCcrnById(rocarsId,ccrn); 
  11.     out.print(ccrn); 
  12. %>
  1. RocarsEntity.java
  2. package com.lwf.eus.entity; 
  3. import java.sql.Connection; 
  4. import java.sql.ResultSet; 
  5. import java.sql.SQLException; 
  6. import java.sql.Statement; 
  7. import java.util.Vector; 
  8. import com.lwf.eus.bean.RocarsBean; 
  9. import com.lwf.eus.util.ConnectionManager; 
  10. public class RocarsEntity { 
  11.     public static Vector getRocarsList() { 
  12.         Vector vRocars = new Vector(); 
  13.         //Connection conn = ConnectionManager.getConnection(); 
  14.         Connection conn = ConnectionManager.getConnectionFromDS(); 
  15.         Statement st = ConnectionManager.createStatement(conn); 
  16.         String sql = "select msg_id,ccrn from rocars"; 
  17.         ResultSet rs = null; 
  18.         try { 
  19.             rs = st.executeQuery(sql); 
  20.             while (rs.next()) { 
  21.                 RocarsBean rocars = new RocarsBean(); 
  22.                 rocars.setRocarsId(rs.getString(1)); 
  23.                 rocars.setCcrn(rs.getString(2)); 
  24.                 vRocars.addElement(rocars); 
  25.             } 
  26.         } catch (SQLException e) { 
  27.             e.printStackTrace(); 
  28.         } finally { 
  29.             try { 
  30.                 if (rs != null) { 
  31.                     rs.close(); 
  32.                 } 
  33.             } catch (SQLException e) { 
  34.                 e.printStackTrace(); 
  35.             } 
  36.             try { 
  37.                 if (st != null) { 
  38.                     st.close(); 
  39.                 } 
  40.             } catch (SQLException e) { 
  41.                 e.printStackTrace(); 
  42.             } 
  43.             try { 
  44.                 if (conn != null) { 
  45.                     conn.close(); 
  46.                 } 
  47.             } catch (SQLException e) { 
  48.                 e.printStackTrace(); 
  49.             } 
  50.             return vRocars; 
  51.         } 
  53.     } 
  55.     public static RocarsBean getRocarsListById(String rocarsId){ 
  56.         Connection conn = ConnectionManager.getConnectionFromDS(); 
  57.         Statement st = ConnectionManager.createStatement(conn); 
  58.         String sql = "select * from rocars where msg_id=" + rocarsId; 
  59.         ResultSet rs = null; 
  60.         RocarsBean rocars= null; 
  61.         try { 
  62.             rs = st.executeQuery(sql); 
  63.             rocars = new RocarsBean(); 
  64.             while (rs.next()) {                 
  65.                 rocars.setRocarsId(rs.getString("msg_id")); 
  66.                 rocars.setCcrn(rs.getString("ccrn")); 
  67.             } 
  68.         } catch (SQLException e) { 
  69.             e.printStackTrace(); 
  70.         } finally { 
  71.             try { 
  72.                 if (rs != null) { 
  73.                     rs.close(); 
  74.                 } 
  75.             } catch (SQLException e) { 
  76.                 e.printStackTrace(); 
  77.             } 
  78.             try { 
  79.                 if (st != null) { 
  80.                     st.close(); 
  81.                 } 
  82.             } catch (SQLException e) { 
  83.                 e.printStackTrace(); 
  84.             } 
  85.             try { 
  86.                 if (conn != null) { 
  87.                     conn.close(); 
  88.                 } 
  89.             } catch (SQLException e) { 
  90.                 e.printStackTrace(); 
  91.             } 
  92.             return rocars; 
  93.         } 
  94.     } 
  95.     public static void updateCcrnById(String rocarsId, String ccrn) 
  96.     { 
  97.         Connection conn = null; 
  98.         Statement stmt = null; 
  99.         try { 
  100.             conn = ConnectionManager.getConnectionFromDS(); 
  101.             stmt = ConnectionManager.createStatement(conn); 
  102.             String sqlStr = "update rocars set ccrn= '"+ ccrn + "'" + "where msg_id=" + rocarsId ; 
  103.             stmt.executeUpdate(sqlStr); 
  104.         } catch (SQLException e) { 
  105.             // TODO Auto-generated catch block 
  106.             e.printStackTrace(); 
  107.         } finally{ 
  109.             try { 
  110.                 if (stmt != null) { 
  111.                     stmt.close(); 
  112.                 } 
  113.             } catch (SQLException e) { 
  114.                 e.printStackTrace(); 
  115.             } 
  116.             try { 
  117.                 if (conn != null) { 
  118.                     conn.close(); 
  119.                 } 
  120.             } catch (SQLException e) { 
  121.                 e.printStackTrace(); 
  122.             } 
  123.         } 
  124.     } 
  125. }
  1. ConnectionManager.java
  2. 这里可以直接使用JDBC也可以调用weblogic的数据源JNDI。
  2. package com.lwf.eus.util; 
  3. import java.sql.Connection; 
  4. import java.sql.DriverManager; 
  5. import java.sql.SQLException; 
  6. import java.sql.Statement; 
  7. import javax.naming.Context; 
  8. import javax.naming.InitialContext; 
  9. import javax.naming.NamingException; 
  10. import javax.sql.DataSource; 
  11. public class ConnectionManager { 
  12.     public static Connection getConnection(){ 
  13.         Connection conn = null; 
  14.         String url = "jdbc:postgresql://192.168.0.180/getseus"; 
  15.         String userName = "getsdbadmin"; 
  16.         String pwd = "powerdb"; 
  17.         try { 
  18.             Class.forName("org.postgresql.Driver").newInstance(); 
  19.             conn = DriverManager.getConnection(url,userName,pwd); 
  20.         } catch (SQLException e) { 
  21.             e.printStackTrace(); 
  22.         } catch (ClassNotFoundException e) { 
  23.             e.printStackTrace(); 
  24.         } catch (InstantiationException e) { 
  25.             e.printStackTrace(); 
  26.         } catch (IllegalAccessException e) { 
  27.             e.printStackTrace(); 
  28.         } catch (Exception e){ 
  29.             e.printStackTrace(); 
  30.         } 
  32.         return conn; 
  33.     } 
  35.     public static Connection getConnectionFromDS(){ 
  36.         Connection conn = null; 
  37.         Context ctx = null; 
  38.         try { 
  39.             ctx = new InitialContext(); 
  40.             DataSource ds = (DataSource)ctx.lookup("JNDIPG"); 
  41.             conn = ds.getConnection(); 
  42.         } catch (NamingException e) { 
  43.             // TODO Auto-generated catch block 
  44.             e.printStackTrace(); 
  45.         } catch (SQLException e) { 
  46.             // TODO Auto-generated catch block 
  47.             e.printStackTrace(); 
  48.         } 
  50.         return conn; 
  52.     } 
  54.     public static Statement createStatement(Connection conn){ 
  55.         Statement st = null; 
  56.             try { 
  57.                 st = conn.createStatement(); 
  59.             } catch (SQLException e) { 
  60.                 e.printStackTrace(); 
  61.             } 
  62.         return st; 
  63.     } 
  64. }
相关推荐
阅读 +

© 2020 asciim码

人生就是一场修行