public void actionPerformed(ActionEvent e) {
//String DbaseCon = "Jdbc

dbc

river={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

dbc

VDInfo");
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

dbc

VDInfo");
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

dbc

VDInfo");
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

dbc

VDInfo");
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

dbc

VDInfo");
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

dbc

VDInfo");
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();
}
}
}