[問題] SQL顯示指令
想請問一下
有沒有什麼SQL指令是可以讓我剛剛輸入的值存到資料庫後再被我抓出來的?!
我的意思是:
我在新增會員的時候,輸入完基本資料,按下送出(傳送在資料庫),
怎樣才能把剛剛輸入的值顯示在畫面上!?
我只能讀取全部的資料,並沒有辦法讀取剛新增的那筆
以下是我的程式碼:
out.println("請輸入帳號: <br>");
String UserName = br.readLine();
out.println("請輸入密碼: <br>");
String Password = br.readLine();
out.println("請輸入姓名: <br>");
String Name = br.readLine();
out.println("請輸入E-Mail: <br>");
String Email = br.readLine();
out.println("請輸入生日: <br>");
String Birthday = br.readLine();
String sql = "insert into mytest(UserName,
Password,
Name,
Email,
Birthday)
values('" +UserName+ "',
'" +Password+ "',
'" +Name+ "',
'" +Email+ "',
'" +Birthday+ "')";
stmt.executeUpdate(sql);
out.println("<br>新增紀錄<br>");
ResultSet rs = stmt.executeQuery("select * from mytest");
while(rs.next()){
out.println("帳號: " + rs.getString("UserName") + "<br>" +
"密碼: " + rs.getString("Password") + "<br>" +
"姓名: " + rs.getString("Name") + "<br>" +
"E-Mail: " + rs.getString("Email") + "<br>" +
"生日: " + rs.getString("Birthday") + "<br>");
}
請各位大大鞭小力一點...
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.131.12.63
推
07/13 16:22, , 1F
07/13 16:22, 1F
→
07/13 16:23, , 2F
07/13 16:23, 2F
→
07/13 16:30, , 3F
07/13 16:30, 3F
→
07/13 16:31, , 4F
07/13 16:31, 4F
推
07/13 16:55, , 5F
07/13 16:55, 5F
→
07/13 16:56, , 6F
07/13 16:56, 6F
→
07/13 17:05, , 7F
07/13 17:05, 7F
→
07/13 17:06, , 8F
07/13 17:06, 8F
→
07/13 17:08, , 9F
07/13 17:08, 9F
→
07/13 17:11, , 10F
07/13 17:11, 10F
→
07/13 17:11, , 11F
07/13 17:11, 11F
→
07/13 17:14, , 12F
07/13 17:14, 12F
→
07/13 17:15, , 13F
07/13 17:15, 13F
→
07/13 17:15, , 14F
07/13 17:15, 14F
→
07/13 17:18, , 15F
07/13 17:18, 15F
→
07/13 17:19, , 16F
07/13 17:19, 16F
推
07/13 17:34, , 17F
07/13 17:34, 17F
→
07/13 17:35, , 18F
07/13 17:35, 18F
→
07/13 17:38, , 19F
07/13 17:38, 19F
→
07/13 17:40, , 20F
07/13 17:40, 20F
→
07/13 17:40, , 21F
07/13 17:40, 21F
→
07/13 17:41, , 22F
07/13 17:41, 22F
→
07/13 17:42, , 23F
07/13 17:42, 23F
→
07/13 17:44, , 24F
07/13 17:44, 24F
→
07/13 17:51, , 25F
07/13 17:51, 25F
→
07/13 17:51, , 26F
07/13 17:51, 26F
→
07/13 17:53, , 27F
07/13 17:53, 27F
→
07/13 17:55, , 28F
07/13 17:55, 28F
推
07/16 01:53, , 29F
07/16 01:53, 29F
→
07/16 01:54, , 30F
07/16 01:54, 30F
→
07/16 01:56, , 31F
07/16 01:56, 31F
→
07/16 01:58, , 32F
07/16 01:58, 32F