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:
