Java Programming Practical 29
Question 1
Develop JDBC program to retrieve data.
ResultDemo.java
Java
import java.sql.*;
public class ResultDemo
{
public static void main(String args[])
{
try
{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Driver loaded");
Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","");
System.out.println("Connection to the database created");
Statement st = con.createStatement();
String query = "select * from student";
ResultSet rs=st.executeQuery(query);
System.out.println("Roll No\t\t\tName\t\t\tBranch");
while(rs.next())
{
System.out.println(rs.getInt(1)+"\t\t\t"+rs.getString(2)+"\t\t\t"+rs.getString(3));
}
}
catch (Exception e)
{
System.out.println(e);
}
}
}
Output
Question 2
Develop a program to update a record in database table
UpdateDemo.java
Java
import java.sql.*;
public class UpdateDemo
{
public static void main(String args[])
{
try
{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Driver loaded");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "root", "");
System.out.println("Connection to the database created");
PreparedStatement pstmt = con.prepareStatement("update student set branch='IF' where roll_no=?");
pstmt.setInt(1,8989);
int i=pstmt.executeUpdate();
System.out.println(i+" records updated");
con.close();
}
catch (Exception e)
{
System.out.println(e);
}
}
}
Output
