admin_mod.jsp

《J2EE专业项目实例开发》源代码

	<%! int update=0; %>

	<%@ page import="java.util.*" %>
	<%@ page import="java.sql.*" %>
	<%@ page import="java.text.*" %>
	<%@ page import="java.sql.Date" %>

	<%@ page language = "java" %> 
	<%
	try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection connect;

	connect=DriverManager.getConnection("jdbc:odbc:RegisterDataSource","wasiqr","bhalbabatu");
	Statement state;
	state = connect.createStatement();

	Float fRate=new Float(request.getParameter("txtRate"));
	float floatRate=fRate.floatValue();
	
	Integer iQty=new Integer(request.getParameter("txtQty"));
	int intQty=iQty.intValue();
	out.println(floatRate);
	out.println(intQty);
	String strTitle=request.getParameter("txtTitle");
	String strDesc=request.getParameter("txtDesc");
	String strSinger=request.getParameter("txtSinger");
	String strType=request.getParameter("txtType");
	String strItemcode=request.getParameter("itemcode");
	out.println("strItemcode"+strItemcode);
	String strQuery2 = "Update Item_Master set Title='"+strTitle+"', Rate='"+floatRate+"', Item_Desc='"+strDesc+"', Singer='"+strSinger+"', Qty_on_hand='"+intQty+"', Type='"+strType+"' where Item_Code='"+strItemcode+"'";
	state.executeUpdate(strQuery2);
	connect.close();

%>
	<jsp:include page="http://localhost:8000/music/admin_home_page.htm" flush="true"/>
<%
	}
	
	
	catch(Exception e){
	out.println("done exception" +e);
	
	}	
	%>