admin_add_item_update.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();
	String strQuery1 = "select * from Item_Master" ;
	ResultSet result1 = state.executeQuery(strQuery1);
	int ctr1=0;
   while(result1.next())				
	{										
		ctr1=ctr1+1;
		
	}
	String itemcode="M0000"+(ctr1+1);
	Float fRate=new Float(request.getParameter("txtRate"));
	float floatRate=fRate.floatValue();
	
	Integer iQty=new Integer(request.getParameter("txtQty"));
	int intQty=iQty.intValue();
	
	
	PreparedStatement stat2= connect.prepareStatement("insert into Item_Master values(?,?,?,?,?,?,?,?)");
	stat2.setString(1,itemcode);
	stat2.setString(2,request.getParameter("txtTitle"));
	stat2.setFloat(3,floatRate);
	stat2.setString(4,request.getParameter("txtDesc"));
	stat2.setString(5,request.getParameter("txtSinger"));
	stat2.setInt(6,intQty);
	stat2.setString(7,request.getParameter("txtType"));
	

String strdate=request.getParameter("year")+"-"+request.getParameter("month")+"-"+request.getParameter("date");
	Date date;
	date=Date.valueOf(strdate);
	
	stat2.setString(8,date.toString());
	
	
	
	stat2.executeUpdate();
	connect.close();
%>
	<jsp:include page="admin_home_page.htm" flush="true"/>
<%
	}
	
	
	catch(Exception e){
	out.println("done exception" +e);
	
	}	
	%>