WebRoot/gpxx/gpxx_update.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>

<%
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
String sql="";
int row=1;
//	String keyid=(String)request.getParameter("keyid"); 
		String keyid =(String)request.getParameter("keyid");
String gp=(String)request.getParameter("gp");//股票
String sj=(String)request.getParameter("sj");//时间
String bz=(String)request.getParameter("bz");//备注
String jyrq=(String)request.getParameter("jyrq");//交易日期
String kpjg=(String)request.getParameter("kpjg");//开盘价格
String zgj=(String)request.getParameter("zgj");//最高价
String zdj=(String)request.getParameter("zdj");//最低价
String spjg=(String)request.getParameter("spjg");//收盘价格
String zjys=(String)request.getParameter("zjys");//总交易手
String zhjy=(String)request.getParameter("zhjy");//最后交易

/*
.股票信息修改后台页面


*/	
 
sql="update gpxx set gp='"+gp+"',sj='"+sj+"',bz='"+bz+"',jyrq='"+jyrq+"',kpjg='"+kpjg+"',zgj='"+zgj+"',zdj='"+zdj+"',spjg='"+spjg+"',zjys='"+zjys+"',zhjy='"+zhjy+"' where gpxxid='"+keyid+"'";

 //int row=0;

try{
		
			
		 row=db.update(sql);
}catch(Exception e){
System.out.println(e.toString());}
if(row==1){
out.println("<script>");
out.println("alert('操作成功');");
out.println("window.location='gpxxlist.jsp'");
out.println("</script>");
}else{
out.println("<script>");
out.println("alert('操作失败');");
out.println("window.location='gpxxlist.jsp'");
out.println("</script>");
}
db.close();
%>