Em Andamento

Read excel file then write to mysql

Need some one who will be able to use java servlet to write a function to read excel file then write to mysql. Please see attached file.

Thanks

Kevin Cao

public void setRateSheet( ExcelFile ) {

???

??

??

}

This is my mysql;



CREATE DATABASE /*!32312 IF NOT EXISTS*/ guidelinedb;
USE guidelinedb;

--
-- Table structure for table `guidelinedb`.`rate`
--

DROP TABLE IF EXISTS `rate`;
CREATE TABLE `rate` (
`RateId` bigint(20) NOT NULL auto_increment COMMENT 'Rate ID',
`LenderId` int(11) NOT NULL default '0' COMMENT 'Lender ID',
`ProgramId` int(11) NOT NULL default '0' COMMENT 'Program ID',
`ProgramName` varchar(64) NOT NULL default 'Program Name' COMMENT 'Program Name',
`Rate` double(7,3) NOT NULL default '0.000' COMMENT 'Base Interest Rate',
`YSP` double(7,3) NOT NULL default '0.000' COMMENT 'Yield Spread Premium ',
`Margin` double(7,3) NOT NULL default '0.000' COMMENT 'Margin',
`RateLevel` int(11) NOT NULL default '0' COMMENT 'Rate Level: Bronze, Silver, Gold, Platinum',
`AmortizationType` int(11) NOT NULL default '0' COMMENT 'Amortization: Fix or Adjustable',
`Status` tinyint(4) NOT NULL default '0' COMMENT 'Status: 1=Active, 0=Inactive',
`UpdateDate` bigint(20) NOT NULL default '0' COMMENT 'Date Last Updated',
`UpdateBy` int(11) NOT NULL default '0' COMMENT 'Who Updated',
PRIMARY KEY (`RateId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Dumping data for table `guidelinedb`.`rate`
--

/*!40000 ALTER TABLE `rate` DISABLE KEYS */;
INSERT INTO `rate` (`RateId`,`LenderId`,`ProgramId`,`ProgramName`,`Rate`,`YSP`,`Margin`,`RateLevel`,`AmortizationType`,`Status`,`UpdateDate`,`UpdateBy`) VALUES
(1,2000,9,'CL ALTA 30',6.000,1.000,0.000,228,78,1,1168561328066,2000),
(2,2000,9,'CL ALTA 30',6.250,0.750,0.000,228,78,1,1168561328066,2000),
(3,2000,9,'30YR FIXED',6.125,0.500,0.000,228,78,1,1168561328066,2000),
(4,2000,9,'30YR FIXED',5.250,0.250,0.000,228,78,1,1168561328066,2000),
(5,3000,9,'DAKOTA 30',6.000,0.500,0.000,228,78,1,1168561328066,2000),
(6,3000,9,'DAKOTA 30',6.250,0.250,0.000,228,78,1,1168561328066,2000),
(7,5000,9,'ProgramName 30',6.250,0.750,0.000,228,78,1,1168561328066,2000),
(8,5000,9,'ProgramName 30',6.000,1.000,0.000,228,78,1,1168561328066,2000),
(9,4000,9,'Program Name 30',6.000,0.250,0.000,228,78,1,1168561328066,2000),
(10,4000,9,'Program Name 30',6.250,0.500,0.000,228,78,1,1168561328066,2000),
(11,2000,18,'HELOC',7.250,0.250,0.000,227,18,1,1168561328066,2000),
(12,3000,18,'HELOC',7.500,0.500,0.000,228,18,1,1168561328066,2000),
(13,3000,9,'Program 9',6.500,0.750,0.000,227,78,1,1168561328066,2000);
INSERT INTO `rate` (`RateId`,`LenderId`,`ProgramId`,`ProgramName`,`Rate`,`YSP`,`Margin`,`RateLevel`,`AmortizationType`,`Status`,`UpdateDate`,`UpdateBy`) VALUES
(14,3000,10,'Program Name 15-1',6.500,0.750,0.000,228,78,1,1168561328066,2000),
(15,3000,10,'Program Name 15-1',6.250,0.500,0.000,228,78,1,1168561328066,2000),
(16,2000,10,'Program Name 15-1',6.500,0.750,0.000,228,78,1,1168561328066,2000),
(17,2000,10,'Program Name 15-1',6.250,0.500,0.000,228,78,1,1168561328066,2000),
(18,5000,18,'HELOC',7.250,0.250,0.000,227,18,1,1168561328066,2000),
(19,5000,18,'HELOC',7.000,0.125,0.000,227,18,1,1168561328066,2000),
(20,3500,9,'FIKO 500',8.500,0.500,0.000,229,78,1,1168561328066,2000),
(21,3500,9,'FIKO 500',8.750,0.750,0.000,229,78,1,1168561328066,2000),
(22,3500,9,'FIKO 500',9.000,1.000,0.000,229,78,1,1168561328066,2000),
(23,3000,9,'DAKOTA 30',7.250,1.000,0.000,228,78,1,1168561328066,2000),
(24,3000,18,'HELOC',8.000,0.500,0.000,228,18,1,1168561328066,2000),
(25,3000,18,'HELOC',7.000,0.500,0.000,228,18,1,1168561328066,2000),
(26,3000,18,'HELOC',7.500,0.250,0.000,228,18,1,1168561328066,2000);
/*!40000 ALTER TABLE `rate` ENABLE KEYS */;

Habilidades: J2EE, Java

Ver mais: mysql read excel, read excel java, write excel file mysql java, read excel file mysql java, mysql read file, write excel mysql, mysql excel java, j2ee write excel apache, create table mysql insert xls file, reading excel file mysql, read excel file using jsp spring, excel read write mysql, read excel mysql, mysql read excel file, java read excel file, reading excel files mysql, read excel file mysql, j2ee reading excel files, excel &, mysql read write excel, java poi excel mysql, apache poi writing excel mysql java servlet, read exceljava, spring excel read, excel mysql whith java

Acerca do Empregador:
( 14 comentários ) Garden Grove, United States

ID do Projeto: #174796

Premiar a:

gigasource

Please see PM.

$150 USD em 2 dias
(1 Comentário)
2.4

20 freelancers are bidding on average $196 for this job

Team21

Details by PMB

$300 USD in 2 dias
(13 Comentários)
5.6
devunion

Dear Kevin Cao, we are team of Java developers with 4+ years of experience. We are similar with Excel files processing on Java and we can done this work with really high quality. We have reviewed attached XLS file a Mais

$139 USD in 2 dias
(18 Comentários)
5.5
jDeveloperUa

Hi. I'm expirienced and certified java programmer from Ukraine. My primary development direction is to build java swing applications. Have a good knowledge and practice of OOP and programming patterns. Have a mu Mais

$150 USD in 2 dias
(11 Comentários)
5.0
sah2ed

Hi, please check my private message.

$300 USD in 4 dias
(22 Comentários)
4.9
mradityagoyal

can deliver the product before monday morning your time. check PM

$100 USD in 3 dias
(21 Comentários)
4.3
expertMan

please see pmb.

$300 USD in 15 dias
(7 Comentários)
3.8
mkader

it could be done. i done same kind of project previously. please see pmb

$275 USD in 7 dias
(1 Comentário)
3.4
tomly

Hi,we work under J2EE and MySQL,we can do it.

$120 USD in 4 dias
(0 Comentários)
0.0
techspy

I am a SCJP5/SCBCD5 Programmer working in java and j2ee and j2me technologies. I can do this project. Please check my PMB regarding technologies which i can use to solve your problem.

$200 USD in 5 dias
(0 Comentários)
0.0
myselfmohsin

I can do this with quality code. U can maintain the code for further changes

$200 USD in 5 dias
(0 Comentários)
0.0
ionix

Please check PM. Thanks!

$300 USD in 9 dias
(0 Comentários)
0.0
bhaveshpanseria

we are having a team of 4 people having sound experience of 4 years in java programming. we have delivered many projects successfully. Is there any particular version of MS-Excel or should work with all version of MS- Mais

$200 USD in 4 dias
(0 Comentários)
0.0
maxmon

Hi,Sir I can use the Apache POI library to complete your [url removed, login to view] forward to hearing from you.

$100 USD in 2 dias
(0 Comentários)
0.0
sravantig

Hi, I'm a Professional in J2ee. I would be using Apache POI for reading the Excel. For achieving optimum performance would be using Hibernate as ORM.

$100 USD em 1 dia
(0 Comentários)
0.0
manjularajesh

Your requirement as explained, seems not that complicated. We have experience handling similar library / utility functions before.

$100 USD in 7 dias
(0 Comentários)
0.0
BitSimple

Please read private message for detailed information of our bid.

$280 USD in 5 dias
(0 Comentários)
0.0
rikhan

Hi, I possess 5 years of experience in java/j2ee (specially on jdbc, servlet, jsp, spring, struts, hibernate, ibatis),SQL, VBA, .net and .net related technologies. If I can provide you with any further information Mais

$250 USD in 5 dias
(0 Comentários)
0.0
pankajsingh199

please check pmb

$100 USD in 10 dias
(0 Comentários)
0.0
tjumlani

I can do this as I am familiar with this kind of project.

$250 USD em 1 dia
(0 Comentários)
0.0
wildfly

I'm professional so I guarantee result.

$150 USD em 1 dia
(0 Comentários)
0.0