Re: [rules-users] Hibernate Configuration with Drools 5.4

On 19/06/2012, zeeshan <zeeshan.spring(a)gmail.com&gt; wrote: Huh? You leave the Excel data as it is except for throwing away the header lines. This is the rule: rule calculatePremium when $pfc: PremiumCalculatorFactBean( $age: age, $policyTerm: policyTerm, $interestRate: interestRate, $gender: gender, $smokingStatus: smokingStatus, $channel: channel, premiumRate == 0.0 ) $p: Premium( age == $age, policyTerm == $policyTerm, interestRate == $interestRate, gender == $gender, smokingStatus == $smokingStatus, channel == $channel ) then modify( $pfc ){ setPremiumRate( $p.getPremiumRate() ) } end And a few lines of Java code: private void makeRates( String csvPath ) throws Exception { File f = new File( csvPath ); InputStream is = new FileInputStream( f ); Reader rdr = new InputStreamReader( is ); LineNumberReader lnrdr = new LineNumberReader( rdr ); String line; while( (line = lnrdr.readLine()) != null ){ if( line.charAt(0) == '"' ) continue; String[] tokens = line.split( ";" ); if( tokens.length != 7 ) continue; int age = Integer.parseInt( tokens[0] ); int policyTerm = Integer.parseInt( tokens[1] ); int interestRate = Integer.parseInt( tokens[2] ); String gender = tokens[3].substring( 1, 2 ); String smokingStatus = tokens[4].substring( 1, 2 ); int channel = Integer.parseInt( tokens[5] ); double premiumRate = Double.parseDouble( tokens[6] ); Premium p = new Premium( age, policyTerm, interestRate, gender, smokingStatus, channel, premiumRate ); kSession.insert( p ); } close( rdr ); } -W