import java.util.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.JApplet.*;
public class RoslunuJApplet extends JApplet implements ActionListener
{
        Image myImage1;
        String str1,str2,str3,str4,str5,str6,str7;
        boolean flag1=false,flag2=false,flag3=false,flag4=false,flag5=false,flag6=false,flag7=false;
    public void init()
   {
        try
     {
        java.awt.EventQueue.invokeAndWait(new Runnable()
    {
    public void run()
       {
        setSize(1110,650);//той самий розмір задається при побудові форми
        setVisible(true);
        initComponents();
       }
    });
     }
        catch (Exception ex)
      {
        ex.printStackTrace();
      }
   }
  class MyEventMouseAdapter extends MouseAdapter
 {
    public void mouseClicked(MouseEvent e)
      {
        if (e.getSource()==jTable1)
        {
        int indr1=jTable1.getSelectedRow();
//      System.out.println("indr1="+indr1);
        pk1.pathimage data=new pk1.pathimage();
        myImage1=getImage(getDocumentBase(),data.z1[indr1]);
        int indc1=jTable1.getSelectedColumn();
        Object obj1=mymodel.getValueAt(indr1,indc1);
        String s1=obj1.toString();
        repaint();
        }
        }
 }

    public void paint(Graphics g)
      {
        g.drawImage(myImage1,850,40,400,400,this);
      }

    public void actionPerformed(ActionEvent e)
     {
     }
    private void initComponents()
   {
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        setBackground(new java.awt.Color(240, 240, 240));
        jTable1.setBackground(new java.awt.Color(255, 255, 0));
        jTable1.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
        mymodel=new javax.swing.table.DefaultTableModel();
        mymodel.addColumn("Номер");
        mymodel.addColumn("Назва");
        mymodel.addColumn("Латинська назва");
        mymodel.addColumn("Кількість");
        mymodel.addColumn("Опис");
        jTable1.setModel(mymodel);
        jScrollPane1.setViewportView(jTable1);
        try
     {
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        String url="jdbc:mysql://localhost:3306/lik_roslunu";
        Connection conn1=DriverManager.getConnection(url,"root","q3dm17");
        Statement st1=conn1.createStatement();
        ResultSet rs1=st1.executeQuery("SELECT * FROM table1");
        ResultSetMetaData md1=rs1.getMetaData();
        int colums1=md1.getColumnCount();
        int j=0;
        while(rs1.next())
       {
        Vector data=new Vector();
        data.add(Integer.toString(rs1.getInt(1)));
        for(int i=2;i<=colums1;i++)
       {
        data.add(rs1.getString(i));
       }
        mymodel.addRow(data);
        j=j+1;
       }
        st1.close();
        conn1.close();
     }
        catch(SQLException e)
      {
        System.out.println(e);
      }
           javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGap(10, 10, 10)
                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 753, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(90, 90, 90)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                                                        ))
                            ))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(147, 147, 147)
                        ))
                .addContainerGap(44, javax.swing.GroupLayout.PREFERRED_SIZE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(6, 6, 6)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGap(165, 165, 165)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGap(11, 11, 11)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGap(11, 11, 11)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGap(18, 18, 18)
                        .addGap(5, 5, 5)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGap(1, 1, 1)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGap(14, 14, 14)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGap(18, 18, 18)
                        )
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 585, Short.MAX_VALUE))
                .addGap(20, 20, 20))
        );
        
        jTable1.addMouseListener(new MyEventMouseAdapter());

   }

    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.table.DefaultTableModel mymodel;
}