Core Java Concepts

OOPS Concepts

To update

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:university","SYSTEM","12345");

String name=request.getParameter("name");
String duration=request.getParameter("duration");
String subject=request.getParameter("subject");
String fee=request.getParameter("fee");
String code=request.getParameter("code");


String query = "update COURSE set NAME =?,DURATION=?,SUBJECT=?,TOTAL_FEE=? where COURSE_CODE=? ";
PreparedStatement pstmt = con.prepareStatement(query); // create a statement
pstmt.setString(1,name);
pstmt.setString(2,duration);
pstmt.setString(3,subject);
pstmt.setString(4,fee);
pstmt.setString(5,code);


pstmt.executeUpdate();
} catch(Exception e) {
e.printStackTrace();

}
%>

To remove a entry

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:university","SYSTEM","12345");
PreparedStatement ps=con.prepareStatement("DELETE FROM COURSE WHERE COURSE_CODE=?");
ps.setString(1,request.getParameter("code"));
ps.executeUpdate();
ps.close();
con.close();
}
catch(Exception e)
{
out.println("error occured" +e);
}
%>

To check admin

<% String user=request.getParameter("user"); String password=request.getParameter("password"); if (user.equals("admin") && password.equals("admin")) { %>



<% } else { %>



<% } %>

To add something in Database

<%@ page language="java" import="java.sql.*; "%>


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:university","system","12345"); PreparedStatement ps=con.prepareStatement("Insert into COURSE(COURSE_CODE, NAME, DURATION, SUBJECT, TOTAL_FEE) VALUES(?,?,?,?,?)"); ps.setString(1,request.getParameter("code")); ps.setString(2,request.getParameter("name")); ps.setString(3,request.getParameter("duration")); ps.setString(4,request.getParameter("subject")); ps.setString(5,request.getParameter("fee")); ps.executeUpdate(); ps.close(); con.close(); } catch(Exception e){ out.println(e); } %>

Successfully Added Course