EK Mega Party - Season 04 !!

geethq

Well-known member
  • Sep 17, 2006
    49,949
    3,213
    113
    ~ඤාව්~
    package dvd;

    import javax.swing.*;
    import java.awt.*;
    import java.awt.event.*;
    import java.sql.*;
    /**
    *
    * @author Geet*** S******
    */
    public class Search implements ActionListener {

    JButton UpdateB = new JButton("Update");
    JButton BackB = new JButton("Exit");
    JButton SearchB = new JButton("Search");
    JButton SearchB1 = new JButton("Clear");
    JButton B1 = new JButton();
    JButton B2 = new JButton();
    JButton AddB = new JButton("Add New");

    static String Type;
    static String Title;
    static String DVDNo;
    static String DateCRTD;
    static String Content1;
    static String Content2;
    static String Content3;
    static String Content4;
    static String Content5;
    static String Content6;
    static String Content7;
    static String Content8;
    static String Content9;
    static String Content10;
    static String Notes1;
    static String Notes2;
    static String SearchTag;

    JTextField L4 = new JTextField();
    JTextField L5 = new JTextField();
    JTextField L6 = new JTextField();
    JTextField L7 = new JTextField();
    JTextField L30 = new JTextField();
    JTextField L31 = new JTextField();
    JTextField L32 = new JTextField();
    JTextField L33 = new JTextField();
    JTextField L34 = new JTextField();
    JTextField L35 = new JTextField();
    JTextField L36 = new JTextField();
    JTextField L37 = new JTextField();
    JTextField L38 = new JTextField();
    JTextField L8 = new JTextField();
    JTextField L40 = new JTextField();

    JTextField L22 = new JTextField();
    JTextField No21 = new JTextField("001");

    JFrame win1 = new JFrame("Search");
    public void GUI() {

    JLabel L1 = new JLabel("Search");
    JLabel L14 = new JLabel("Type");
    JLabel L15 = new JLabel("Title");
    JLabel L13 = new JLabel("Search by DVD No:");
    JLabel L12 = new JLabel("Search by Tag:");
    JLabel L16 = new JLabel("Date Created");
    JLabel L17 = new JLabel("Content");
    JLabel L18 = new JLabel("Notes");

    int width = 620;
    int height =600;
    Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
    int x = (screen.width-width)/2;
    int y = (screen.height-height)/2;
    win1.setBounds(x,y,width,height);
    win1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    win1.setResizable(false);
    win1.setVisible(true);

    Container c = win1.getContentPane();
    c.setLayout(null);

    Font font = new Font("", Font.BOLD, 22);
    L1.setFont(font);


    L1.setBounds(250, 20, 200, 20);
    L4.setBounds(270, 130, 200, 20);
    L5.setBounds(270, 160, 200, 20);
    L6.setBounds(270, 190, 200, 20);
    L7.setBounds(270, 220, 200, 20);
    L30.setBounds(270, 240, 200, 20);
    L31.setBounds(270, 260, 200, 20);
    L32.setBounds(270, 280, 200, 20);
    L33.setBounds(270, 300, 200, 20);
    L34.setBounds(270, 320, 200, 20);
    L35.setBounds(270, 340, 200, 20);
    L36.setBounds(270, 360, 200, 20);
    L37.setBounds(270, 380, 200, 20);
    L38.setBounds(270, 400, 200, 20);
    L8.setBounds(220, 430, 300, 20);
    L40.setBounds(220,452, 300, 20);
    L13.setBounds(120, 100, 175, 20);
    L12.setBounds(120, 70, 175, 20);
    L14.setBounds(120, 130, 175, 20);
    L15.setBounds(120, 160, 175, 20);
    L16.setBounds(120, 190, 175, 20);
    L17.setBounds(170, 300, 175, 20);
    L18.setBounds(170, 440, 175, 20);
    No21.setBounds(270, 100, 100, 20);
    L22.setBounds(270, 70, 117, 20);

    SearchB.setBounds(390, 100, 80, 20);
    SearchB1.setBounds(390,70, 80, 20);
    B1.setBounds(370, 100, 16, 10);
    B2.setBounds(370, 110, 16, 10);
    UpdateB.setBounds(150, 500, 100, 20);
    BackB.setBounds(390, 500, 100, 20);
    AddB.setBounds(270, 500, 100, 20);

    c.add(L12);
    c.add(L13);
    c.add(L14);
    c.add(L15);
    c.add(L16);
    c.add(L17);
    c.add(L18);
    c.add(UpdateB);
    c.add(BackB);
    c.add(SearchB);
    c.add(AddB);
    c.add(SearchB1);
    c.add(B1);
    c.add(B2);
    c.add(L1);
    c.add(L4);
    c.add(L5);
    c.add(L6);
    c.add(L7);
    c.add(L8);
    c.add(L30);
    c.add(L31);
    c.add(L32);
    c.add(L33);
    c.add(L34);
    c.add(L35);
    c.add(L36);
    c.add(L37);
    c.add(L38);
    c.add(L40);
    c.add(No21);
    c.add(L22);

    SearchB.addActionListener(this);
    SearchB1.addActionListener(this);
    B1.addActionListener(this);
    B2.addActionListener(this);
    UpdateB.addActionListener(this);
    BackB.addActionListener(this);
    AddB.addActionListener(this);

    }
     
    Last edited:

    geethq

    Well-known member
  • Sep 17, 2006
    49,949
    3,213
    113
    ~ඤාව්~
    if (e.getSource() == SearchB ) {

    String DVDtag=L22.getText();
    String DVDno=No21.getText();

    if(No21.getText().equals("") && L22.getText().equals("") ){
    JOptionPane.showMessageDialog(null,"You have not entered a DVD Number ","",JOptionPane.ERROR_MESSAGE);}
    else{

    if(No21.getText().equals("")) {
    try {
    String str="SELECT * FROM DVD WHERE SearchTag='"+DVDtag+"'";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery(str);
    if(rs.next()){

    Type= rs.getString(1);
    Title=rs.getString(2);
    DVDNo=rs.getString(3);
    DateCRTD= rs.getString(4);
    Content1=rs.getString(5);
    Content2= rs.getString(6);
    Content3= rs.getString(7);
    Content4=rs.getString(8);
    Content5= rs.getString(9);
    Content6=rs.getString(10);
    Content7= rs.getString(11);
    Content8= rs.getString(12);
    Content9=rs.getString(13);
    Content10= rs.getString(14);
    Notes1=rs.getString(15);
    Notes2= rs.getString(16);
    SearchTag= rs.getString(17);


    L4.setText(Type);
    L5.setText(Title);
    L6.setText(DateCRTD);
    L7.setText(Content1);
    L30.setText(Content2);
    L31.setText(Content3);
    L32.setText(Content4);
    L33.setText(Content5);
    L34.setText(Content6);
    L35.setText(Content7);
    L36.setText(Content8);
    L37.setText(Content9);
    L38.setText(Content10);
    L8.setText(Notes1);
    L40.setText(Notes2);
    L22.setText(SearchTag);
    No21.setText(DVDNo);
    }

    else{
    JOptionPane.showMessageDialog(null,"Invalid Search tag , Please try again-(ex: Smallville or PrisonBreak} ","",JOptionPane.ERROR_MESSAGE);
    // L22.setText("");
    No21.setText("");
    L4.setText("");
    L5.setText("");
    L6.setText("");
    L7.setText("");
    L30.setText("");
    L31.setText("");
    L32.setText("");
    L33.setText("");
    L34.setText("");
    L35.setText("");
    L36.setText("");
    L37.setText("");
    L38.setText("");
    L8.setText("");
    L40.setText(""); }
    con.commit();
    stmt.close();
    con.close();

    } catch(Exception ex) {
    ex.printStackTrace();
    }
    }
    else{
    L22.setText("");

    if( L22.getText().equals("") )
    {

    try {
    String str="SELECT * FROM DVD WHERE DVDNo='"+DVDno+"'";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery(str);
    if(rs.next()){

    Type= rs.getString(1);
    Title=rs.getString(2);
    DVDNo=rs.getString(3);
    DateCRTD= rs.getString(4);
    Content1=rs.getString(5);
    Content2= rs.getString(6);
    Content3= rs.getString(7);
    Content4=rs.getString(8);
    Content5= rs.getString(9);
    Content6=rs.getString(10);
    Content7= rs.getString(11);
    Content8= rs.getString(12);
    Content9=rs.getString(13);
    Content10= rs.getString(14);
    Notes1=rs.getString(15);
    Notes2= rs.getString(16);
    SearchTag= rs.getString(17);


    L4.setText(Type);
    L5.setText(Title);
    L6.setText(DateCRTD);
    L7.setText(Content1);
    L30.setText(Content2);
    L31.setText(Content3);
    L32.setText(Content4);
    L33.setText(Content5);
    L34.setText(Content6);
    L35.setText(Content7);
    L36.setText(Content8);
    L37.setText(Content9);
    L38.setText(Content10);
    L8.setText(Notes1);
    L40.setText(Notes2);
    L22.setText(SearchTag);
    No21.setText(DVDNo);
    }

    else{
    JOptionPane.showMessageDialog(null,"Invalid Number , Please try again-(ex: 002 or 078 or 180} ","",JOptionPane.ERROR_MESSAGE);
    L22.setText("");
    No21.setText("");
    L4.setText("");
    L5.setText("");
    L6.setText("");
    L7.setText("");
    L30.setText("");
    L31.setText("");
    L32.setText("");
    L33.setText("");
    L34.setText("");
    L35.setText("");
    L36.setText("");
    L37.setText("");
    L38.setText("");
    L8.setText("");
    L40.setText(""); }
    con.commit();
    stmt.close();
    con.close();

    } catch(Exception ex) {
    ex.printStackTrace();
    }

    }

    else{
    JOptionPane.showMessageDialog(null,"Invalid Number or Search tag , Please try again-(ex: 002 or 078 or 180 ex: Smallville or PrisonBreak} ","",JOptionPane.ERROR_MESSAGE);
    L22.setText("");
    // No21.setText("");
    L4.setText("");
    L5.setText("");
    L6.setText("");
    L7.setText("");
    L30.setText("");
    L31.setText("");
    L32.setText("");
    L33.setText("");
    L34.setText("");
    L35.setText("");
    L36.setText("");
    L37.setText("");
    L38.setText("");
    L8.setText("");
    L40.setText("");
    }
    }

    }

    }


    if (e.getSource() == UpdateB) {

    String DVDno=No21.getText();

    if( L4.getText().equals("") &&
    L5.getText().equals("") && L6.getText().equals("") &&
    L7.getText().equals("") && L8.getText().equals(""))
    {JOptionPane.showMessageDialog(null,"Nothing Updated","",JOptionPane.ERROR_MESSAGE);
    }

    else {
    String T2=L4.getText();
    String T3=L5.getText();
    String T4=L6.getText();
    String T5=L7.getText();
    String T7=L30.getText();
    String T8=L31.getText();
    String T9=L32.getText();
    String T10=L33.getText();
    String T11=L34.getText();
    String T12=L35.getText();
    String T13=L36.getText();
    String T14=L37.getText();
    String T15=L38.getText();
    String T6=L8.getText();
    String T17=L40.getText();
    String T18=L22.getText();

    try {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    stmt.executeUpdate("UPDATE DVD SET Type='" + T2 + "',Title='" + T3 + "',DateCrtd='" + T4 + "',Content1='" + T5 + "',Content2='" + T7 + "',Content3='" + T8 + "',Content4='" + T9 + "',Content5='" + T10 + "',Content6='" + T11 + "',Content7='" + T12 + "',Content8='" + T13 + "',Content9='" + T14 + "',Content10='" + T15 + "',Notes1='" + T6 + "',Notes2='" + T17 + "',SearchTag='" + T18 + "'" +
    " WHERE DVDNo = '" + DVDno + "'");

    JOptionPane.showMessageDialog(null, "Successfully Updated");
    con.commit();
    stmt.close();
    con.close();

    L22.setText("");
    L4.setText("");
    L5.setText("");
    L6.setText("");
    L7.setText("");
    L30.setText("");
    L31.setText("");
    L32.setText("");
    L33.setText("");
    L34.setText("");
    L35.setText("");
    L36.setText("");
    L37.setText("");
    L38.setText("");
    L8.setText("");
    L40.setText("");

    }catch(Exception ex) {
    ex.printStackTrace();
    }
    }
    }
    if (e.getSource() == BackB) {
    System.exit(0);
    }
    }
    }
     

    geethq

    Well-known member
  • Sep 17, 2006
    49,949
    3,213
    113
    ~ඤාව්~
    public void actionPerformed(ActionEvent e) {
    //String DbaseCon = "Jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=DVDInfo.mdb";

    if (e.getSource() == AddB) {
    Add a1=new Add();
    a1.GUI();
    win1.dispose();
    win1.setVisible(false);
    }


    if (e.getSource() == SearchB1 ){
    No21.setText("");
    L4.setText("");
    L5.setText("");
    L6.setText("");
    L7.setText("");
    L30.setText("");
    L31.setText("");
    L32.setText("");
    L33.setText("");
    L34.setText("");
    L35.setText("");
    L36.setText("");
    L37.setText("");
    L38.setText("");
    L8.setText("");
    L40.setText("");
    }

    if (e.getSource() == B1) {
    String DVDno=No21.getText();

    int x = Integer.parseInt(DVDno);
    x++;
    System.out.println(x);
    if (x<=10 && x>0) {
    String DVDno1 = Integer.toString(x);
    String DVDno2 = "00"+DVDno1;
    No21.setText(DVDno2);
    try {
    String str="SELECT * FROM DVD WHERE DVDNo='"+DVDno2+"'";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery(str);
    if(rs.next()){

    Type= rs.getString(1);
    Title=rs.getString(2);
    DVDNo=rs.getString(3);
    DateCRTD= rs.getString(4);
    Content1=rs.getString(5);
    Content2= rs.getString(6);
    Content3= rs.getString(7);
    Content4=rs.getString(8);
    Content5= rs.getString(9);
    Content6=rs.getString(10);
    Content7= rs.getString(11);
    Content8= rs.getString(12);
    Content9=rs.getString(13);
    Content10= rs.getString(14);
    Notes1=rs.getString(15);
    Notes2= rs.getString(16);
    SearchTag= rs.getString(17);


    L4.setText(Type);
    L5.setText(Title);
    L6.setText(DateCRTD);
    L7.setText(Content1);
    L30.setText(Content2);
    L31.setText(Content3);
    L32.setText(Content4);
    L33.setText(Content5);
    L34.setText(Content6);
    L35.setText(Content7);
    L36.setText(Content8);
    L37.setText(Content9);
    L38.setText(Content10);
    L8.setText(Notes1);
    L40.setText(Notes2);
    L22.setText(SearchTag);
    No21.setText(DVDNo);
    }
    con.commit();
    stmt.close();
    con.close();

    } catch(Exception ex) {
    ex.printStackTrace();
    }
    }
    if (x<=100 && x>=10) {
    String DVDno1 = Integer.toString(x);
    String DVDno3 = "0"+DVDno1;
    No21.setText(DVDno3);
    try {
    String str="SELECT * FROM DVD WHERE DVDNo='"+DVDno3+"'";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery(str);
    if(rs.next()){

    Type= rs.getString(1);
    Title=rs.getString(2);
    DVDNo=rs.getString(3);
    DateCRTD= rs.getString(4);
    Content1=rs.getString(5);
    Content2= rs.getString(6);
    Content3= rs.getString(7);
    Content4=rs.getString(8);
    Content5= rs.getString(9);
    Content6=rs.getString(10);
    Content7= rs.getString(11);
    Content8= rs.getString(12);
    Content9=rs.getString(13);
    Content10= rs.getString(14);
    Notes1=rs.getString(15);
    Notes2= rs.getString(16);
    SearchTag= rs.getString(17);


    L4.setText(Type);
    L5.setText(Title);
    L6.setText(DateCRTD);
    L7.setText(Content1);
    L30.setText(Content2);
    L31.setText(Content3);
    L32.setText(Content4);
    L33.setText(Content5);
    L34.setText(Content6);
    L35.setText(Content7);
    L36.setText(Content8);
    L37.setText(Content9);
    L38.setText(Content10);
    L8.setText(Notes1);
    L40.setText(Notes2);
    L22.setText(SearchTag);
    No21.setText(DVDNo);
    }
    con.commit();
    stmt.close();
    con.close();

    } catch(Exception ex) {
    ex.printStackTrace();
    }
    }
    if (x>=100) {
    String DVDno1 = Integer.toString(x);
    No21.setText(DVDno1);
    try {
    String str="SELECT * FROM DVD WHERE DVDNo='"+DVDno1+"'";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery(str);
    if(rs.next()){

    Type= rs.getString(1);
    Title=rs.getString(2);
    DVDNo=rs.getString(3);
    DateCRTD= rs.getString(4);
    Content1=rs.getString(5);
    Content2= rs.getString(6);
    Content3= rs.getString(7);
    Content4=rs.getString(8);
    Content5= rs.getString(9);
    Content6=rs.getString(10);
    Content7= rs.getString(11);
    Content8= rs.getString(12);
    Content9=rs.getString(13);
    Content10= rs.getString(14);
    Notes1=rs.getString(15);
    Notes2= rs.getString(16);
    SearchTag= rs.getString(17);


    L4.setText(Type);
    L5.setText(Title);
    L6.setText(DateCRTD);
    L7.setText(Content1);
    L30.setText(Content2);
    L31.setText(Content3);
    L32.setText(Content4);
    L33.setText(Content5);
    L34.setText(Content6);
    L35.setText(Content7);
    L36.setText(Content8);
    L37.setText(Content9);
    L38.setText(Content10);
    L8.setText(Notes1);
    L40.setText(Notes2);
    L22.setText(SearchTag);
    No21.setText(DVDNo);
    }
    con.commit();
    stmt.close();
    con.close();

    } catch(Exception ex) {
    ex.printStackTrace();
    }

    }
    }

    if (e.getSource() == B2) {
    String DVDNO=No21.getText();

    int x1 = Integer.parseInt(DVDNO);
    x1--;
    System.out.println(x1);
    if (x1<=10 && x1>0) {
    String DVDNO1 = Integer.toString(x1);
    String DVDNO2 = "00"+DVDNO1;
    No21.setText(DVDNO2);
    try {
    String str="SELECT * FROM DVD WHERE DVDNo='"+DVDNO2+"'";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery(str);
    if(rs.next()){

    Type= rs.getString(1);
    Title=rs.getString(2);
    DVDNo=rs.getString(3);
    DateCRTD= rs.getString(4);
    Content1=rs.getString(5);
    Content2= rs.getString(6);
    Content3= rs.getString(7);
    Content4=rs.getString(8);
    Content5= rs.getString(9);
    Content6=rs.getString(10);
    Content7= rs.getString(11);
    Content8= rs.getString(12);
    Content9=rs.getString(13);
    Content10= rs.getString(14);
    Notes1=rs.getString(15);
    Notes2= rs.getString(16);
    SearchTag= rs.getString(17);


    L4.setText(Type);
    L5.setText(Title);
    L6.setText(DateCRTD);
    L7.setText(Content1);
    L30.setText(Content2);
    L31.setText(Content3);
    L32.setText(Content4);
    L33.setText(Content5);
    L34.setText(Content6);
    L35.setText(Content7);
    L36.setText(Content8);
    L37.setText(Content9);
    L38.setText(Content10);
    L8.setText(Notes1);
    L40.setText(Notes2);
    L22.setText(SearchTag);
    No21.setText(DVDNo);
    }
    con.commit();
    stmt.close();
    con.close();

    } catch(Exception ex) {
    ex.printStackTrace();
    }
    }
    if (x1<=100 && x1>=10) {
    String DVDNO1 = Integer.toString(x1);
    String DVDNO3 = "0"+DVDNO1;
    No21.setText(DVDNO3);
    try {
    String str="SELECT * FROM DVD WHERE DVDNo='"+DVDNO3+"'";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery(str);
    if(rs.next()){

    Type= rs.getString(1);
    Title=rs.getString(2);
    DVDNo=rs.getString(3);
    DateCRTD= rs.getString(4);
    Content1=rs.getString(5);
    Content2= rs.getString(6);
    Content3= rs.getString(7);
    Content4=rs.getString(8);
    Content5= rs.getString(9);
    Content6=rs.getString(10);
    Content7= rs.getString(11);
    Content8= rs.getString(12);
    Content9=rs.getString(13);
    Content10= rs.getString(14);
    Notes1=rs.getString(15);
    Notes2= rs.getString(16);
    SearchTag= rs.getString(17);


    L4.setText(Type);
    L5.setText(Title);
    L6.setText(DateCRTD);
    L7.setText(Content1);
    L30.setText(Content2);
    L31.setText(Content3);
    L32.setText(Content4);
    L33.setText(Content5);
    L34.setText(Content6);
    L35.setText(Content7);
    L36.setText(Content8);
    L37.setText(Content9);
    L38.setText(Content10);
    L8.setText(Notes1);
    L40.setText(Notes2);
    L22.setText(SearchTag);
    No21.setText(DVDNo);
    }
    con.commit();
    stmt.close();
    con.close();

    } catch(Exception ex) {
    ex.printStackTrace();
    }
    }
    if (x1>=100) {
    String DVDNO1 = Integer.toString(x1);
    No21.setText(DVDNO1);
    try {
    String str="SELECT * FROM DVD WHERE DVDNo='"+DVDNO1+"'";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //Connection con = DriverManager.getConnection(DbaseCon, "","");
    Connection con = DriverManager.getConnection("jdbc:odbc:DVDInfo");
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery(str);
    if(rs.next()){

    Type= rs.getString(1);
    Title=rs.getString(2);
    DVDNo=rs.getString(3);
    DateCRTD= rs.getString(4);
    Content1=rs.getString(5);
    Content2= rs.getString(6);
    Content3= rs.getString(7);
    Content4=rs.getString(8);
    Content5= rs.getString(9);
    Content6=rs.getString(10);
    Content7= rs.getString(11);
    Content8= rs.getString(12);
    Content9=rs.getString(13);
    Content10= rs.getString(14);
    Notes1=rs.getString(15);
    Notes2= rs.getString(16);
    SearchTag= rs.getString(17);


    L4.setText(Type);
    L5.setText(Title);
    L6.setText(DateCRTD);
    L7.setText(Content1);
    L30.setText(Content2);
    L31.setText(Content3);
    L32.setText(Content4);
    L33.setText(Content5);
    L34.setText(Content6);
    L35.setText(Content7);
    L36.setText(Content8);
    L37.setText(Content9);
    L38.setText(Content10);
    L8.setText(Notes1);
    L40.setText(Notes2);
    L22.setText(SearchTag);
    No21.setText(DVDNo);
    }
    con.commit();
    stmt.close();
    con.close();

    } catch(Exception ex) {
    ex.printStackTrace();
    }

    }
    }