Connectivity coding

Insertion:

            String admno= jTextField1.getText();
    String rollno= jTextField2.getText();
    String name = jTextField3.getText();
    String address =jTextField4.getText();
    String marks=jTextField5.getText();


    try

    {
        Class.forName("java.sql.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/school","root","1234");
            Statement stmt =  con.createStatement();
            String query= "INSERT INTO student VALUES ('"+admno+"','"+rollno+"','"+name+"','"+address+"',"+marks+");";

                 JOptionPane.showMessageDialog(this,query);
            stmt.executeUpdate(query);


    }

    catch(Exception e)
    {
        JOptionPane.showMessageDialog(this,e.getMessage());
    }



    }

   //SEARCH
 private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String admno= jTextField1.getText();

    try

    {
        Class.forName("java.sql.Driver");
            Connection con = (Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/school","root","1234");
            Statement stmt = (Statement) con.createStatement();
            String query= "SELECT rollno,name,address,marks from student where admno='"+admno+"';";

                   ResultSet rs= stmt.executeQuery(query);
                   if(rs.next())
                   {
                   String rollno= rs.getString("rollno");
                   String name = rs.getString("name");
                   String address = rs.getString("address");
                   String marks = rs.getString("marks");

                   jTextField2.setText(rollno);
                  jTextField3.setText(name);
                  jTextField4.setText(address);
                  jTextField5.setText(marks);


        }}

 catch(Exception e)
    {
        JOptionPane.showMessageDialog(this,e.getMessage());
    }
    }