Posts

Showing posts from May, 2021

STUDENT REGISTRATION WEB APPLICATION USING JAVA(NETBEANS) + MYSQL(PHPMYADMIN) - PART 02

Image
UPDATE AND DELETE STUDENT update.jsp <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@page import="java.sql.*" %>  <%     if (request.getParameter("submit") != null) {         String id = request.getParameter("id");         String name = request.getParameter("sname");         String course = request.getParameter("course");         String fee = request.getParameter("fee");         Connection con;         PreparedStatement pst;         ResultSet rs;         Class.forName("com.mysql.jdbc.Driver");         con = DriverManager.getConnection("jdbc:mysql://localhost/student", "root", "");         pst = con.prepareStatement("update student_db set stname = ?,course =?,fee= ? where id = ?");         pst.setString(1, name);         pst.setString(2, course);         pst.setString(3, fee);         pst.setString(4, id);         pst.executeUpdate();

STUDENT REGISTRATION WEB APPLICATION USING JAVA(NETBEANS) + MYSQL(PHPMYADMIN) - PART 01

Image
Student.jsp <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@page import="java.sql.*" %> <%     if(request.getParameter("submit")!=null)     {         String name = request.getParameter("sname");         String course = request.getParameter("course");         String fee = request.getParameter("fee");          String contact = request.getParameter("contact");           String nic = request.getParameter("nic");            String address = request.getParameter("address");            String email = request.getParameter("email");                 Connection con;         PreparedStatement pst;         ResultSet rs;                 Class.forName("com.mysql.jdbc.Driver");         con = DriverManager.getConnection("jdbc:mysql://localhost/web_std","root","");         pst = con.prepareSt

SALARY CALCULATOR WINDOWS APPLICATION USING NETBEANS

Image
salary_cal.java package salary_cal; import static com.sun.org.apache.xalan.internal.lib.ExsltDatetime.date; import java.util.Date;   public class salary_cal1 extends javax.swing.JFrame {       public salary_cal1() {         initComponents();         paysheetHeader();       }       private void paysheetHeader() {           txtbill.setText("*****************************************************************" + "\n"                 + "\t" + "ABC Company Pvt(Ltd.)" + "\n"                 + "******************************************************************" + "\n"         );     }          @SuppressWarnings("unchecked")     // <editor-fold defaultstate="collapsed" desc="Generated Code">                               private void initComponents() {           jTextField6 = new javax.swing.JTextField();         jTextField8 = new javax.sw