Simple Database Management using JDBC

This a Java Code for a simple Student Database, that allows adding , delete , and modify as well as view in a very simple Frame Interface.

Pre-Requisites:

Install and configure the drivers
Create the Database in the MS Access .
Here the Database name is NiviDB which can be changed according to your database created.

To Run:

Open Command Prompt.
Navigate to the destination of the file.
Compile the java file [ javac DataManagement.java]
Run the compiled file [java DataManagement]



DataManagement.java
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class DataManagement extends Frame implements ActionListener
{
Button ad,remove,update,prev,next;
Label rno,nam,brn,yer;
TextField rn,na,br,yr;
Statement s;
Connection con;
ResultSet rs;
int state;
DataManagement()
{
state=1;
setLayout(null);
ad=new Button("Add");
remove=new Button("Remove");
update=new Button("Update");
add(ad);
ad.setBounds(350,100,60,30);
add(remove);
remove.setBounds(350,150,60,30);
add(update);
update.setBounds(350,200,60,30);
prev=new Button("Previous");
add(prev);
prev.setBounds(100,260,60,30);
next=new Button("Next");
add(next);
next.setBounds(200,260,60,30);
rno=new Label("Roll Number");
add(rno);
rno.setBounds(50,50,120,30);
rn=new TextField(80);
add(rn);
rn.setBounds(170,50,150,30);
nam=new Label("Student Name");
add(nam);
nam.setBounds(50,100,120,30);
na=new TextField(80);
add(na);
na.setBounds(170,100,150,30);
brn=new Label("Branch");
add(brn);
brn.setBounds(50,150,120,30);
br=new TextField(80);
add(br);
br.setBounds(170,150,150,30);
yer=new Label("Year of Study");
add(yer);
yer.setBounds(50,200,120,30);
yr=new TextField(80);
add(yr);
yr.setBounds(170,200,150,30);
ad.addActionListener(this);
update.addActionListener(this);
remove.addActionListener(this);
prev.addActionListener(this);
next.addActionListener(this);
addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent we)
{
setVisible(false);
System.exit(0);
}
});
}

public void actionPerformed(ActionEvent ae)
{
try
{
String str=ae.getActionCommand();
if(str.equals("Add"))
{
System.out.println("Adding new fields");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:NiviDB");
System.out.println("Connection ok.");
String query="insert into StudDB values (?,?,?,?)";
PreparedStatement stmt=con.prepareStatement(query);
stmt.setString(1,rn.getText());
stmt.setString(2,na.getText());
stmt.setString(3,br.getText());
stmt.setString(4,yr.getText());
System.out.println("Batch added");
stmt.executeUpdate();
s.close();
con.close();
}
else if(str.equals("Remove"))
{
System.out.println("Remove existing Fields");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:NiviDB");
System.out.println("Connection ok");
String query="delete from StudDB where RollNo=?";
PreparedStatement stmt=con.prepareStatement(query);
stmt.setString(1,rn.getText());
stmt.executeUpdate();
s.close();
con.close();
}
else if(str.equals("Update"))
{
System.out.println("Update fields");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:NiviDB");
System.out.println("Connection ok");
String query="update StudDB set StudName=?,Dept=?,YearOfStudy=? where RollNo=?";
PreparedStatement stmt=con.prepareStatement(query);
stmt.setString(4,rn.getText());
stmt.setString(1,na.getText());
stmt.setString(2,br.getText());
stmt.setString(3,yr.getText());
stmt.executeUpdate();
s.close();
con.close();
}
else if(str.equals("Next"))
{
System.out.println("Next");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:NiviDB");
Statement s=con.createStatement();
s.execute("select * from StudDB");
ResultSet rs=s.getResultSet();
if(rs!=null)
{
     for(int i=0;i<=state;i++)
        rs.next();
     state++;
System.out.println(""+state);
     rn.setText(rs.getString(1));
     na.setText(rs.getString(2));
     br.setText(rs.getString(3));
     yr.setText(rs.getString(4));  
}
s.close();
con.close();
}
else
{
System.out.println("Previous");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:NiviDB");
Statement s=con.createStatement();
s.execute("select * from StudDB");
ResultSet rs=s.getResultSet();
if(rs!=null)
{
state--;
for(int i=0;i<state;i++)
   rs.next();
System.out.println(""+state);
 rn.setText(rs.getString(1));
     na.setText(rs.getString(2));
     br.setText(rs.getString(3));
     yr.setText(rs.getString(4)); 
}
s.close();
con.close();
}
}catch(Exception e)
     { 
System.out.println(""+e);
}
}

public static void main(String args[])
{
DataManagement obj=new DataManagement();
obj.setVisible(true);
obj.setTitle("Data Management");
obj.setSize(500,400);
Connection con=null;
}
}