編集履歴

質問編集履歴

DAOクラスの94行目から96行目でutil.Dateをsql.Dateに変換しました。

2021/12/15 07:19

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -54,7 +54,7 @@
 import java.sql.Time;
-import java.sql.Date;
+import java.util.Date;
 import java.util.ArrayList;
@@ -216,7 +216,13 @@
 			pstmt.setInt(1, btd.getId());
+			Date date = btd.getDate();
+	        long timeInMilliSeconds = date.getTime();
+	        java.sql.Date date1 = new java.sql.Date(timeInMilliSeconds);
-			pstmt.setDate(2, btd.getDate());
+			pstmt.setDate(2, date1);
 			pstmt.setString(3, btd.getStoreName());
@@ -230,6 +236,8 @@
 			pstmt.executeUpdate();
+			System.out.println("Suucessfully added");
 			pstmt.close();

BudgetTrackerDao更新

2021/12/15 07:19

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -54,524 +54,524 @@
 import java.sql.Time;
+import java.sql.Date;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Properties;
+import com.jdbc.budgettracker.core.BudgetTrackerDto;
+public class BudgetTrackerDao {
+	BudgetTrackerDto btd;
+	private Connection myConn;
+	private PreparedStatement mySmt;
+	private static final String SELECTALL = "select * from budget_table;";
+//	private static final String SELECTBYSTORENAME = "select * from budget_table where store name = ?;";
+	private static Connection getConnection() {
+		try {
+			// get db properties
+			Properties props = new Properties();
+			props.load(new FileInputStream(
+					"/home/yosuke/git/BudgetTrackerCui/BudgetTrackerCui/sql/config_budgettracker.properties"));
+			String user = props.getProperty("user");
+			String password = props.getProperty("password");
+			String dburl = props.getProperty("dburl");
+//			Class.forName(RDB_DRIVE);
+			Connection con = DriverManager.getConnection(dburl, user, password);
+			return con;
+		} catch (Exception e) {
+			throw new IllegalStateException(e);
+		}
+	}
+	// select all
+	public List<BudgetTrackerDto> selectAll() throws FileNotFoundException, IOException {
+		List<BudgetTrackerDto> budgetList = new ArrayList<>();
+		try (Connection conn = BudgetTrackerDao.getConnection();
+				PreparedStatement ps = conn.prepareStatement(SELECTALL)) {
+			try (ResultSet rs = ps.executeQuery()) {
+				while (rs.next()) {
+					btd = new BudgetTrackerDto();
+					btd.setId(rs.getInt("ID"));
+					btd.setDate(rs.getDate("Date"));
+					btd.setStoreName(rs.getString("StoreName"));
+					btd.setProductName(rs.getString("ProductName"));
+					btd.setProductType(rs.getString("ProductType"));
+					btd.setPrice(rs.getInt("Price"));
+					budgetList.add(btd);
+				}
+			}
+		} catch (SQLException e) {
+			e.printStackTrace();
+		} catch (Exception e) {
+			e.printStackTrace();
+		} finally {
+		}
+		return budgetList;
+	}
+	public int insertIntoTable(BudgetTrackerDto btd) throws SQLException {
+		int rowsCount = 0;
+		PreparedStatement pstmt;
+		try {
+			// DBに接続
+			myConn = BudgetTrackerDao.getConnection();
+//			pstmt = (PreparedStatement) myConn.createStatement();
+//		String sql = "INSERT INTO budget_table(id,Date,StoreName, ProductName, ProductType, Price) " + "VALUE('"
+//				+ btd.getId() + "','" + btd.getDate() + "','" + btd.getStoreName() + "','" + btd.getProductName() + "','" + btd.getProductType()
+//				+ "','" + btd.getPrice() + "')";
+			String sql = "INSERT INTO budget_table(id,Date,StoreName, ProductName, ProductType, Price) " + "VALUE (?,?,?,?,?,?)";
+			pstmt = myConn.prepareStatement(sql);
+			pstmt.setInt(1, btd.getId());
+			pstmt.setDate(2, btd.getDate());
+			pstmt.setString(3, btd.getStoreName());
+			pstmt.setString(4, btd.getProductName());
+			pstmt.setString(5, btd.getProductType());
+			pstmt.setInt(6, btd.getPrice());
+			// SQL文発行
+			pstmt.executeUpdate();
+			pstmt.close();
+			//rowsCount = pstmt.executeUpdate(sql);
+		} catch (SQLException e) {
+			System.out.println("Errorが発生しました！\n" + e + "\n");
+		} finally {
+			// リソースの開放
+			if (mySmt != null) {
+				try {
+					mySmt.close();
+				} catch (SQLException ignore) {
+				}
+			}
+			if (myConn != null) {
+				try {
+					myConn.close();
+				} catch (SQLException ignore) {
+				}
+			}
+		}
+		return 0;
+	}
+}
+```
+BudgetTrackerDto.java
+```ここに言語を入力
+package com.jdbc.budgettracker.core;
 import java.util.Date;
+public class BudgetTrackerDto {
+    private int id;
+    private Date date;
+    private String storeName;
+    private String productName;
+    private String productType;
+    private int price;
+    public BudgetTrackerDto() {
+    }
+    public BudgetTrackerDto(int id, Date date, String storeName, String productName, String productType, int price) {
+        super();
+        this.id = id;
+        this.date = date;
+        this.storeName = storeName;
+        this.productName = productName;
+        this.productType = productType;
+        this.price = price;
+    }
+    public int getId() {
+        return id;
+    }
+    public void setId(int id) {
+        this.id = id;
+    }
+    public Date getDate() {
+        return date;
+    }
+    public void setDate(Date insertDate) {
+        this.date = insertDate;
+    }
+    public String getStoreName() {
+        return storeName;
+    }
+    public void setStoreName(String storeName) {
+        this.storeName = storeName;
+    }
+    public String getProductName() {
+        return productName;
+    }
+    public void setProductName(String productName) {
+        this.productName = productName;
+    }
+    public String getProductType() {
+        return productType;
+    }
+    public void setProductType(String productType) {
+        this.productType = productType;
+    }
+    public int getPrice() {
+        return price;
+    }
+    public void setPrice(int price) {
+        this.price = price;
+    }
+}
+```
+BudgetTrackerMain.java
+```ここに言語を入力
+package com.jdbc.budgettracker.main;
+import java.io.FileNotFoundException;
+import java.io.IOException;
+import java.sql.SQLException;
+import java.util.Date;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
-import java.util.ArrayList;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
-import java.util.Properties;
+import java.util.Scanner;
 import com.jdbc.budgettracker.core.BudgetTrackerDto;
-public class BudgetTrackerDao {
-	BudgetTrackerDto btd;
-	private Connection myConn;
-	private PreparedStatement mySmt;
-	private static final String SELECTALL = "select * from budget_table;";
-//	private static final String SELECTBYSTORENAME = "select * from budget_table where store name = ?;";
-	private static Connection getConnection() {
-		try {
-			// get db properties
-			Properties props = new Properties();
-			props.load(new FileInputStream(
-					"/home/user/git/BudgetTrackerCui/BudgetTrackerCui/sql/config_budgettracker.properties"));
-			String user = props.getProperty("user");
-			String password = props.getProperty("password");
-			String dburl = props.getProperty("dburl");
-//			Class.forName(RDB_DRIVE);
-			Connection con = DriverManager.getConnection(dburl, user, password);
-			return con;
-		} catch (Exception e) {
-			throw new IllegalStateException(e);
+import com.jdbc.budgettracker.dao.BudgetTrackerDao;
+public class BudgetTrackerMain {
+	一部省略
+		switch (initialNumInt) {
+		case 2:
+			// Insert
+			int insertcannerInt = 0;
+			System.out.println("You chose " + initialSwitchMap.get(2));
+			budgetTrackerDto = new BudgetTrackerDto();
+			Scanner insertScanner = new Scanner(System.in);
+			System.out.print("Input an ID: ");
+			int insertScannerInt = insertScanner.nextInt();
+			budgetTrackerDto.setId(insertScannerInt);
+			System.out.print("Input Date (yyyy-MM-dd): ");
+			String insertScannerStr = insertScanner.next();
+			Date insertDate=(Date) new SimpleDateFormat("yyyy-MM-dd").parse(insertScannerStr);
+			budgetTrackerDto.setDate(insertDate);
+			System.out.print("Input a store name: ");
+			insertScannerStr = insertScanner.next();
+			budgetTrackerDto.setStoreName(insertScannerStr);
+			System.out.print("Input a product name: ");
+			insertScannerStr = insertScanner.next();
+			budgetTrackerDto.setProductName(insertScannerStr);
+			System.out.print("Input a product type: ");
+			insertScannerStr = insertScanner.next();
+			budgetTrackerDto.setProductType(insertScannerStr);
+			System.out.print("Input price: ");
+			insertScannerStr = insertScanner.next();
+			insertcannerInt = Integer.parseInt(insertScannerStr);
+			budgetTrackerDto.setPrice(insertcannerInt);
+			budgetTrackerDao = new BudgetTrackerDao();
+			budgetTrackerDao.insertIntoTable(budgetTrackerDto);
 		}
 	}
-	// select all
-	public List<BudgetTrackerDto> selectAll() throws FileNotFoundException, IOException {
-		List<BudgetTrackerDto> budgetList = new ArrayList<>();
-		try (Connection conn = BudgetTrackerDao.getConnection();
-				PreparedStatement ps = conn.prepareStatement(SELECTALL)) {
-			try (ResultSet rs = ps.executeQuery()) {
-				while (rs.next()) {
-					btd = new BudgetTrackerDto();
-					btd.setId(rs.getInt("ID"));
-					btd.setDate(rs.getDate("Date"));
-					btd.setStoreName(rs.getString("StoreName"));
-					btd.setProductName(rs.getString("ProductName"));
-					btd.setProductType(rs.getString("ProductType"));
-					btd.setPrice(rs.getInt("Price"));
-					budgetList.add(btd);
-				}
-			}
-		} catch (SQLException e) {
-			e.printStackTrace();
-		} catch (Exception e) {
-			e.printStackTrace();
-		} finally {
-		}
-		return budgetList;
-	}
-	public int insertIntoTable(BudgetTrackerDto btd) throws SQLException {
-		int rowsCount = 0;
-		PreparedStatement pstmt;
-		try {
-			// DBに接続
-			myConn = BudgetTrackerDao.getConnection();
-//			pstmt = (PreparedStatement) myConn.createStatement();
-//		String sql = "INSERT INTO budget_table(id,Date,StoreName, ProductName, ProductType, Price) " + "VALUE('"
-//				+ btd.getId() + "','" + btd.getDate() + "','" + btd.getStoreName() + "','" + btd.getProductName() + "','" + btd.getProductType()
-//				+ "','" + btd.getPrice() + "')";
-			String sql = "INSERT INTO budget_table(id,Date,StoreName, ProductName, ProductType, Price) " + "VALUE (?,?,?,?,?,?)";
-			pstmt = myConn.prepareStatement(sql);
-			pstmt.setInt(1, btd.getId());
-			pstmt.setDate(2, (java.sql.Date) btd.getDate());
-			pstmt.setString(3, btd.getStoreName());
-			pstmt.setString(4, btd.getProductName());
-			pstmt.setString(5, btd.getProductType());
-			pstmt.setInt(6, btd.getPrice());
-			// SQL文発行
-			pstmt.executeUpdate();
-			pstmt.close();
-			//rowsCount = pstmt.executeUpdate(sql);
-		} catch (SQLException e) {
-			System.out.println("Errorが発生しました！\n" + e + "\n");
-		} finally {
-			// リソースの開放
-			if (mySmt != null) {
-				try {
-					mySmt.close();
-				} catch (SQLException ignore) {
-				}
-			}
-			if (myConn != null) {
-				try {
-					myConn.close();
-				} catch (SQLException ignore) {
-				}
-			}
-		}
-		return 0;
-	}
 }
 ```
-BudgetTrackerDto.java
-```ここに言語を入力
-package com.jdbc.budgettracker.core;
-import java.util.Date;
-public class BudgetTrackerDto {
-    private int id;
-    private Date date;
-    private String storeName;
-    private String productName;
-    private String productType;
-    private int price;
-    public BudgetTrackerDto() {
-    }
-    public BudgetTrackerDto(int id, Date date, String storeName, String productName, String productType, int price) {
-        super();
-        this.id = id;
-        this.date = date;
-        this.storeName = storeName;
-        this.productName = productName;
-        this.productType = productType;
-        this.price = price;
-    }
-    public int getId() {
-        return id;
-    }
-    public void setId(int id) {
-        this.id = id;
-    }
-    public Date getDate() {
-        return date;
-    }
-    public void setDate(Date insertDate) {
-        this.date = insertDate;
-    }
-    public String getStoreName() {
-        return storeName;
-    }
-    public void setStoreName(String storeName) {
-        this.storeName = storeName;
-    }
-    public String getProductName() {
-        return productName;
-    }
-    public void setProductName(String productName) {
-        this.productName = productName;
-    }
-    public String getProductType() {
-        return productType;
-    }
-    public void setProductType(String productType) {
-        this.productType = productType;
-    }
-    public int getPrice() {
-        return price;
-    }
-    public void setPrice(int price) {
-        this.price = price;
-    }
-}
-```
-BudgetTrackerMain.java
-```ここに言語を入力
-package com.jdbc.budgettracker.main;
-import java.io.FileNotFoundException;
-import java.io.IOException;
-import java.sql.SQLException;
-import java.util.Date;
-import java.text.ParseException;
-import java.text.SimpleDateFormat;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
-import java.util.Scanner;
-import com.jdbc.budgettracker.core.BudgetTrackerDto;
-import com.jdbc.budgettracker.dao.BudgetTrackerDao;
-public class BudgetTrackerMain {
-	一部省略
-		switch (initialNumInt) {
-		case 2:
-			// Insert
-			int insertcannerInt = 0;
-			System.out.println("You chose " + initialSwitchMap.get(2));
-			budgetTrackerDto = new BudgetTrackerDto();
-			Scanner insertScanner = new Scanner(System.in);
-			System.out.print("Input an ID: ");
-			int insertScannerInt = insertScanner.nextInt();
-			budgetTrackerDto.setId(insertScannerInt);
-			System.out.print("Input Date (yyyy-MM-dd): ");
-			String insertScannerStr = insertScanner.next();
-			Date insertDate=(Date) new SimpleDateFormat("yyyy-MM-dd").parse(insertScannerStr);
-			budgetTrackerDto.setDate(insertDate);
-			System.out.print("Input a store name: ");
-			insertScannerStr = insertScanner.next();
-			budgetTrackerDto.setStoreName(insertScannerStr);
-			System.out.print("Input a product name: ");
-			insertScannerStr = insertScanner.next();
-			budgetTrackerDto.setProductName(insertScannerStr);
-			System.out.print("Input a product type: ");
-			insertScannerStr = insertScanner.next();
-			budgetTrackerDto.setProductType(insertScannerStr);
-			System.out.print("Input price: ");
-			insertScannerStr = insertScanner.next();
-			insertcannerInt = Integer.parseInt(insertScannerStr);
-			budgetTrackerDto.setPrice(insertcannerInt);
-			budgetTrackerDao = new BudgetTrackerDao();
-			budgetTrackerDao.insertIntoTable(budgetTrackerDto);
-		}
-	}
-}
-```
 画像 2021/12/15/11:49

エラー内容 2021/12/15 15:49更新

2021/12/15 06:53

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -8,11 +8,15 @@
-エラー内容 2021/12/15 15:31
+エラー内容 2021/12/15 15:49
 ```ここに言語を入力
-Exception in thread "main" java.lang.ClassCastException: class java.util.Date cannot be cast to class java.sql.Date (java.util.Date is in module java.base of loader 'bootstrap'; java.sql.Date is in module java.sql of loader 'platform')
+Exception in thread "main" java.lang.Error: Unresolved compilation problem:
+	The method setDate(int, java.sql.Date) in the type PreparedStatement is not applicable for the arguments (int, java.util.Date)
 	at BudgetTrackerCui/com.jdbc.budgettracker.dao.BudgetTrackerDao.insertIntoTable(BudgetTrackerDao.java:93)

BudgetTrackerMain.javaも一部記載

2021/12/15 06:49

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -438,6 +438,136 @@
 ```
+BudgetTrackerMain.java
+```ここに言語を入力
+package com.jdbc.budgettracker.main;
+import java.io.FileNotFoundException;
+import java.io.IOException;
+import java.sql.SQLException;
+import java.util.Date;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+import java.util.Scanner;
+import com.jdbc.budgettracker.core.BudgetTrackerDto;
+import com.jdbc.budgettracker.dao.BudgetTrackerDao;
+public class BudgetTrackerMain {
+	一部省略
+		switch (initialNumInt) {
+		case 2:
+			// Insert
+			int insertcannerInt = 0;
+			System.out.println("You chose " + initialSwitchMap.get(2));
+			budgetTrackerDto = new BudgetTrackerDto();
+			Scanner insertScanner = new Scanner(System.in);
+			System.out.print("Input an ID: ");
+			int insertScannerInt = insertScanner.nextInt();
+			budgetTrackerDto.setId(insertScannerInt);
+			System.out.print("Input Date (yyyy-MM-dd): ");
+			String insertScannerStr = insertScanner.next();
+			Date insertDate=(Date) new SimpleDateFormat("yyyy-MM-dd").parse(insertScannerStr);
+			budgetTrackerDto.setDate(insertDate);
+			System.out.print("Input a store name: ");
+			insertScannerStr = insertScanner.next();
+			budgetTrackerDto.setStoreName(insertScannerStr);
+			System.out.print("Input a product name: ");
+			insertScannerStr = insertScanner.next();
+			budgetTrackerDto.setProductName(insertScannerStr);
+			System.out.print("Input a product type: ");
+			insertScannerStr = insertScanner.next();
+			budgetTrackerDto.setProductType(insertScannerStr);
+			System.out.print("Input price: ");
+			insertScannerStr = insertScanner.next();
+			insertcannerInt = Integer.parseInt(insertScannerStr);
+			budgetTrackerDto.setPrice(insertcannerInt);
+			budgetTrackerDao = new BudgetTrackerDao();
+			budgetTrackerDao.insertIntoTable(budgetTrackerDto);
+		}
+	}
+}
+```
 画像 2021/12/15/11:49

BudgetTrackerDto.javaを修正

2021/12/15 06:46

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -284,6 +284,8 @@
 ```ここに言語を入力
 package com.jdbc.budgettracker.core;
@@ -430,7 +432,11 @@
+}
-}```
+```

BudgetTrackerDto.javaを追加

2021/12/15 06:37

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -280,6 +280,160 @@
 ```
+BudgetTrackerDto.java
+```ここに言語を入力
+package com.jdbc.budgettracker.core;
+import java.util.Date;
+public class BudgetTrackerDto {
+    private int id;
+    private Date date;
+    private String storeName;
+    private String productName;
+    private String productType;
+    private int price;
+    public BudgetTrackerDto() {
+    }
+    public BudgetTrackerDto(int id, Date date, String storeName, String productName, String productType, int price) {
+        super();
+        this.id = id;
+        this.date = date;
+        this.storeName = storeName;
+        this.productName = productName;
+        this.productType = productType;
+        this.price = price;
+    }
+    public int getId() {
+        return id;
+    }
+    public void setId(int id) {
+        this.id = id;
+    }
+    public Date getDate() {
+        return date;
+    }
+    public void setDate(Date insertDate) {
+        this.date = insertDate;
+    }
+    public String getStoreName() {
+        return storeName;
+    }
+    public void setStoreName(String storeName) {
+        this.storeName = storeName;
+    }
+    public String getProductName() {
+        return productName;
+    }
+    public void setProductName(String productName) {
+        this.productName = productName;
+    }
+    public String getProductType() {
+        return productType;
+    }
+    public void setProductType(String productType) {
+        this.productType = productType;
+    }
+    public int getPrice() {
+        return price;
+    }
+    public void setPrice(int price) {
+        this.price = price;
+    }
+}```
 画像 2021/12/15/11:49
 ![![イメージ説明](023e9f1da0bd0eb74ad4625964ededcf.png)](7963446809efa5fd7c31cdd56cb9dd98.png)

エラー内容 2021/12/15 15:31追記

2021/12/15 06:36

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -8,13 +8,15 @@
-エラー内容 2021/12/15
+エラー内容 2021/12/15 15:31
 ```ここに言語を入力
-Exception in thread "main" java.lang.ClassCastException: class com.mysql.cj.jdbc.StatementImpl cannot be cast to class java.sql.PreparedStatement (com.mysql.cj.jdbc.StatementImpl is in unnamed module of loader 'app'; java.sql.PreparedStatement is in module java.sql of loader 'platform')
-	at BudgetTrackerCui/com.jdbc.budgettracker.dao.BudgetTrackerDao.insertIntoTable(BudgetTrackerDao.java:82)
+Exception in thread "main" java.lang.ClassCastException: class java.util.Date cannot be cast to class java.sql.Date (java.util.Date is in module java.base of loader 'bootstrap'; java.sql.Date is in module java.sql of loader 'platform')
+	at BudgetTrackerCui/com.jdbc.budgettracker.dao.BudgetTrackerDao.insertIntoTable(BudgetTrackerDao.java:93)
+	at BudgetTrackerCui/com.jdbc.budgettracker.main.BudgetTrackerMain.main(BudgetTrackerMain.java:130)
 ```

93行目をpstmt.setDate(2, (java.sql.Date) btd.getDate());に変更

2021/12/15 06:31

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -48,6 +48,8 @@
 import java.sql.Time;
+import java.util.Date;
 import java.util.ArrayList;
 import java.util.List;
@@ -88,7 +90,7 @@
 			props.load(new FileInputStream(
-					"/home/yosuke/git/BudgetTrackerCui/BudgetTrackerCui/sql/config_budgettracker.properties"));
+					"/home/user/git/BudgetTrackerCui/BudgetTrackerCui/sql/config_budgettracker.properties"));
@@ -174,11 +176,11 @@
-	public int insertIntoTable(BudgetTrackerDto budgetTrackerDto) throws SQLException {
+	public int insertIntoTable(BudgetTrackerDto btd) throws SQLException {
 		int rowsCount = 0;
-		btd = new BudgetTrackerDto();
 		PreparedStatement pstmt;
@@ -208,7 +210,7 @@
 			pstmt.setInt(1, btd.getId());
-			pstmt.setTime(2, (Time) btd.getDate());
+			pstmt.setDate(2, (java.sql.Date) btd.getDate());
 			pstmt.setString(3, btd.getStoreName());

画像「2021/12/15/12:21」を添付

2021/12/15 06:29

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -279,3 +279,9 @@
 画像 2021/12/15/11:49
 ![![イメージ説明](023e9f1da0bd0eb74ad4625964ededcf.png)](7963446809efa5fd7c31cdd56cb9dd98.png)
+画像 2021/12/15/12:21
+![イメージ説明](9e2c388c8c09173d78b5d794aac14219.png)

画像を挿入しました。

2021/12/15 03:22

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -275,3 +275,7 @@
 }
 ```
+画像 2021/12/15/11:49
+![![イメージ説明](023e9f1da0bd0eb74ad4625964ededcf.png)](7963446809efa5fd7c31cdd56cb9dd98.png)

90行目から96行目を更新

2021/12/15 02:49

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -188,7 +188,7 @@
 			myConn = BudgetTrackerDao.getConnection();
-			　//pstmt = (PreparedStatement) myConn.createStatement();
+//			pstmt = (PreparedStatement) myConn.createStatement();
@@ -206,21 +206,21 @@
 			pstmt = myConn.prepareStatement(sql);
-			(pstmt).setInt(1, btd.getId());
+			pstmt.setInt(1, btd.getId());
-			(pstmt).setTime(2, (Time) btd.getDate());
+			pstmt.setTime(2, (Time) btd.getDate());
-			(pstmt).setString(3, btd.getStoreName());
+			pstmt.setString(3, btd.getStoreName());
-			(pstmt).setString(4, btd.getProductName());
+			pstmt.setString(4, btd.getProductName());
-			(pstmt).setString(5, btd.getProductType());
+			pstmt.setString(5, btd.getProductType());
-			(pstmt).setInt(6, btd.getPrice());
+			pstmt.setInt(6, btd.getPrice());
 			// SQL文発行
-			pstmt.executeUpdate(sql);
+			pstmt.executeUpdate();
 			pstmt.close();

８２行目をコメントアウト

2021/12/15 02:42

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -188,7 +188,7 @@
 			myConn = BudgetTrackerDao.getConnection();
-			pstmt = (PreparedStatement) myConn.createStatement();
+			　//pstmt = (PreparedStatement) myConn.createStatement();

エラー内容更新

2021/12/15 02:37

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -8,16 +8,20 @@
-エラー内容
+エラー内容 2021/12/15
 ```ここに言語を入力
-java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?,?,?,?,?,?)' at line 1
+Exception in thread "main" java.lang.ClassCastException: class com.mysql.cj.jdbc.StatementImpl cannot be cast to class java.sql.PreparedStatement (com.mysql.cj.jdbc.StatementImpl is in unnamed module of loader 'app'; java.sql.PreparedStatement is in module java.sql of loader 'platform')
+	at BudgetTrackerCui/com.jdbc.budgettracker.dao.BudgetTrackerDao.insertIntoTable(BudgetTrackerDao.java:82)
 ```
 BudgetTrackerDao.java
 ```ここに言語を入力

PreparedStatementに統一

2021/12/15 02:25

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -42,8 +42,6 @@
 import java.sql.SQLException;
-import java.sql.Statement;
 import java.sql.Time;
 import java.util.ArrayList;
@@ -64,11 +62,13 @@
 	private Connection myConn;
-	private Statement mySmt;
+	private PreparedStatement mySmt;
-	private static final String SQL = "select * from budget_table;";
+	private static final String SELECTALL = "select * from budget_table;";
+//	private static final String SELECTBYSTORENAME = "select * from budget_table where store name = ?;";
@@ -84,7 +84,7 @@
 			props.load(new FileInputStream(
-					"/home/user/git/BudgetTrackerCui/BudgetTrackerCui/sql/config_budgettracker.properties"));
+					"/home/yosuke/git/BudgetTrackerCui/BudgetTrackerCui/sql/config_budgettracker.properties"));
@@ -110,13 +110,17 @@
+	// select all
 	public List<BudgetTrackerDto> selectAll() throws FileNotFoundException, IOException {
 		List<BudgetTrackerDto> budgetList = new ArrayList<>();
-		try (Connection conn = BudgetTrackerDao.getConnection(); PreparedStatement ps = conn.prepareStatement(SQL)) {
+		try (Connection conn = BudgetTrackerDao.getConnection();
+				PreparedStatement ps = conn.prepareStatement(SELECTALL)) {
@@ -164,7 +168,7 @@
-	// Insert
 	public int insertIntoTable(BudgetTrackerDto budgetTrackerDto) throws SQLException {
@@ -172,7 +176,7 @@
 		btd = new BudgetTrackerDto();
-		Statement pstmt;
+		PreparedStatement pstmt;
 		try {
@@ -180,7 +184,7 @@
 			myConn = BudgetTrackerDao.getConnection();
-			pstmt = myConn.createStatement();
+			pstmt = (PreparedStatement) myConn.createStatement();
@@ -192,21 +196,25 @@
-			String sql = "INSERT INTO budget_table(id,Date,StoreName, ProductName, ProductType, Price) "　+ "VALUE (?,?,?,?,?,?)";
+			String sql = "INSERT INTO budget_table(id,Date,StoreName, ProductName, ProductType, Price) " + "VALUE (?,?,?,?,?,?)";
 			pstmt = myConn.prepareStatement(sql);
-			((PreparedStatement) pstmt).setInt(1, btd.getId());
+			(pstmt).setInt(1, btd.getId());
-			((PreparedStatement) pstmt).setTime(2, (Time) btd.getDate());
+			(pstmt).setTime(2, (Time) btd.getDate());
-			((PreparedStatement) pstmt).setString(3, btd.getStoreName());
+			(pstmt).setString(3, btd.getStoreName());
-			((PreparedStatement) pstmt).setString(4, btd.getProductName());
+			(pstmt).setString(4, btd.getProductName());
-			((PreparedStatement) pstmt).setString(5, btd.getProductType());
+			(pstmt).setString(5, btd.getProductType());
-			((PreparedStatement) pstmt).setInt(6, btd.getPrice());
+			(pstmt).setInt(6, btd.getPrice());
+			// SQL文発行
 			pstmt.executeUpdate(sql);
@@ -214,6 +222,8 @@
+			//rowsCount = pstmt.executeUpdate(sql);
 		} catch (SQLException e) {
 			System.out.println("Errorが発生しました！\n" + e + "\n");

SQL文内の全角スペースを削除しました。

2021/12/15 02:20

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -192,9 +192,7 @@
-			String sql = "INSERT INTO budget_table(id,Date,StoreName, ProductName, ProductType, Price) "
+			String sql = "INSERT INTO budget_table(id,Date,StoreName, ProductName, ProductType, Price) "　+ "VALUE (?,?,?,?,?,?)";
-					+ "VALUE (?,?,?,?,?,?)";
 			pstmt = myConn.prepareStatement(sql);

不要だった２回目のexecuteUpdateを削除

2021/12/15 01:25

投稿

Yakusugi

スコア123

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -216,10 +216,6 @@
-			// SQL文発行
-			rowsCount = pstmt.executeUpdate(sql);
 		} catch (SQLException e) {
 			System.out.println("Errorが発生しました！\n" + e + "\n");