提前感謝有時間看的大佬
提示 錯誤1 com.heboc.dao.UserinfoDao.login(UserinfoDao.java:21)
2. com.heboc.controller.Login.doPost(Login.java:62)
代碼
package com.heboc.dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class UserinfoDao {
/**
*
* @param username
* @param password
* @return
*/
public boolean login(String username,String password){
boolean flag = true;
Connection conn = ConnFactory.getConn();
try {
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM userinfo WHERE username='"+username+"' AND PASSWORD='"+password+"' ";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
flag = true;
}else{
flag = false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
flag = false;
}
ConnFactory.closeConn(conn);
return flag;
}
/**
*
* @param username
* @param password
* @param email
* @return
*/
public boolean register(String username,String password,String email){
boolean flag = true;
Connection conn = ConnFactory.getConn();
try {
Statement stmt = conn.createStatement();
String sql = "INSERT INTO userinfo (username, PASSWORD,email ) VALUES ('"+username+"', '"+password+"','"+email+"')";
flag = stmt.execute(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
flag = false;
}
ConnFactory.closeConn(conn);
return flag;
}
public Userinfo findById(int id){
Userinfo user = null;
Connection conn = ConnFactory.getConn();
try {
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM userinfo WHERE id='"+id+"' ";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
String username = rs.getString("username");
String password = rs.getString("password");
String email = rs.getString("email");
user = new Userinfo(id,username, password, email);
//user.setId(id);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ConnFactory.closeConn(conn);
return user;
}
}
代碼2
package com.heboc.controller;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.heboc.dao.UserinfoDao;
public class Login extends HttpServlet {
/**
* Constructor of the object.
*/
public Login() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String username=request.getParameter("username");
String password=request.getParameter("password");
UserinfoDao dao=new UserinfoDao();
boolean f=dao.login(username, password); （@@@@@@@@@錯誤）
if(f){
System.out.println("登陸成功");
response.sendRedirect("main.jsp");
}else{
System.out.println("登陸失敗");
response.sendRedirect("failed.jsp");
}
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
uj5u.com熱心網友回復：
貼錯誤資訊出來才好定位。uj5u.com熱心網友回復：
hibernate 查詢是查詢物件，你這個select * 是不對的，因為hibernate將物體和表已經映射了。uj5u.com熱心網友回復：
把資料庫組態檔貼出來，不然看不出資料庫鏈接是否正常。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/59200.html
標籤：Eclipse
上一篇：請求sockjs錯誤