бляблябля

 import  java.sql.Connection;
 import  java.sql.DriverManager;
 import  java.sql.Statement;
 import  java.sql.*;
//import javax.swing.*;
/*
* Created on 28.07.2005
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/

/**
* @author struts_e
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
 import  java.text.DecimalFormat;
 import  java.io.IOException;
 import  javax.servlet.ServletException;
 import  javax.servlet.http.HttpServlet;
 import  javax.servlet.http.HttpServletRequest;
 import  javax.servlet.http.HttpServletResponse;
 public   class  parse_to_database  extends  HttpServlet {
	
	String ESTMC, NPVD, NAME_TMC, ED_IZM,
	ALT_ED_IZM, TYPE_TOV, SORT_RAZMER,
	GOST_TU, NUM_DRAFT_OBOZ_GOST_TU,
	PROIZ_MOSH_GRUS, OSSOBENNOST_IZGOT,
	REK_ZAVOD, PACKING, IZGOTOVITEL, 
	TNVED, /*NN_AKTYU_ZF, /*NN_AKSU_ZF,*/ NN_DGOK,
	NN_SSGPO, NN_EEK, NN_SHK, DESCRIPTION, OBL_ISPOL, GROUP;
	 int  npvd, num, group_int ;
	 long  NN_AKSU_ZF, NN_AKTYU_ZF;
	String NN_AKSU_STR, NN_AKTYU_STR;//для преобразования long в String.
	 protected   void  doPost(HttpServletRequest request, HttpServletResponse response)  throws  ServletException, IOException {
		DecimalFormat fiveDigits =  new  DecimalFormat("00000");
		 try {
			 Class .forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con_db2 = DriverManager.getConnection("jdbc:odbc:estmc","db2admin","snortman");
			Statement st_db2 = con_db2.createStatement();
			//st_db2.executeUpdate("Create TABLE ESTMC(KOD_NPVD Varchar(10), NAME_TMC Varchar(100),ED_IZM Varchar(100), ALT_ED_IZM Varchar(20), TYPE_TOV Varchar(100), SORT_RAZMER Varchar(100), GOST_TU Varchar(100), NUM_DRAFT_OBOZ_GOST_TU Varchar(100), PROIZ_MOSH_GRUS Varchar(100), OSSOBENNOST_IZGOT Varchar(100), REK_ZAVOD Varchar(100), PACKING Varchar(100), IZGOTOVITEL Varchar(100), TNVED Varchar(100), NN_AKTYU_ZF character(100),  NN_AKSU_ZF character(100), NN_DGOK Varchar(100), NN_SSGPO Varchar(16),  NN_EEK Varchar(16), NN_SHK Varchar(16), DESCRIPTION Varchar(100), OBL_ISPOL Varchar(100))");
			
			Connection con = DriverManager.getConnection("jdbc:odbc:csv");
			Statement s = con.createStatement();
			ResultSet rs = s.executeQuery("select * from книга.csv");
			 int  count =  2 ;//номер неверной строки!
			 int  counter =  0 ;//количество выбранных строк!
			 int  kod =  00001 ;
			stop:
			 while  (rs.next()){
				//while (counter < 100){
					counter++;
					//rs.next();
					 try {
						NPVD = rs.getString( 1 );
						//ESTMC = fiveDigits.format(kod) + NPVD;
					}
					 catch  (java.lang.NullPointerException e) {
						NPVD = "";
					}
					/*try{
					NPVD = rs.getString(1);
					}
					catch (java.lang.NullPointerException e) {
						NPVD = "";
					}*/
					 try {
						NAME_TMC =  new  String( rs.getString( 2 ));
					}
					 catch  (java.lang.NullPointerException e) {
						NAME_TMC ="";
					}
					 try {
						ED_IZM =  new  String( rs.getString( 3 ));
					}
					 catch  (java.lang.NullPointerException e) {
						ED_IZM ="";						
					}
					 try {
						ALT_ED_IZM =  new  String( rs.getString( 4 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						ALT_ED_IZM = "";
					}
					 try {
						TYPE_TOV =  new  String( rs.getString( 5 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						TYPE_TOV = "";						
					}
					 try {
						SORT_RAZMER =  new  String( rs.getString( 6 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						SORT_RAZMER = "";						
					}
					 try {
						GOST_TU =  new  String( rs.getString( 7 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						GOST_TU ="";						
					}
					 try {
						NUM_DRAFT_OBOZ_GOST_TU =  new  String( rs.getString( 8 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						NUM_DRAFT_OBOZ_GOST_TU = "";						
					}
					 try {
						PROIZ_MOSH_GRUS =  new  String( rs.getString( 9 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						PROIZ_MOSH_GRUS ="";						
					}
					 try {
						OSSOBENNOST_IZGOT =  new  String( rs.getString( 10 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						OSSOBENNOST_IZGOT ="";						
					}
					 try {
						REK_ZAVOD =  new  String( rs.getString( 11 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						REK_ZAVOD = "";						
					}
					 try {
						PACKING =  new  String( rs.getString( 12 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						PACKING ="";						
					}
					 try {
						IZGOTOVITEL =  new  String( rs.getString( 13 ));
					}
					 catch  (java.lang.NullPointerException e) {
						IZGOTOVITEL ="";						
					}
					 try {
						TNVED =  new  String( rs.getString( 14 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						TNVED ="";						
					}
					 try {
						NN_AKTYU_ZF =  rs.getLong( 15 );
						 if  (NN_AKTYU_ZF ==  0 ){
							NN_AKTYU_STR =  Long .toString(NN_AKSU_ZF);
							NN_AKTYU_STR = "";
						}
					}
					 catch  (java.lang.NullPointerException e) {
						System.out.println("Строка номер " + count + " неверная");
					}
					 try {
						NN_AKSU_ZF = rs.getLong( 16 );
						 if  (NN_AKSU_ZF ==  0 ){
							NN_AKSU_STR =  Long .toString(NN_AKSU_ZF);
							NN_AKSU_STR = "";
						}
						
					}
					 catch  (java.lang.NullPointerException e) {
					}
					 try {
						NN_DGOK =  new  String( rs.getString( 17 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						NN_DGOK = "";
					}
					 try {
						NN_SSGPO =  new  String( rs.getString( 18 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						NN_SSGPO = "";
					}
					 try {
						NN_EEK =  new  String( rs.getString( 19 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						NN_EEK = "";
					}
					 try {
						NN_SHK =  new  String( rs.getString( 20 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						NN_SHK = "";						
					}
					 try {
						DESCRIPTION =  new  String( rs.getString( 21 ));
					}
					 catch  (java.lang.NullPointerException e) {						
						DESCRIPTION = "";
					}
					 try {
						OBL_ISPOL =  new  String( rs.getString( 22 ));
					}
					 catch  (java.lang.NullPointerException e) {
						OBL_ISPOL = "";						
					}
						count ++;
						//num++;
						
					//счетчик
						
											
						//форсирование данных для полей NUM - количество групп
						//и GROUP - группы						
						 try {GROUP = NPVD.substring( 0 , 2 );
						group_int = Integer.parseInt(GROUP);}
						 catch (NullPointerException nullpointer){System.out.println(nullpointer); GROUP = "";}
						//if (GROUP == null) GROUP = "";
						//ResultSet rs_db2 = st_db2.executeQuery("Select GROUP, num from ESTMC WHERE num=(SELECT MAX(num) from ESTMC) and GROUP = '"+GROUP+"'");
						ResultSet rs_db2 = st_db2.executeQuery("Select GROUP, num from ESTMC WHERE num=(SELECT MAX(num) from ESTMC WHERE GROUP = "+group_int+")");
						 try  {
							rs_db2.next();
							//String num_str = Integer.toString(num);
							 String num_str = rs_db2.getString( 2 );
							 num = Integer.parseInt(num_str);
							System.out.println(num);
							num = num +  1 ;
						} catch (Exception e){num =  1 ;System.out.println(num + " error " + e);}
						//формирование кода ESTMC
						//String num_str = Integer.toString(num);
						ESTMC = fiveDigits.format(num) + NPVD;
						 if  (NN_AKTYU_ZF ==  0  & NN_AKSU_ZF ==  0  ){
							st_db2.executeUpdate("INSERT INTO ESTMC VALUES('"+ESTMC+"', '"+NPVD+"', '"+NAME_TMC+"', '"+ED_IZM+"', '"+ALT_ED_IZM+"', '"+TYPE_TOV+"', '"+SORT_RAZMER+"','"+GOST_TU+"', '"+NUM_DRAFT_OBOZ_GOST_TU+"', '"+PROIZ_MOSH_GRUS+"', '"+OSSOBENNOST_IZGOT+"','"+REK_ZAVOD+"','"+PACKING+"', '"+IZGOTOVITEL+"','"+TNVED+"', '"+NN_AKTYU_STR+"', '"+NN_AKSU_STR+"', '"+NN_DGOK+"', '"+NN_SSGPO+"', '"+NN_EEK+"', '"+NN_SHK+"','"+DESCRIPTION+"','"+OBL_ISPOL+"',"+group_int+","+num+")");
						} else 
							 if  (NN_AKTYU_ZF ==  0 ){
								st_db2.executeUpdate("INSERT INTO ESTMC VALUES('"+ESTMC+"', '"+NPVD+"', '"+NAME_TMC+"', '"+ED_IZM+"', '"+ALT_ED_IZM+"', '"+TYPE_TOV+"', '"+SORT_RAZMER+"','"+GOST_TU+"', '"+NUM_DRAFT_OBOZ_GOST_TU+"', '"+PROIZ_MOSH_GRUS+"', '"+OSSOBENNOST_IZGOT+"','"+REK_ZAVOD+"','"+PACKING+"', '"+IZGOTOVITEL+"','"+TNVED+"', '"+NN_AKTYU_STR+"', '"+NN_AKSU_ZF+"', '"+NN_DGOK+"', '"+NN_SSGPO+"', '"+NN_EEK+"', '"+NN_SHK+"','"+DESCRIPTION+"','"+OBL_ISPOL+"',"+group_int+", "+num+")");
							} else 
								 if  (NN_AKSU_ZF ==  0 )
									st_db2.executeUpdate("INSERT INTO ESTMC VALUES('"+ESTMC+"', '"+NPVD+"', '"+NAME_TMC+"', '"+ED_IZM+"', '"+ALT_ED_IZM+"', '"+TYPE_TOV+"', '"+SORT_RAZMER+"','"+GOST_TU+"', '"+NUM_DRAFT_OBOZ_GOST_TU+"', '"+PROIZ_MOSH_GRUS+"', '"+OSSOBENNOST_IZGOT+"','"+REK_ZAVOD+"','"+PACKING+"', '"+IZGOTOVITEL+"','"+TNVED+"', '"+NN_AKTYU_ZF+"', '"+NN_AKSU_STR+"', '"+NN_DGOK+"', '"+NN_SSGPO+"', '"+NN_EEK+"', '"+NN_SHK+"','"+DESCRIPTION+"','"+OBL_ISPOL+"',"+group_int+","+num+")");
								 else 
									st_db2.executeUpdate("INSERT INTO ESTMC VALUES('"+ESTMC+"', '"+NPVD+"', '"+NAME_TMC+"', '"+ED_IZM+"', '"+ALT_ED_IZM+"', '"+TYPE_TOV+"', '"+SORT_RAZMER+"','"+GOST_TU+"', '"+NUM_DRAFT_OBOZ_GOST_TU+"', '"+PROIZ_MOSH_GRUS+"', '"+OSSOBENNOST_IZGOT+"','"+REK_ZAVOD+"','"+PACKING+"', '"+IZGOTOVITEL+"','"+TNVED+"', '"+NN_AKTYU_ZF+"', '"+NN_AKSU_ZF+"', '"+NN_DGOK+"', '"+NN_SSGPO+"', '"+NN_EEK+"', '"+NN_SHK+"','"+DESCRIPTION+"','"+OBL_ISPOL+"',"+group_int+","+num+")");
						kod ++;
			}//while 
			
		
		}
		 catch (Exception e){System.out.print("Ошибка " + e);}
	}	
}