|
Description:
This program retrieves the data from the table and display it as recordwise. This program connects with the database using the data source name and retrieves the details of all users from the database.The resultset is scrollable and you can move it as recordwise. You can move the ResultSet to the positions of first, next and last. All the fields of the table with the recod number are displayed. loadAllUserDetails() method is used to retrieve all the user details.
Retriew Row values from database display in java swing:
import java.sql.*;
import javax.sql.*;
import javax.swing.*;
public class AllUserDetails extends javax.swing.JFrame {
private Connection dbcon=null;
private String empid=null;
private String read=null;
private String write=null;
private String read_write=null;
private ResultSet rs=null;
private String status="";
private ButtonGroup bgroup=new ButtonGroup();
public AllUserDetails() {
initComponents();
userInitComponents();
}
public void userInitComponents(){
loadAllUserDetails();
status=getUSerStatus();
try{
text_record_num.setText(String.valueOf(rs.getRow()));
}
catch(SQLException e){
e.printStackTrace();
}
text_id.setText(empid);
text_read.setText(read.toUpperCase());
text_write.setText(write.toUpperCase());
text_read_write.setText(read_write.toUpperCase());
text_login_status.setText(status.toUpperCase());
combo_read.setVisible(false);
combo_write.setVisible(false);
combo_read_write.setVisible(false);
check_status.setVisible(false);
bgroup.add(combo_read);
bgroup.add(combo_write);
bgroup.add(combo_read_write);
setBounds(0,0,800,600);
}
private void initComponents() {//GEN-BEGIN:initComponents
jPanel1 = new javax.swing.JPanel();
panel_container = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jPanel3 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
text_read_write = new javax.swing.JTextField();
jLabel3 = new javax.swing.JLabel();
text_write = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
text_read = new javax.swing.JTextField();
combo_read = new javax.swing.JCheckBox();
combo_write = new javax.swing.JCheckBox();
combo_read_write = new javax.swing.JCheckBox();
text_id = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
text_login_status = new javax.swing.JTextField();
check_status = new javax.swing.JCheckBox();
button_next = new javax.swing.JButton();
button_last = new javax.swing.JButton();
button_first = new javax.swing.JButton();
button_previous = new javax.swing.JButton();
jLabel6 = new javax.swing.JLabel();
text_record_num = new javax.swing.JTextField();
getContentPane().setLayout(null);
setTitle("ADMIN ");
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowClosing(java.awt.event.WindowEvent evt) {
exitForm(evt);
}
});
jPanel1.setLayout(null);
jPanel1.setBackground(new java.awt.Color(151, 73, 39));
jPanel1.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
panel_container.setLayout(null);
panel_container.setBackground(new java.awt.Color(151, 73, 39));
panel_container.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel1.setForeground(new java.awt.Color(255, 255, 255));
jLabel1.setText("Employee ID");
jLabel1.setBorder(new javax.swing.border.EmptyBorder(new java.awt.Insets(1, 1, 1, 1)));
panel_container.add(jLabel1);
jLabel1.setBounds(210, 50, 90, 30);
jPanel3.setLayout(null);
jPanel3.setBackground(new java.awt.Color(151, 73, 39));
jPanel3.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel2.setForeground(new java.awt.Color(255, 255, 255));
jLabel2.setText("Read");
jPanel3.add(jLabel2);
jLabel2.setBounds(60, 60, 80, 30);
text_read_write.setBackground(new java.awt.Color(210, 121, 28));
text_read_write.setEditable(false);
text_read_write.setFont(new java.awt.Font("Times New Roman", 1, 14));
text_read_write.setText(" ");
text_read_write.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
jPanel3.add(text_read_write);
text_read_write.setBounds(180, 160, 100, 30);
jLabel3.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel3.setForeground(new java.awt.Color(255, 255, 255));
jLabel3.setText("Write");
jPanel3.add(jLabel3);
jLabel3.setBounds(60, 110, 90, 30);
text_write.setBackground(new java.awt.Color(210, 121, 28));
text_write.setEditable(false);
text_write.setFont(new java.awt.Font("Times New Roman", 1, 14));
text_write.setText(" ");
text_write.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
jPanel3.add(text_write);
text_write.setBounds(180, 110, 100, 30);
jLabel4.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel4.setForeground(new java.awt.Color(255, 255, 255));
jLabel4.setText("Read/Write");
jPanel3.add(jLabel4);
jLabel4.setBounds(60, 160, 90, 30);
text_read.setBackground(new java.awt.Color(210, 121, 28));
text_read.setEditable(false);
text_read.setFont(new java.awt.Font("Times New Roman", 1, 14));
text_read.setText(" ");
text_read.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
jPanel3.add(text_read);
text_read.setBounds(180, 60, 100, 30);
combo_read.setBackground(new java.awt.Color(151, 73, 39));
combo_read.setFont(new java.awt.Font("Times New Roman", 1, 14));
combo_read.setForeground(new java.awt.Color(255, 255, 255));
combo_read.setText("Read");
jPanel3.add(combo_read);
combo_read.setBounds(320, 60, 56, 25);
combo_write.setBackground(new java.awt.Color(151, 73, 39));
combo_write.setFont(new java.awt.Font("Times New Roman", 1, 14));
combo_write.setForeground(new java.awt.Color(255, 255, 255));
combo_write.setText("Write");
jPanel3.add(combo_write);
combo_write.setBounds(320, 110, 61, 25);
combo_read_write.setBackground(new java.awt.Color(151, 73, 39));
combo_read_write.setFont(new java.awt.Font("Times New Roman", 1, 14));
combo_read_write.setForeground(new java.awt.Color(255, 255, 255));
combo_read_write.setText("Read/Write");
jPanel3.add(combo_read_write);
combo_read_write.setBounds(320, 160, 96, 25);
text_id.setBackground(new java.awt.Color(210, 121, 28));
text_id.setEditable(false);
text_id.setFont(new java.awt.Font("Times New Roman", 1, 14));
text_id.setText(" ");
text_id.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
jPanel3.add(text_id);
text_id.setBounds(180, 10, 100, 30);
jLabel5.setFont(new java.awt.Font("Times New Roman", 1, 14));
jLabel5.setForeground(new java.awt.Color(255, 255, 255));
jLabel5.setText("User Login Status");
jPanel3.add(jLabel5);
jLabel5.setBounds(60, 200, 110, 30);
text_login_status.setBackground(new java.awt.Color(210, 121, 28));
text_login_status.setFont(new java.awt.Font("Times New Roman", 1, 14));
text_login_status.setText(" ");
text_login_status.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
jPanel3.add(text_login_status);
text_login_status.setBounds(180, 200, 100, 30);
check_status.setBackground(new java.awt.Color(151, 73, 39));
check_status.setFont(new java.awt.Font("Times New Roman", 1, 14));
check_status.setForeground(new java.awt.Color(255, 255, 255));
check_status.setText("Login Status");
check_status.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
check_statusActionPerformed(evt);
}
});
jPanel3.add(check_status);
check_status.setBounds(320, 200, 110, 25);
panel_container.add(jPanel3);
jPanel3.setBounds(150, 40, 450, 250);
button_next.setBackground(new java.awt.Color(210, 121, 28));
button_next.setForeground(new java.awt.Color(255, 255, 255));
button_next.setText("Next");
button_next.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
button_next.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
button_nextActionPerformed(evt);
}
});
panel_container.add(button_next);
button_next.setBounds(280, 300, 80, 30);
button_last.setBackground(new java.awt.Color(210, 121, 28));
button_last.setForeground(new java.awt.Color(255, 255, 255));
button_last.setText("Last");
button_last.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
button_last.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
button_lastActionPerformed(evt);
}
});
panel_container.add(button_last);
button_last.setBounds(520, 300, 80, 30);
button_first.setBackground(new java.awt.Color(210, 121, 28));
button_first.setForeground(new java.awt.Color(255, 255, 255));
button_first.setText("First");
button_first.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
button_first.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
button_firstActionPerformed(evt);
}
});
panel_container.add(button_first);
button_first.setBounds(150, 300, 80, 30);
button_previous.setBackground(new java.awt.Color(210, 121, 28));
button_previous.setForeground(new java.awt.Color(255, 255, 255));
button_previous.setText("Previous");
button_previous.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
button_previous.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
button_previousActionPerformed(evt);
}
});
panel_container.add(button_previous);
button_previous.setBounds(400, 300, 80, 30);
jLabel6.setBackground(new java.awt.Color(204, 204, 204));
jLabel6.setFont(new java.awt.Font("Times New Roman", 1, 18));
jLabel6.setForeground(new java.awt.Color(255, 255, 255));
jLabel6.setText("Record Number");
panel_container.add(jLabel6);
jLabel6.setBounds(520, 10, 130, 20);
text_record_num.setFont(new java.awt.Font("Times New Roman", 1, 18));
text_record_num.setHorizontalAlignment(javax.swing.JTextField.CENTER);
text_record_num.setText(" ");
text_record_num.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.LOWERED));
panel_container.add(text_record_num);
text_record_num.setBounds(670, 10, 40, 30);
jPanel1.add(panel_container);
panel_container.setBounds(20, 40, 740, 450);
getContentPane().add(jPanel1);
jPanel1.setBounds(0, 0, 850, 650);
pack();
}//GEN-END:initComponents
private void check_statusActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_check_statusActionPerformed
// Add your handling code here:
}//GEN-LAST:event_check_statusActionPerformed
private void button_lastActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_button_lastActionPerformed
// Add your handling code here:
combo_read.setVisible(false);
combo_write.setVisible(false);
combo_read_write.setVisible(false);
check_status.setVisible(false);
status=getUSerStatus();
try{
rs.last();
text_record_num.setText(String.valueOf(rs.getRow()));
empid=String.valueOf(rs.getInt(1));
read=rs.getString(2);
write=rs.getString(3);
read_write=rs.getString(4);
text_id.setText(empid);
text_read.setText(read.toUpperCase());
text_write.setText(write.toUpperCase());
text_read_write.setText(read_write.toUpperCase());
text_login_status.setText(status.toUpperCase());
}
catch(SQLException e){
e.printStackTrace();
}
}//GEN-LAST:event_button_lastActionPerformed
private void button_firstActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_button_firstActionPerformed
// Add your handling code here:
combo_read.setVisible(false);
combo_write.setVisible(false);
combo_read_write.setVisible(false);
check_status.setVisible(false);
status=getUSerStatus();
try{
rs.beforeFirst();
rs.next();
text_record_num.setText(String.valueOf(rs.getRow()));
empid=String.valueOf(rs.getInt(1));
read=rs.getString(2);
write=rs.getString(3);
read_write=rs.getString(4);
text_id.setText(empid);
text_read.setText(read.toUpperCase());
text_write.setText(write.toUpperCase());
text_read_write.setText(read_write.toUpperCase());
text_login_status.setText(status.toUpperCase());
}
catch(SQLException e){
e.printStackTrace();
}
}//GEN-LAST:event_button_firstActionPerformed
private void button_previousActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_button_previousActionPerformed
// Add your handling code here:
combo_read.setVisible(false);
combo_write.setVisible(false);
combo_read_write.setVisible(false);
check_status.setVisible(false);
status=getUSerStatus();
try{
//rs.absolute((rs.getRow()-1));
rs.previous();
text_record_num.setText(String.valueOf(rs.getRow()));
empid=String.valueOf(rs.getInt(1));
read=rs.getString(2);
write=rs.getString(3);
read_write=rs.getString(4);
text_id.setText(empid);
text_read.setText(read.toUpperCase());
text_write.setText(write.toUpperCase());
text_read_write.setText(read_write.toUpperCase());
text_login_status.setText(status.toUpperCase());
}
catch(SQLException e){
e.printStackTrace();
}
}//GEN-LAST:event_button_previousActionPerformed
private void button_nextActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_button_nextActionPerformed
// Add your handling code here:
combo_read.setVisible(false);
combo_write.setVisible(false);
combo_read_write.setVisible(false);
check_status.setVisible(false);
status=getUSerStatus();
try{
if(rs.isLast()){
JOptionPane.showMessageDialog(this,"End of Record");
}
else{
rs.next();
text_record_num.setText(String.valueOf(rs.getRow()));
empid=String.valueOf(rs.getInt(1));
read=rs.getString(2);
write=rs.getString(3);
read_write=rs.getString(4);
text_id.setText(empid);
text_read.setText(read.toUpperCase());
text_write.setText(write.toUpperCase());
text_read_write.setText(read_write.toUpperCase());
text_login_status.setText(status.toUpperCase());
}
}
catch(SQLException e){
e.printStackTrace();
}
}//GEN-LAST:event_button_nextActionPerformed
private void exitForm(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_exitForm
System.exit(0);
}//GEN-LAST:event_exitForm
public static void main(String args[]) {
new AllUserDetails().show();
}
public void loadAllUserDetails(){
PreparedStatement pstmt=null;
PreparedStatement pstmt2=null;
int col_count=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbcon=DriverManager.getConnection("jdbc:odbc:intrusionserver","scott","tiger");
pstmt=dbcon.prepareStatement("select * from Access_Permission",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=pstmt.executeQuery();
if(rs.next()){
empid=String.valueOf(rs.getInt(1));
read=rs.getString(2);
write=rs.getString(3);
read_write=rs.getString(4);
}
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
}
public int storeDataBase(){
Connection dbcon=null;
PreparedStatement pstmt=null;
PreparedStatement pstmt2=null;
String user=null;
int result=0;
boolean read=combo_read.isSelected();
boolean write=combo_write.isSelected();
boolean read_write=combo_read_write.isSelected();
boolean login_status=check_status.isSelected();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbcon=DriverManager.getConnection("jdbc:odbc:intrusionserver","scott","tiger");
pstmt=dbcon.prepareStatement("update Access_Permission set read=?,write=?,read_write=? where empid=?");
pstmt.setString(1,String.valueOf(read));
pstmt.setString(2,String.valueOf(write));
pstmt.setString(3,String.valueOf(read_write));
pstmt.setInt(4,Integer.parseInt(empid));
System.out.println("Set All Parameters");
System.out.println("Emp id:"+empid);
System.out.println("Updated Values");
System.out.println("Read :"+read);
System.out.println("Write :"+write);
System.out.println("Read/Write"+read_write);
result=pstmt.executeUpdate();
pstmt2=dbcon.prepareStatement("update employee_login set permission=? where empid=?");
pstmt2.setString(1,String.valueOf(login_status));
pstmt2.setInt(2,Integer.parseInt(empid));
pstmt2.executeUpdate();
System.out.println("Update Completed");
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
finally{
try{
dbcon.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
return result;
}
public String getUSerStatus(){
String status="";
Connection dbcon=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbcon=DriverManager.getConnection("jdbc:odbc:intrusionserver","scott","tiger");
pstmt=dbcon.prepareStatement("select permission from employee_login where empid=?",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
pstmt.setInt(1,Integer.parseInt(empid));
rs=pstmt.executeQuery();
if(rs.next()){
status=rs.getString("permission");
}
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
finally{
try{
dbcon.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
return status;
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel1;
private javax.swing.JCheckBox combo_write;
private javax.swing.JTextField text_id;
private javax.swing.JTextField text_record_num;
private javax.swing.JTextField text_read;
private javax.swing.JCheckBox combo_read;
private javax.swing.JButton button_previous;
private javax.swing.JButton button_first;
private javax.swing.JButton button_next;
private javax.swing.JTextField text_login_status;
private javax.swing.JTextField text_write;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel4;
private javax.swing.JCheckBox check_status;
private javax.swing.JLabel jLabel3;
private javax.swing.JTextField text_read_write;
private javax.swing.JLabel jLabel2;
private javax.swing.JCheckBox combo_read_write;
private javax.swing.JLabel jLabel1;
private javax.swing.JPanel panel_container;
private javax.swing.JButton button_last;
// End of variables declaration//GEN-END:variables
}
Sample ScreenShot:
|
