private   void  jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                        try 
    {
       Class .forName("com.mysql.jdbc.Driver").newInstance();
    }
     catch  (Exception e)
    {
      e.printStackTrace();
    }	
     try 
    {
      Connection c = DriverManager.getConnection("jdbc:mysql://localhost/JavaTestDB?user=Vladimir&password=010875");
      Statement stmt =c.createStatement();
      ResultSet rs = stmt.executeQuery("SET NAMES cp1251");
      rs = stmt.executeQuery("SELECT* FROM JavaTest");
      ResultSetMetaData rsmd = rs.getMetaData();
      rs.next();
       this .jTextField1.setText(rs.getString( 2 ));      
      stmt.close();	
      c.close();
    }
     catch  (SQLException e)
    {
      e.printStackTrace();
    }	
    }                                        

 private   void  jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                    try 
    {
       Class .forName("com.mysql.jdbc.Driver").newInstance();
    }
     catch  (Exception e)
    {
      e.printStackTrace();
    }	
     try 
    {
      Connection c = DriverManager.getConnection("jdbc:mysql://host1/JavaTestDB?user=Vladimir&password=010875");
      Statement stmt =c.createStatement();
      ResultSet rs = stmt.executeQuery("SET NAMES cp1251");
      String queryInsert =  new  String("INSERT INTO JavaTest(id, status) values(?, ?)");
      PreparedStatement ps = c.prepareStatement(queryInsert);      
       for ( int  Index =  4 ; Index <  11 ; Index++)
	{
	  ps.setInt( 1 ,Index);
	  ps.setString( 2 ,  this .jTextField1.getText() + " " + Index);	
	  System.out.println( this .jTextField1.getText() + " " + Index);
	   int  rowsAffected = ps.executeUpdate();
        }
      stmt.close();	
      c.close();      
    }
     catch  (SQLException e)
    {
      e.printStackTrace();
    }	
    }