Untitled

 avatar
unknown
java
a year ago
2.2 kB
14
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;
    }
}
Editor is loading...
Leave a Comment