亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

在servlet中添加進行數據庫操作的語句怎么寫(寫了很多都不能運行)

在servlet中添加進行數據庫操作的語句怎么寫(寫了很多都不能運行)

楓夜流螢 2017-12-06 17:50:39
package Servlet;import java.io.IOException;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import Dao.loginDao;public class loginServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); String method= request.getParameter("method"); if ("login".equals(method)) { login(request, response); } } public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String user=request.getParameter("user"); String password=request.getParameter("password"); System.out.println(user); System.out.println(password); loginDao ld = new loginDao(); //boolean login = userDaoImpl.login(userID, passWord); if (1 == 1) { //HttpSession session = request.getSession(); //session.setAttribute("userID", userID); //session.setAttribute("passWord", passWord); request.getRequestDispatcher("index.jsp").forward(request, response); }else { request.getRequestDispatcher("fail.jsp").forward(request, response); } ? ?} ? public void find (HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { ? HttpSession session = request.getSession(); ? ? String userID = (String)session.getAttribute("userID"); ? ? ? ? }} package Dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import Bean.login;import Util.DBUtil;public class loginDao { public static Bean.login login(String user) throws SQLException{ ? ? ? ? ? ? //static Bean.login根據提示修改 String sql = "select * from user where user_name ='" +user+"'"; Connection con = DBUtil.getConnection(); Statement stmd = con.prepareStatement(null); ResultSet rs = stmd.executeQuery(sql); while(rs.next()){ login u = new login(); ? ? u.setUser(rs.getString("user")); ? ? u.setPassword(rs.getString("password")); ? ? return null; } return null; }}
查看完整描述

1 回答

?
產品經理不是經理

TA貢獻481條經驗 獲得超143個贊

你用PreparedStatement對象,你的sql語句怎么還在拼接額。

查看完整回答
反對 回復 2017-12-06
  • 楓夜流螢
    楓夜流螢
    這樣寫不行嗎,那應該怎么寫
  • 產品經理不是經理
    產品經理不是經理
    String sql = "select * from user where user_name = ?"; Connection con = DBUtil.getConnection(); Statement stmd = con.prepareStatement(sql); stmd.setString(1,user); ResultSet rs = stmd.executeQuery(sql);
  • 1 回答
  • 0 關注
  • 3334 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號