الفريق العربي للبرمجةأرشيف المنتديات · 2000 – 2023
نسخة أرشيفية للقراءة فقط — التسجيل والمشاركة مغلقان، والمحتوى محفوظ كما كان.

أحتاج للحزمة com.brainysoftware;

مغلق
بدأه Adil-IT في 13 فبراير 2007 · 1 رد · 845 مشاهدة · في JavaEE
مشاركة: واتساب X فيسبوك تيليجرام
#1 صاحب الموضوع

السلام عليكم و رحمة الله وبركاته

عند قيامي بمعالجة نص السيرفلت تأتيني الأخطاء.. و من ضمنها نقص في الحزمة package com.brainysoftware;

فأتمنى لو أن أجدها لديكم.. علما أني بحثت قليلا في جوجل ولم أتمكن من إيجادها..

هذا هو النص: أتمنى إرشادي في حالة وجود أخطاء:

package com.brainysoftware;

import java.util.Hashtable;
import java.util.ArrayList;
import java.util.Enumeration;
import java.sql.*;

public class DbBean {
 public String dbUrl = " ";
 public String dbUserName = " ";
 public String dbPassword = " ";

 public void setDbUrl (String url) {
  dbUrl = url;
  }
  public void setDbUserName (String userName) {
  dbUserName = userName;
  }
  public void setDbPassword (String password) {
  dbPassword = password;
  }
  public Hashtable getCategories () {
   Hashtable ctegories = new Hashtable ();
   try {
   Connection connection = DriverManager.getConnection (dbUrl, DbUserName, 

DbPassword);
   Statement s = connection.createStatement ();
   String sql = " SELECT CategoryId, Category FROM Categories" + " ";
   ResultSet rs = s.executeQuery (sql);
   while (rs.next () ) {			 
	categories.put (rs.getString (1), rs.getString (2) );
	}
	rs.close ();
	s.close ();
	connection.close ();
	}
	catch (SQLException e) {}
	return categories;
	}

	public ArrayList getSearchResults (String keyword) {
	 ArrayList products = new ArrayList ();
	 try {
	 Connection connection = DriverManager.getConnection (dbUrl, dbUserName, 

dbPassword);
	 Statement s = connection.createStatement ();
	 String sql = " SELECT ProductId, Name, Description, Price FROM Products" 

+ " WHERE Name LIKE '%" + keyword.trim () + "%'" OR+ Description LIKE '%" + 

keyword.trim () + "%'";
	 ResultSet rs = s.executeQuery (sql);
	 while (rs.next ()) {
	  Product product = new Product ();
	  product.id = rs.getInt (1);
	  product.name = rs.getString (2);
	  product.description = rs.getString (3);
	  product.price = rs.getDouble (4);
	  products.add(product);
	 } 
	  rs.close ();
	  s.close ();
	  connection.close ();
	}
	catch (SQLException e) {}
	return products;
   }

   public ArrayList getProductsInCategory (String categoryId) {
   ArrayList products = new ArrayList ();
   try {
	Connection connection = DriverManager.getConnection (dbUrl, dbUserName, 

dbPassword);
	Statement s = connection.createStatement ();
	String sql = " SELECT ProductId, Name, Description, Price FROM Products" 

+ " WHERE CategoryId = " + categoryId; 
	ResultSet rs = s.executeQuery (sql);
	while (rs.next ()) {
	  Product product = new Product ();
	  product.id = rs.getInt (1);
	  product.name = rs.getString (2);
	  product.description = rs.getString (3);
	  product.price = rs.getDouble (4);
	  products.add (product);
	 } 
	  rs.close();
	  s.close();
	  connection.close();
	}
	catch (SQLException e) {}
	return products;
   }

   public Product getProductDetails (int productId) {
   Product product = null;
   try {
	Connection connection = DriverManager.getConnection (dbUrl, dbUserName, 

dbPassword);
	Statement s = connection.createStatement();
	String sql = " SELECT ProductId, Name, Description, Price FROM Products" 

+ " WHERE ProductId = " + Integer.toString(productId); 
	ResultSet rs = s.executeQuery(sql);
	 if (rs.next ()) {
	  Product product = new Product ();
	  product.id = rs.getInt (1);
	  product.name = rs.getString (2);
	  product.description = rs.getString (3);
	  product.price = rs.getDouble (4);

	  } 
	  rs.close();
	  s.close();
	  connection.close();
	}
	catch (SQLException e) {}
	return product;
   }

   public boolean insertOrder(String contactName, String deliveryAddress, 

String ccName, String ccNumber, String ccExpiryDate, Hashtable shoppingCart) 

{
   boolean returnValue = false;
   long orderId = System.currentTimeMillis ();
   Connection connection = null;
   try {

	Connection connection = DriverManager.getConnection (dbUrl, dbUserName, 

dbPassword);
	connection.setAutoCommit (false);
	Statement s = connection.createStatement ();
	String sql = " INSERT INTO Orders " + " (OrderId, ContactName, 

DeliveryAddress, CCName, CCNumber, CCExpiryDate) " + " VALUES " + " ( " + 

orderId + ",'" + contactName + "','" + deliveryAddress + "'," + "'" + ccName 

+ "','" + ccNumber + "','" + ccExpiryDate + "')"; 
	s.executeUpdate (sql);

	Enumeration enum = shoppingCart.elements ();
	while (enum.hasMoreElements ()) {
	 ShoppingItem item = (ShoppingItem) enum.nextElement ();
	 sql = " INSERT INTO OrderDetails (OrderId, ProductId, Quantity, Price) " 

+  " VALUES ( " + orderId + "," + item.productId + "," + item.quantity + "," 

+ item.price + ")";
	 s.executeUpdate (sql);
	 }

	 s.close ();
	 connection.commit ();
	 connection.close ();
	 returnValue = true;
	}
	catch (SQLException e) {
	 try {
	  connection.rollback ();
	  connection.close ();

	  }
	   catch (SQLException se) {}
	  }
   return returnValue;
  }
 }

علما أني أستخدم j2sdk1.4.1_05 و jakarta-tomcat-4.1.29.exe

جزاكم الله خير

#2

احذف السطر الأول من الملف .. سطر الـ package

فحنوت ألثم جرحه الرعافَ فانتكأت جراحي..

وهمت على خدي الدموع فقلت يا روحي وراحي..

هلّا رحمتَ قلوبنا .. وعدلت عن هذا الرّواحِ ِ ..؟

فأجابني البطل المسجّى هازئاً بيَ .. باقتراحي

كفكف دموعك ليس في عبراتك الحرّى ارتياحي

هذي سبيلي .. إن صدقت محبتي .. فاحمل سلاحي

Sun Certified Java Programmer

هذا الموضوع مغلق.

مواضيع مشابهة