JDBC Book_Sales

/*Write a JDBC program in java to display details of Book_Sales(SalesID, Date, Amount)
 *of selected month in JTable. Book_sales table is already created.  (Use JCombo component for Month selection)*/
import java.io.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class BookSales extends JFrame implements ItemListener
{
JComboBox cb;

String head[]={"SalesID","Date","Amount"};
String as[][]=new String[10][10];
public BookSales()
{
setLayout(null);
cb=new JComboBox();
cb.setBounds(350,20,100,20);
cb.addItem("JAN");
cb.addItem("FEB");
cb.addItem("MARCH");
cb.addItem("APRIL");
cb.addItem("MAY");
cb.addItem("JUN");
cb.addItem("JULY");
cb.addItem("AUG");
cb.addItem("SEP");
cb.addItem("OCT");
cb.addItem("NOV");
cb.addItem("DEC");
add(cb);
cb.addItemListener(this);
setSize(500,400);
setVisible(true);

}
public void itemStateChanged(ItemEvent ie)
{
String str=cb.getSelectedItem().toString();

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:dsn","","");
Statement st=cn.createStatement();
ResultSet rs=st.executeQuery("select * from BookSales where Date like '"+str+"%'");
int i=0;

while(rs.next())
{
as[i][0]=rs.getString("SalesID");
as[i][1]=rs.getString("Date");
as[i][2]=rs.getString("Amount");
i++;
}
cn.close();
JTable jt=new JTable(as,head);
JScrollPane pane=new JScrollPane(jt);
pane.setBounds(0,0,300,400);
add(pane);

}catch(Exception e)
{
System.out.println(e);
}

}
public static void main(String args[])
{
new BookSales();
}

}