Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package Connectivity;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.Statement;
- public class BaseConnection {
- private Connection connection;
- public BaseConnection() {
- getConnection();
- }
- public Connection getConnection() {
- String dbname = "ExpensesApp";
- String username= "root";
- String password= "";
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connection = DriverManager.getConnection("jdbc:mysql://localhost:8080/"+dbname+username);
- }
- catch(Exception e) {
- e.printStackTrace();
- }
- return connection;
- }
- public void addToBase(String date, String category, String price, String description){
- try{
- Statement statement = connection.createStatement();
- String sql = "INSERT INTO EXPENSESBOARD VALUES('"+date+","+category+","+price+","+description+"')";
- statement.executeUpdate(sql);
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement