mapreduce 存入mysql_mapreduce实现从hbase中统计数据，结果存入mysql中

1 public class FaultDay implementsWritable, DBWritable {2 privateString id;3

4 private String day; //2015-02-01

5 privateString company_id;6 privateString product_id;7 privateString model_id;8 privateString fault_id;9 privateString province_id;10 privateString city_id;11 privateString district_id;12 private intnum;13

14 @Override15 public void write(PreparedStatement statement) throwsSQLException {16 int index = 1;17 statement.setString(index++, this.getId());18 statement.setString(index++, this.getDay());19 statement.setString(index++, this.getCompany_id());20 statement.setString(index++, this.getProduct_id());21 statement.setString(index++, this.getModel_id());22 statement.setString(index++, this.getFault_id());23 statement.setString(index++, this.getProvince_id());24 statement.setString(index++, this.getCity_id());25 statement.setString(index++, this.getDistrict_id());26 statement.setInt(index++, this.getNum());27 }28

29 @Override30 public void readFields(ResultSet resultSet) throwsSQLException {31 this.id = resultSet.getString(1);32 this.day = resultSet.getString(2);33 this.company_id = resultSet.getString(3);34 this.product_id = resultSet.getString(4);35 this.model_id = resultSet.getString(5);36 this.fault_id = resultSet.getString(6);37 this.province_id = resultSet.getString(7);38 this.city_id = resultSet.getString(8);39 this.district_id = resultSet.getString(9);40 this.num = resultSet.getInt(10);41 }42

43 @Override44 public void write(DataOutput out) throwsIOException {45 //To change body of implemented methods use File | Settings | File Templates.

46 }47

48 @Override49 public void readFields(DataInput in) throwsIOException {50 //To change body of implemented methods use File | Settings | File Templates.

51 }52

53

54 publicString getCity_id() {55 returncity_id;56 }57

58 public voidsetCity_id(String city_id) {59 this.city_id =city_id;60 }61

62 publicString getCompany_id() {63 returncompany_id;64 }65

66 public voidsetCompany_id(String company_id) {67 this.company_id =company_id;68 }69

70 publicString getDay() {71 returnday;72 }73

74 public voidsetDay(String day) {75 this.day =day;76 }77

78 publicString getDistrict_id() {79 returndistrict_id;80 }81

82 public voidsetDistrict_id(String district_id) {83 this.district_id =district_id;84 }85

86 publicString getFault_id() {87 returnfault_id;88 }89

90 public voidsetFault_id(String fault_id) {91 this.fault_id =fault_id;92 }93

94 publicString getId() {95 returnid;96 }97

98 public voidsetId(String id) {99 this.id =id;100 }101

102 publicString getModel_id() {103 returnmodel_id;104 }105

106 public voidsetModel_id(String model_id) {107 this.model_id =model_id;108 }109

110 public intgetNum() {111 returnnum;112 }113

114 public void setNum(intnum) {115 this.num =num;116 }117

118 publicString getProduct_id() {119 returnproduct_id;120 }121

122 public voidsetProduct_id(String product_id) {123 this.product_id =product_id;124 }125

126 publicString getProvince_id() {127 returnprovince_id;128 }129

130 public voidsetProvince_id(String province_id) {131 this.province_id =province_id;132 }133 }