2:15 a.m.
Hi every body i am new to Drools section . What i want to achive in drool
let me axplain with example.
When
Price==$price
then
// some code
what we are trying to do is some how value of $price comes from
database.rather hard coding it
what i have did
1. Using jboss developer studio for developing Drool Application
2. Using MySql DataBase
3. My Class File
public static class Applicant {
//public static final int HELLO = 0;
//public static final int GOODBYE = 1;
private String Name;
private int Price;
//private String message;
//private int status;
public String getName()
{
return this.Name;
}
public void setName( String name)
{
this.Name=name;
}
public int getPrice()
{
return this.Price;
}
public void setPrice(int price)
{
this.Price=price;
}
public String GetData()
{
String p=null;
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("my connection info ");
if(!con.isClosed())
System.out.println("Successfully connected to " +
"MySQL server using TCP/IP...");
} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
}
try{
Statement smt=con.createStatement();
ResultSet rs=smt.executeQuery("select ItenPrice from Item Where
ItemId= 1");
while(rs.next())
{
p=rs.getString("ItenPrice");
}
}
catch(Exception a)
{
System.err.println("Exception: " + a.getMessage());
}
return p;
}
public void GetNewdata(Applicant Ap)
{
Ap.GetData();
}
/*
public String getMessage() {
return this.message;
}
public void setMessage(String message) {
this.message = message;
}
public int getStatus() {
return this.status;
}
public void setStatus(int status) {
this.status = status;
}*/
}
4. My drools File
package com.sample
import com.sample.DroolsTest.Applicant;
rule "Hello World"
when
A:Applicant( price<20 )
then
String a=A.GetData();
System.out.println( a );
end
5. what i want in when section insted of writing 20 i can write GetData()
which is returning value from data base, it is working fine in then section
but firing error in when section
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/DataBase-Configuratio...
Sent from the Drools - User mailing list archive at Nabble.com.
5:39 a.m.
Some remarks:
* It's strange to have a non-static method (getData) of a class
(Applicant) where that method isn't tightly connected with anything
from that class.
* price is int, getData() returns a String. This will cause problems.
* You can use
A:Applicant( price< ( ...any Java expression... ) )
but be advised that fetching a value from a database happens at the
time where another Applicant is inserted. If that ItenPrice object is
changed later, the new value will not be used until the next Applicant
is inserted.
-W
On 22 December 2010 09:15, wasim.khan318 <khanwasim07(a)yahoo.co.in> wrote:
Hi every body i am new to Drools section . What i want to achive in drool
let me axplain with example.
When
Price==$price
then
// some code
what we are trying to do is some how value of $price comes from
database.rather hard coding it
what i have did
1. Using jboss developer studio for developing Drool Application
2. Using MySql DataBase
3. My Class File
public static class Applicant {
//public static final int HELLO = 0;
//public static final int GOODBYE = 1;
private String Name;
private int Price;
//private String message;
//private int status;
public String getName()
{
return this.Name;
}
public void setName( String name)
{
this.Name=name;
}
public int getPrice()
{
return this.Price;
}
public void setPrice(int price)
{
this.Price=price;
}
public String GetData()
{
String p=null;
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("my connection info ");
if(!con.isClosed())
System.out.println("Successfully connected to " +
"MySQL server using TCP/IP...");
} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
}
try{
Statement smt=con.createStatement();
ResultSet rs=smt.executeQuery("select ItenPrice from Item Where
ItemId= 1");
while(rs.next())
{
p=rs.getString("ItenPrice");
}
}
catch(Exception a)
{
System.err.println("Exception: " + a.getMessage());
}
return p;
}
public void GetNewdata(Applicant Ap)
{
Ap.GetData();
}
/*
public String getMessage() {
return this.message;
}
public void setMessage(String message) {
this.message = message;
}
public int getStatus() {
return this.status;
}
public void setStatus(int status) {
this.status = status;
}*/
}
4. My drools File
package com.sample
import com.sample.DroolsTest.Applicant;
rule "Hello World"
when
A:Applicant( price<20 )
then
String a=A.GetData();
System.out.println( a );
end
5. what i want in when section insted of writing 20 i can write GetData()
which is returning value from data base, it is working fine in then section
but firing error in when section
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/DataBase-Configuratio...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
7:13 a.m.
Sir i am very new to java and drools please can you correct my example, i am
not getting about
<any java expression>
please it will help full for me a
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/DataBase-Configuratio...
Sent from the Drools - User mailing list archive at Nabble.com.
7:21 a.m.
You can write something like
A: Applicant(,,,, price < ( A.getData() ) )
where 'A' refers to the Applicant object bound to this pattern.
But getData() returns a String, it should return an int so that you can
compare it to the price.
I cannot really advise you on the overall structure of your project, but
consider what others have written. It might be better to include the Item
objects as facts, etc.
-W
On 22 December 2010 14:13, wasim.khan318 <khanwasim07(a)yahoo.co.in> wrote:
Sir i am very new to java and drools please can you correct my example, i
am
not getting about
<any java expression>
please it will help full for me a
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/DataBase-Configuratio...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
5088
days inactive
5088
days old
3 comments
2 participants
participants (2)
-
wasim.khan318 -
Wolfgang Laun