|
Только не долбите сильно, это моя первая прога не только на ява а вообще...критику буду учитывать!
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);}
}
}
|
