カテゴリー: Servlet/JSP

Statement smt = con.createStatement();
int count = smt.executeUpdate("UPDATE account SET MONEY=4000");

プリペアードステイトメントを使うと

String sql = "insert into user (userNo,userName) values(?,?)";
PreparedStatement ps = con.prepareStatement(sql);

ps.setInt(1, userNo);
ps.setString(2, userName);

ps.executeUpdate();

Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost/education", "root", "pathword");

閉じるには

con.close();

セッションを取得しオブジェクトをセット

HttpSession session = request.getSession();
session.setAttribute("player", player);

取得側の処理

HttpSession session = request.getSession();
Player player = (Player)session.getAttribute("player");

RequestDispatcher dispatcher = request.getRequestDispatcher("/index.jsp");
dispatcher.forward(request, response);

request.setCharacterEncoding("UTF-8");
response.setContentType("text/plain; charset=UTF-8");