// Login.java
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Login extends JFrame {
JTextField _username = new JTextField(10);
JPasswordField _password = new JPasswordField(10);
JButton _login = new JButton("Login");
JButton _exit = new JButton("Exit");
Toolkit kit = Toolkit.getDefaultToolkit();
Dimension screenSize = kit.getScreenSize();
int screenHeight = (int)screenSize.getHeight();
int screenWidth = (int)screenSize.getWidth();
public Login() {
super("Login to panel");
setLayout(new GridLayout(3,2,1,1));
add(new JLabel("Username:"));
add(_username);
add(new JLabel("Password:"));
add(_password);
add(_login);
_login.addActionListener(new LoginListener());
add(_exit);
_exit.addActionListener(new ExitListener());
setSize(250, 100);
//setLocation(screenWidth/3, screenHeight/3);
setLocation(500, 400);
setResizable(false);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setVisible(true);
}
public static void main(String[] args) {
new Login();
}
public class LoginListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
Connection con;
Statement stmt;
ResultSet rs;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys","root","root");
String usernameT = _username.getText();
String passwordT = _password.getText();
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql = "SELECT * FROM main WHERE username = '" + usernameT + "';";
rs = stmt.executeQuery(sql);
PreparedStatement loginTime = con.prepareStatement("UPDATE `main` WHERE ID = ?");
if(rs.next()) {
if(passwordT.equals(rs.getString("password"))) {
dispose();
new Panel();
} else {
JOptionPane.showMessageDialog(null, "Invalid password!");
}
} else {
JOptionPane.showMessageDialog(null, "Username not found!");
}
} catch(SQLException sqle) {
sqle.printStackTrace();
} catch(ClassNotFoundException cnfe) {
cnfe.printStackTrace();
}
}
}
public class ExitListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
dispose();
System.exit(0);
}
}
}
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class Panel extends JFrame {
JButton addMember = new JButton("Add Members");
JButton editMember = new JButton("Edit Members");
JButton viewReport = new JButton("View Report");
JButton exit = new JButton("Exit");
public Panel() {
super("The Panel");
setLayout(new GridLayout(1,4));
add(addMember);
addMember.addActionListener(new AddMemberListener());
add(editMember);
editMember.addActionListener(new EditMemberListener());
add(viewReport);
viewReport.addActionListener(new ReportListener());
add(exit);
exit.addActionListener(new ExitListener());
setSize(700, 100);
setLocation(300, 600);
setResizable(false);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setVisible(true);
}
public static void main(String[] args) {
new Panel();
}
public class AddMemberListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
new Main();
}
}
public class EditMemberListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
new EditMember();
}
}
public class ReportListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
new Report();
}
}
public class ExitListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
dispose();
System.exit(0);
}
}
}
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class Main extends JFrame {
private static final int HEIGHT = 200;
private static final int WIDTH = 406;
String[] positions = {"", "Trainee", "Writer", "Moderator", "Administrator"};
JButton _addToFile = new JButton("Add Member");
JButton _clearFields = new JButton("Clear Fields");
JButton _generate = new JButton("Generate");
JButton _exitProgram = new JButton("Exit");
JTextField _id = new JTextField(10);
JTextField _name = new JTextField(10);
JTextField _username = new JTextField(10);
JTextField _password = new JPasswordField(10);
JComboBox _position = new JComboBox(positions);
public Main() {
super("Administration Panel");
Container panel = getContentPane();
setLayout(new GridLayout(7,1,1,1));
_id.setEditable(false);
_id.setText(getId());
add(new JLabel("ID:"));
add(_id);
add(new JLabel("Name:"));
add(_name);
_name.addActionListener(new NameListener());
add(new JLabel("Username:"));
add(_username);
add(new JLabel("Password:"));
add(_password);
add(new JLabel("Position:"));
add(_position);
add(_addToFile);
_addToFile.addActionListener(new AddToFileListener());
add(_clearFields);
_clearFields.addActionListener(new ClearListener());
add(_generate);
_generate.addActionListener(new GeneraterListener());
add(_exitProgram);
_exitProgram.addActionListener(new ExitProgramListener());
setSize(WIDTH, HEIGHT);
setResizable(false);
setLocation(500, 300);
setDefaultCloseOperation(DISPOSE_ON_CLOSE);
setVisible(true);
}
public static void main(String[] args) {
new Main();
}
public class ClearListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
_id.setText(getId());
_name.setText("");
_username.setText("");
_password.setText("");
_position.setSelectedIndex(0);
}
}
public class NameListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
String fname = "";
String lname = "";
Scanner nameScan = new Scanner(_name.getText());
while(nameScan.hasNext()) {
fname = nameScan.next();
lname = nameScan.next();
}
_username.setText(fname.toLowerCase() + "" + _id.getText());
_password.setText(lname.toLowerCase() + "" + _id.getText());
if(_name.getText().startsWith("Wri")) {
_position.setSelectedIndex(2);
} else if(_name.getText().startsWith("Mod")) {
_position.setSelectedIndex(3);
} else if(_name.getText().startsWith("Adm")) {
_position.setSelectedIndex(4);
} else {
_position.setSelectedIndex(1);
}
}
}
public class AddToFileListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
Connection con;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys","root","root");
PreparedStatement pstmt = con.prepareStatement("INSERT INTO `main` (`id`, `name`, `username`, `password`, `position`) VALUES (?, ?, ?, ?, ?)");
pstmt.setInt(1, Integer.parseInt(_id.getText()));
pstmt.setString(2, _name.getText());
pstmt.setString(3, _username.getText());
pstmt.setString(4, _password.getText());
pstmt.setString(5, _position.getSelectedItem().toString());
if(_id.getText().equals("") ||
_name.getText().equals("") ||
_username.getText().equals("") ||
_password.getText().equals("") ||
_position.getSelectedIndex() == 0) {
JOptionPane.showMessageDialog(null, "Error in fields");
} else {
if(_position.getSelectedIndex() == 4) {
int result = JOptionPane.showConfirmDialog(null, "Are you sure you would like to make " + _name.getText() + " an admin?", "Confirmation", JOptionPane.YES_NO_OPTION);
if(result == JOptionPane.YES_OPTION) {
pstmt.execute();
}
} else {
pstmt.execute();
}
}
/*if(_position.getSelectedIndex() == 0) {
JOptionPane.showMessageDialog(null, "Position cannot be null");
} else if(_id.getText().equals("")) {
JOptionPane.showMessageDialog(null, "ID cannot be null");
}*/
_id.setText(getId());
_name.setText("");
_username.setText("");
_password.setText("");
_position.setSelectedIndex(0);
} catch(Exception IOE) {
IOE.printStackTrace();
}
}
}
public String getId() {
Connection con;
Statement stmt;
ResultSet rs;
String returnId = "";
int idA = 0;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys","root","root");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT MAX(id) FROM main");
while(rs.next()) {
idA = rs.getInt(1);
}
++idA;
returnId = Integer.toString(idA);
con.close();
} catch(Exception e) {
e.printStackTrace();
}
return returnId;
}
private class GeneraterListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
Connection con;
Statement stmt;
ResultSet rs;
try {
FileWriter fw = new FileWriter(new File("report.txt"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys","root","root");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT * FROM main");
fw.write("Report generated: \r");
fw.write(" [ID]: Full Name | Username | Password | Position");
fw.write("\r+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++");
while(rs.next()) {
fw.write("\r| [" + rs.getInt("id") + "]: " + rs.getString("name") + " | " + rs.getString("username") + " | " + rs.getString("password") + " | " + rs.getString("position"));
}
fw.write("\r+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++");
fw.close();
con.close();
} catch(Exception ie) {
JOptionPane.showMessageDialog(null, "Something has happened! \n" + ie);
}
}
}
private class ExitProgramListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
dispose();
}
}
}
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.ArrayList;
import java.io.PrintWriter;
import java.io.FileWriter;
import java.io.File;
import java.io.IOException;
public class EditMember extends JFrame {
String[] positions = {"", "Trainee", "Writer", "Moderator", "Administrator"};
JComboBox _id = new JComboBox(getId());
JComboBox _position = new JComboBox(positions);
JTextField _name = new JTextField(10);
JTextField _username = new JTextField(10);
JPasswordField _password = new JPasswordField(10);
JButton edit = new JButton("Edit Member");
JButton delete = new JButton("Delete Member");
JButton generate = new JButton("Generate Report");
JButton exit = new JButton("Exit");
JButton load = new JButton("Load in");
Toolkit kit = Toolkit.getDefaultToolkit();
Dimension screenSize = kit.getScreenSize();
int screenHeight = (int)screenSize.getHeight();
int screenWidth = (int)screenSize.getWidth();
public EditMember() {
super("Edit Member");
setLayout(new GridLayout(7,1,1,1));
add(_id);
add(load);
load.addActionListener(new LoadInListener());
add(new JLabel("Name:"));
add(_name);
add(new JLabel("Username:"));
add(_username);
add(new JLabel("Password:"));
add(_password);
add(new JLabel("Position:"));
add(_position);
add(edit);
edit.addActionListener(new EditListener());
add(delete);
delete.addActionListener(new DeleteListener());
add(generate);
generate.addActionListener(new GeneraterListener());
add(exit);
exit.addActionListener(new ExitListener());
setSize(406, 200);
setResizable(false);
setLocation(500, 300);
setDefaultCloseOperation(DISPOSE_ON_CLOSE);
setVisible(true);
}
public static void main(String[] args) {
new EditMember();
}
public Object[] getId() {
Connection con;
Statement stmt;
ResultSet rs;
//Object[] returnId;
ArrayList<Object> returnId = new ArrayList<Object>();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys","root","root");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT `id` FROM main");
while(rs.next()) {
returnId.add(rs.getObject("id"));
}
con.close();
} catch(Exception e) {
e.printStackTrace();
}
return returnId.toArray(new Object[returnId.size()]);
}
public class EditListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
edit();
}
}
public class ExitListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
dispose();
}
}
public class LoadInListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
String giveId = _id.getSelectedItem().toString();
populate(giveId);
}
}
public class DeleteListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
delete();
}
}
private class GeneraterListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
Connection con;
Statement stmt;
ResultSet rs;
try {
FileWriter fw = new FileWriter(new File("report.txt"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys","root","root");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT * FROM main");
fw.write("Report generated: \r");
fw.write(" [ID]: Full Name | Username | Password | Position");
fw.write("\r+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++");
while(rs.next()) {
fw.write("\r| [" + rs.getInt("id") + "]: " + rs.getString("name") + " | " + rs.getString("username") + " | " + rs.getString("password") + " | " + rs.getString("position"));
}
fw.write("\r+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++");
fw.close();
con.close();
} catch(Exception ie) {
JOptionPane.showMessageDialog(null, "Something has happened! \n" + ie);
}
}
}
public void edit() {
Connection con;
Statement stmt;
ResultSet rs;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys", "root", "root");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
PreparedStatement prep = con.prepareStatement("UPDATE `main` SET `name` = ?, `username` = ?, `password` = ?, `position` = ? WHERE `ID` = ?");
prep.setString(1, _name.getText());
prep.setString(2, _username.getText());
prep.setString(3, _password.getText());
prep.setString(4, _position.getSelectedItem().toString());
prep.setInt(5, (int)_id.getSelectedItem());
prep.executeQuery();
} catch(SQLException sqle) {
StringBuilder sb = new StringBuilder();
StackTraceElement[] st = sqle.getStackTrace();
for(StackTraceElement s : st) {
sb.append(s);
sb.append('\n');
}
try {
FileWriter fw = new FileWriter(new File("Error_Report.txt"));
fw.write(sb.toString());
fw.close();
} catch(IOException ioe) {
ioe.printStackTrace();
}
} catch(ClassNotFoundException cnfe) {
StringBuilder sb = new StringBuilder();
StackTraceElement[] st = cnfe.getStackTrace();
for(StackTraceElement s : st) {
sb.append(s);
sb.append('\n');
}
try {
FileWriter fw = new FileWriter(new File("Error_Report.txt"));
fw.write(sb.toString());
fw.close();
} catch(IOException ioe) {
ioe.printStackTrace();
}
}
}
public void delete() {
Connection con;
Statement stmt;
ResultSet rs;
int idA;
String name, username, password, position;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys","root","root");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
PreparedStatement pstmt = con.prepareStatement("DELETE FROM `main` WHERE ID = ?");
pstmt.setInt(1, (int)_id.getSelectedItem());
pstmt.execute();
_id.removeItem(_id.getSelectedItem());
_name.setText("");
_username.setText("");
_password.setText("");
_position.setSelectedIndex(0);
} catch(Exception e) {
e.printStackTrace();
}
}
public void populate(String a) {
Connection con;
Statement stmt;
ResultSet rs;
int idA;
String name, username, password, position;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:collegesys","root","root");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT * FROM main");
while(rs.next()) {
idA = rs.getInt("id");
name = rs.getString("name");
username = rs.getString("username");
password = rs.getString("password");
position = rs.getString("position");
if(Integer.parseInt(a) == idA) {
_name.setText(name);
_username.setText(username);
_password.setText(password);
_position.setSelectedItem(position);
}
}
} catch(Exception e) {
e.printStackTrace();
}
}
}
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.FileReader;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.FileNotFoundException;
public class Report extends JFrame {
private static final int HEIGHT = 300;
private static final int WIDTH = 506;
JTextArea report = new JTextArea(14, 45);
JScrollPane scrollPane = new JScrollPane(report);
JButton load = new JButton("Load File");
JButton exit = new JButton("Exit");
public Report() {
super("Report Viewer");
setLayout(new FlowLayout());
report.setEditable(false);
add(scrollPane);
add(load);
load.addActionListener(new LoadListener());
add(exit);
exit.addActionListener(new ExitListener());
setSize(WIDTH, HEIGHT);
setResizable(false);
setLocation(480, 280);
setDefaultCloseOperation(DISPOSE_ON_CLOSE);
setVisible(true);
}
public static void main(String[] args) {
new Report();
}
public class LoadListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
try {
FileReader reader = new FileReader("report.txt");
BufferedReader br = new BufferedReader(reader);
report.read(br, null);
br.close();
} catch(IOException ioe) {
ioe.printStackTrace();
}
}
}
public class ExitListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
dispose();
}
}
}

New Topic/Question
Reply


MultiQuote









|