How to use SQL java program in java jsp

19. SQL Demo Program

//************************Start************************
f
import java.sql.*;

public class select_st {

    public static void main(String arsg[]) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:select");
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("Select * from student");
            ResultSetMetaData rsmd = rs.getMetaData();
            String c1 = rsmd.getColumnName(1);
            String c2 = rsmd.getColumnName(2);
            String c3 = rsmd.getColumnName(3);
            System.out.println(c1 + "\t" + c2 + "\t" + c3);
            while (rs.next()) {
                int r = rs.getInt("rollno");
                String n = rs.getString("name");
                String c = rs.getString("class");
                System.out.println(r + "\t" + n + "\t" + c);

            }
            con.close();

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

//************************End************************


20. Split Pane Demo Program

//***********************Start************************

import javax.swing.*;
import java.awt.*;
import javax.swing.tree.*;
public class split_pane  extends JFrame  {
    JSplitPane sp;
     JButton b1, b2;
     public split_pane()
     {
          Container c = getContentPane();
        c.setLayout(new BorderLayout());
         b1 = new JButton("ok");
        b2 = new JButton("cancel");
        sp=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,b1,b2);
        c.add(sp);
         setSize(300, 300);
        setVisible(true);
     }
     public static void main(String arsg[]) {
        split_pane obj = new split_pane();
}
}

//***********************End*************************