Untitled

 avatar
unknown
java
a year ago
3.8 kB
5
Indexable
import java.sql.*;

public class MyDatabaseHelper {

    private static final String URL = "jdbc:mysql://localhost:3306/mydatabase";
    private static final String USER = "root";
    private static final String PASSWORD = "password";

    public static void insertRow(String email, String password, String name, String roll, String school,
                                 String specialisation, int fee_initial, int sgpa1, int sgpa2, Date lib, int indiscipline) {
        try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD)) {
            String insertQuery = "INSERT INTO mytable (email, password, name, roll, school, specialisation, " +
                    "fee_initial, sgpa1, sgpa2, lib, indiscipline) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);

            preparedStatement.setString(1, email);
            preparedStatement.setString(2, password);
            preparedStatement.setString(3, name);
            preparedStatement.setString(4, roll);
            preparedStatement.setString(5, school);
            preparedStatement.setString(6, specialisation);
            preparedStatement.setInt(7, fee_initial);
            preparedStatement.setInt(8, sgpa1);
            preparedStatement.setInt(9, sgpa2);
            preparedStatement.setDate(10, lib);
            preparedStatement.setInt(11, indiscipline);

            int rowsAffected = preparedStatement.executeUpdate();
            System.out.println("Rows inserted: " + rowsAffected);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static ResultSet selectRow(String email) {
        ResultSet resultSet = null;
        try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD)) {
            String selectQuery = "SELECT * FROM mytable WHERE email = ?";
            PreparedStatement preparedStatement = connection.prepareStatement(selectQuery);
            preparedStatement.setString(1, email);

            resultSet = preparedStatement.executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return resultSet;
    }
    public static void updateRow(String email, String newPassword, String newName, String newRoll, String newSchool,
                            String newSpecialisation, int newFeeInitial, int newSGPA1, int newSGPA2, Date newLib,
                            int newIndiscipline) {
                                
        try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD)) {
            String updateQuery = "UPDATE mytable SET password = ?, name = ?, roll = ?, school = ?, specialisation = ?, " +
                    "fee_initial = ?, sgpa1 = ?, sgpa2 = ?, lib = ?, indiscipline = ? WHERE email = ?";
            PreparedStatement preparedStatement = connection.prepareStatement(updateQuery);

            preparedStatement.setString(1, newPassword);
            preparedStatement.setString(2, newName);
            preparedStatement.setString(3, newRoll);
            preparedStatement.setString(4, newSchool);
            preparedStatement.setString(5, newSpecialisation);
            preparedStatement.setInt(6, newFeeInitial);
            preparedStatement.setInt(7, newSGPA1);
            preparedStatement.setInt(8, newSGPA2);
            preparedStatement.setDate(9, newLib);
            preparedStatement.setInt(10, newIndiscipline);
            preparedStatement.setString(11, email);

            int rowsAffected = preparedStatement.executeUpdate();
            System.out.println("Rows updated: " + rowsAffected);
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
    }

}
Editor is loading...
Leave a Comment