Новичок
Профиль
Группа: Участник
Сообщений: 29
Регистрация: 29.5.2008
Репутация: нет
Всего: нет
|
добрый всем денъ , в процессе обработки данных в БД столкнулся с такой проблемой в пустую строку прописывает значение предыдущей , и отсутствие номера дома создает такую *е проблему, вот что получается ku_id | NUMMER | STRASSE | PLZ | ORT | STR_NAME | HAUSNR | N_STRNAME | N_PLZ | N_ORT | 116 116 Priemern Nr. 2 39606 Bretsch Priemern Nr. 2 Priemern 2 39606 Bretsch 117 117 нет улицы 39606 Schmersau Priemern Nr. 2 Priemern 2 39606 Schmersau 123 123 Hauptstraße 23 39606 Walsleben Hauptstraße 23 Hauptstr. 23 39606 Walsleben 124 124 нет улицы 39606 Osterburg Hauptstraße 23 Hauptstr. 23 39606 Osterburg 168 168 Dorfstrasse 40 39606 Gladigau Dorfstrasse 40 Dorfstr. 40 39606 Gladigau 169 169 Bretsch нет nr. 39606 Osterburg Dorfstrasse 40 Dorfstr. 40 39606 Osterburg 226 226 Dorfstr.31 39606 Königsmark Dorfstr. 31 Dorfstr. 31 39606 Königsmark 227 227 нет ул. нет инд. нет села Dorfstr. 31 Dorfstr. 31 null null
| Код |
package proekt;
import com.cloudgarden.layout.AnchorConstraint;
import com.cloudgarden.layout.AnchorLayout;
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import javax.imageio.ImageIO;
import java.sql.DriverManager;
import javax.swing.BorderFactory;
import javax.swing.ComboBoxModel;
import javax.swing.DebugGraphics;
import javax.swing.DefaultComboBoxModel;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JPanel;
import javax.swing.JProgressBar;
import javax.swing.JSeparator;
import javax.swing.JSpinner;
import javax.swing.JTextField;
import javax.swing.JToggleButton;
import javax.swing.SpinnerListModel;
import javax.swing.SwingUtilities;
import javax.swing.border.BevelBorder;
import javax.swing.border.LineBorder;
import javax.swing.border.SoftBevelBorder;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.sql.*;
import java.io.File;
import java.io.IOException;
import java.io.FileWriter;
import java.io.BufferedWriter;
import java.io.PrintWriter;
import java.util.*;
import java.util.List;
import java.awt.*;
import java.awt.print.*;
import java.io.* ;
import java.awt.Image;
import java.awt.Toolkit;
public class Adresse extends JFrame {
private boolean taskStarted = false;
private Thread thread = null;
private static final long serialVersionUID = 1L;
private JButton jButton1;
private JTextField jTextField12;
private JButton Ab;
private JSeparator jSeparator1;
private javax.swing.Timer activityMonitor;
private String Text1;
private JLabel jLabel1;
private JLabel jLabel6;
private JLabel jLabel12;
private JProgressBar jProgressBar1;
public String inhaltSTRASSE;
String url = "jdbc:mysql://localhost/adresse";
String user = "root";
String pass = "ddd";
String newStrasse=null;
String newNummer=null;
String newPLZORT=null;
String inhaltStrasse;
String inhaltortplz;
String inhaltPLZ;
String inhaltORT;
String inhaltOrtnrStr;
String inhaltPlz;
String prepStatement;
Connection conn = null;
ArrayList inhaltOrtnr;
ResultSet r,r1,rort,rc;
Statement s;
Statement se;
int Count;
JProgressBar pbar;
int mxCount;
/**
* This is the default constructor
*/
public Adresse() {
super();
initialize();
}
private void initialize() {
this.setSize(550, 200);
this.setLocationRelativeTo(null);
AnchorLayout thisLayout = new AnchorLayout();
getContentPane().setLayout(thisLayout);
this.setTitle("Adresse.Bearbeiten");
getContentPane().setBackground(new java.awt.Color(229,229,229));
this.setName("Adresse\n");
getContentPane().add(getJLabel1(), new AnchorConstraint(51, 769, 195, 36, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
getContentPane().add(getJLabel6(), new AnchorConstraint(85, 249, 152, 142, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
getContentPane().add(getJProgressBar1(), new AnchorConstraint(256, 943, 382, 39, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
getContentPane().add(getJLabel12(), new AnchorConstraint(466, 246, 593, 39, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
getContentPane().add(getJTextField12(), new AnchorConstraint(466, 388, 593, 246, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
getContentPane().add(getAb(), new AnchorConstraint(762, 943, 888, 788, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
getContentPane().add(getJSeparator1(), new AnchorConstraint(677, 943, 719, 26, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
getContentPane().add(getJButton1(), new AnchorConstraint(762, 775, 888, 595, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
}
private JLabel getJLabel12() {
if (jLabel12 == null) {
jLabel12 = new JLabel();
jLabel12.setText("Verarbeitet :");
jLabel12.setPreferredSize(new java.awt.Dimension(112, 21));
jLabel12.setFont(new java.awt.Font("Tahoma",1,11));
jLabel12.setBorder(new SoftBevelBorder(BevelBorder.LOWERED, null, null, null, null));
jLabel12.setBackground(new java.awt.Color(206,206,206));
}
return jLabel12;
}
private JLabel getJLabel6() {
if (jLabel6 == null) {
jLabel6 = new JLabel();
jLabel6.setText("");
jLabel6.setPreferredSize(new java.awt.Dimension(63, 28));
}
return jLabel6;
}
private JSeparator getJSeparator1() {
if (jSeparator1 == null) {
jSeparator1 = new JSeparator();
jSeparator1.setPreferredSize(new java.awt.Dimension(497, 7));
}
return jSeparator1;
}
private JButton getJButton1() {
if (jButton1 == null) {
jButton1 = new JButton();
jButton1.setText("Start");
jButton1.setPreferredSize(new java.awt.Dimension(98, 21));
jButton1.setBackground(new java.awt.Color(213,228,253));
jButton1.setFont(new java.awt.Font("Tahoma",1,11));
jButton1.setBorder(BorderFactory.createBevelBorder(BevelBorder.LOWERED));
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
baseCon();
}
});
}
return jButton1;
}
public void baseCon() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url, user, pass);
System.out.println("Verbunden+++");
s= conn.createStatement();//Statment für die Verbindung (s= instsntz für verbindung)
ResultSet rcaunt = s.executeQuery("SELECT COUNT(*) FROM kunde_dat ");
rcaunt.next();
int inhaltcaunt=rcaunt.getInt(1);
System.err.println("zahl++!"+inhaltcaunt);
begin(inhaltcaunt);
}
catch (Exception e) {
System.err.println("Kann nicht verbinden!");
}
}
public void begin(int inhaltcaunt)
{
for(int i=0;i<inhaltcaunt;i++)
{
try
{
r = s.executeQuery("SELECT ORT,STRASSE,PLZ FROM kunde_dat WHERE ku_id='"+i+"'");
while(r.next())
{
inhaltORT=r.getString("ORT");
inhaltStrasse=r.getString("STRASSE");
inhaltPLZ=r.getString("PLZ");
trennen(inhaltStrasse);
}
r1 = s.executeQuery("SELECT STR_NAME, N_STRNAME FROM strasse WHERE STR_NAME='"+newStrasse+"'");
String nn;
String str_name=null;
String n_strname=null;
nn=newStrasse;
while(r1.next())
{
str_name=r1.getString("STR_NAME");
n_strname=r1.getString("N_STRNAME");
}
rort = s.executeQuery("SELECT PLZ_ORT, N_PLZ_ORT FROM plz_ort WHERE PLZ_ORT='"+inhaltPLZ+inhaltORT+"'");
String n_plz_ort=null;
String newPLZ=null;
String newOrt=null;
while(rort.next())
{
n_plz_ort=rort.getString("N_PLZ_ORT");
int zPLZ=n_plz_ort.length();
newPLZ= n_plz_ort.substring(0, 5); //trennen PLZ von ORT
newOrt=n_plz_ort.substring(5, zPLZ);
}
System.out.println("newPLZ+ORT"+" "+n_plz_ort+"new ort "+newOrt+"newPLZ "+newPLZ);
String mSQL; //(1)
mSQL = "UPDATE kunde_dat SET STR_NAME='"+newStrasse+"' ,HAUSNR='"+newNummer+"' ,N_STRNAME='"+n_strname+" "+" "+newNummer+"', N_PLZ='"+newPLZ+"',N_ORT='"+newOrt+"' " +
"WHERE ku_id like '" +i+ "' ";
s.executeUpdate(mSQL);
String count=new Integer(inhaltcaunt).toString();
jTextField12.setText(count);
}
catch (Exception e) {
System.err.println("Kann nicht verbinden!");
}
}
}
public void trennen(String inhaltStrasse){
for(int i=0;i<inhaltStrasse.length();i++)
{
char cl=inhaltStrasse.charAt(i);
if( cl=='1' || cl=='2' || cl=='3'||cl=='4'||cl=='5' || cl=='6' || cl=='7' || cl=='8'||cl=='9'||cl=='0')
{
int zahl=Math.min(i,i++);
newStrasse=inhaltStrasse.substring(0, zahl);
newNummer=inhaltStrasse.substring(zahl);
break;
}
}
}
private JButton getAb() {
if (Ab == null) {
Ab = new JButton();
Ab.setText("Exit");
Ab.setPreferredSize(new java.awt.Dimension(84, 21));
Ab.setFont(new java.awt.Font("Tahoma",1,11));
Ab.setBackground(new java.awt.Color(213,228,253));
Ab.setBorder(BorderFactory.createBevelBorder(BevelBorder.LOWERED));
Ab.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
dispose();
}
});
}
return Ab;
}
private JTextField getJTextField12() {
if (jTextField12 == null) {
jTextField12 = new JTextField();
jTextField12.setPreferredSize(new java.awt.Dimension(77, 21));
jTextField12.setBorder(new SoftBevelBorder(BevelBorder.LOWERED, null, null, null, null));
jTextField12.setBackground(new java.awt.Color(229,229,229));
jTextField12.setText("0");
}
return jTextField12;
}
public void zalArra(ArrayList inhaltOrtnr) {
int size=inhaltOrtnr.size();
String sizeText=new Integer(size).toString();
System.out.println("vifiel zeile "+inhaltOrtnr.size());
}
public void baseConCount()
{
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url, user, pass);
System.out.println("Verbunden");
s= conn.createStatement();//Statment für die Verbindung (s= instsntz für verbindung)
rc = s.executeQuery("SELECT NUMMER From kunde_dat");
int Count=0;
while(rc.next())
{
Count=rc.getInt("NUMMER");
}
mxCount=Math.max(Count,Count++);
System.out.println("Count"+Count);
}
catch (Exception e) {
System.err.println("Kann nicht verbinden!");
}
}
public void listInDatei (List list, File datei) {
try {
PrintWriter printWriter = new PrintWriter(new FileWriter(datei));
Iterator iter = list.iterator();
while(iter.hasNext() ) {
Object o = iter.next();
printWriter.println(o);
}
printWriter.close();
}
catch (IOException e) {
e.printStackTrace();
}
}
public String fehlerOrt(String kOrt[])
{for(int j=0;j<kOrt.length;j++)
System.out.println("ARRAY"+kOrt[j]);
String fehl=null;
return fehl;
}
private JLabel getJLabel1() {
if (jLabel1 == null) {
jLabel1 = new JLabel();
jLabel1.setText("Datei wird verarbeitet und in Datenbank gespeichert .");
jLabel1.setPreferredSize(new java.awt.Dimension(287, 21));
jLabel1.setFont(new java.awt.Font("Tahoma",1,11));
}
return jLabel1;
}
}
|
в чем ощибка |
обработка данных в БД 
Загрузка ...
