Java Program to Develop a Web application using JDBC Classes

Aim:

Develop a Web application using JDBC Classes (Database Operations – Create, Insert, Delete, Update, Select).

Procedure:

  • Step 1: Open a New Java Web Application on Netbeans Editor.
  • Step 2: Open Netbeans Ide, Choose File -> new Project.
  • Step 3: New Open a New Project and Choose a Web Application.
  • Step 4: Create a Database in Mysql.
  • Step 5: the Give Proper Database Connections Through Web Services.
  • Step 6: Run the Project and Give the Data Through the Application to Database.
  • Step 7: Save the Project (Ctrl+S).
  • Step 8: Run the Project (F5).

Program:

package jdbcproject;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class jk {
 public static void main(String args[]) throws ClassNotFoundException,
SQLException
 {
 Class.forName("com.mysql.jdbc.Driver");
 Connection con =
DriverManager.getConnection("jdbc:mysql://localhost/demo","root","cheran");
 Statement st = con.createStatement(); {
 String sql="select * from dept";
 ResultSet rs=st.executeQuery(sql);
 while(rs.next())
 {
 int rollno=rs.getInt("rollno");
 String name=rs.getString("name");
 System.out.println("ROllNo: "+rollno+","+"NAME: "+name);
 }
 String sql = "INSERT INTO dept " + "VALUES (104, 'jilla')";
 String query="select * from dept"; 
st.executeUpdate(sql);
 ResultSet rs=st.executeQuery(query);
 while(rs.next())
 {
 int rollno=rs.getInt("rollno");
 String name=rs.getString("name");
 System.out.println("ROllNo: "+rollno+","+"NAME: "+name);
 }
 System.out.println("Inserted records into the table...");
 String sql="UPDATE dept SET name='mani'where rollno=107";
 st.executeUpdate(sql);
 String query="select * from dept";
 st.executeUpdate(sql);
 ResultSet rs=st.executeQuery(query);
 while(rs.next())
 {
 int rollno=rs.getInt("rollno");
 String name=rs.getString("name");
 System.out.println("ROllNo: "+rollno+","+"NAME: "+name);
 }
 System.out.println("update successfully....!");
 String sql="DELETE from dept where rollno=104";
 String query="select * from dept";
 st.executeUpdate(sql);
 ResultSet rs=st.executeQuery(query); 
while(rs.next())
 {
 int rollno=rs.getInt("rollno");
 String name=rs.getString("name");
 System.out.println("ROllNo: "+rollno+","+"NAME: "+name);
 }
 System.out.println("deleted successfully...!");
 st.close();
 con.close();
 }
 }
 } 

Output:

Leave a Comment