السلام عليكم ورحمة الله وبركاته
عملت form كالتالى:
<%@ page language ="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%--
Document : purchase
Created on : 27/04/2010, 07:18:29 م
Author : Administrator
--%>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/hardware", "root", "");
Statement st = con.createStatement();
Statement st2 = con.createStatement();
Statement st3 = con.createStatement();
ResultSet clients = st.executeQuery("SELECT client_id,client_name FROM client");
ResultSet staffm = st2.executeQuery("SELECT mem_id,mem_name FROM staff");
ResultSet items = st3.executeQuery("SELECT item_id,item_name FROM item_status");
%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>المبيعات</h1>
<form name="purchase" action="p_response.jsp" method="POST">
<label>العميل</label>
<select name="client">
<% while (clients.next()) {%>
<option value="<%= clients.getInt(1)%>"><%= clients.getString(2)%></option>
<% }%>
</select>
<label>البائع</label>
<select name="member">
<% while (staffm.next()) {%>
<option value="<%= staffm.getInt(1)%>"><%= staffm.getString(2)%></option>
<% }%>
</select>
<label>الصنف</label>
<select name="item">
<% while (items.next()) {%>
<option value="<%= items.getInt(1)%>"><%= items.getString(2)%></option>
<% }%>
</select>
<label>الكمية</label>
<input type="text" name="quantity"/>
<label>التاريخ</label>
<input type="text" name="pdate" readonly="readonly" disabled="disabled" value="<%= new java.util.Date()%>"/>
<input type="submit" value="موافق" name="submit" />
</form>
</body>
</html>ال Code لمعالجة بيانات ال form وادخالها فى قاعدة البيانات كالتالى
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language ="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import = "java.text.SimpleDateFormat,java.text.ParseException"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
String dateStr = request.getParameter("pdate");
SimpleDateFormat formater = new SimpleDateFormat("dd-MM-yyyy hh:mm:ss");
java.util.Date pdate = formater.parse(dateStr);
int client = Integer.parseInt(request.getParameter( "client"));
int member = Integer.parseInt(request.getParameter( "member"));
int item = Integer.parseInt(request.getParameter( "item"));
int quantity = Integer.parseInt(request.getParameter( "quantity"));
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/hardware", "root", "");
PreparedStatement st;
st = con.prepareStatement("insert into `hardware`.`purchase`('p_date','p_quantity','client','member','item') values (?,?,?,?,?)");
st.setDate(1,pdate);
st.setInt(2,quantity);
st.setInt(3,client);
st.setInt(4,member);
st.setInt(5,item);
st.executeUpdate();
%>
</body>
</html>لكن بيعطيني رسالة خطأ التاليه
org.apache.jasper.JasperException: PWC6033: Error in Javac compilation for JSP
PWC6197: An error occurred at line: 17 in the jsp file: /p_response.jsp
PWC6199: Generated servlet error:
string:///p_005fresponse_jsp.java:83: cannot find symbol
symbol : method setDate(int,java.util.Date)
location: interface java.sql.PreparedStatement
ارجو المساعده :)
