java Resources/src/user/User.java
package user;

public class User {
  private String userID;
  private String userPassword;
 
 
public String getUserID() {
return userID;
}
public void setUserID(String userID) {
this.userID = userID;
}
public String getUserPassword() {
return userPassword;
}
public void setUserPassword(String userPassword) {
this.userPassword = userPassword;
}
 
 
}



java Resources/src/user/UserDAO.java

package user;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class UserDAO {
private  Connection conn;
private PreparedStatement pstmt;
private ResultSet rs;

public UserDAO() {

try {
String dbURL      = "jdbc:mysql://127.0.0.1:3306/bbs";
String dbID      = "root";
String dbPassword = "1111";
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(dbURL,dbID,dbPassword);
//System.out.println("데이타베이스 연결 성공");

} catch (Exception e) {
//System.out.println("데이타베이스 연결 오류!!!!!!!");
e.printStackTrace();
}
}

public int login(String userID, String userPassword) {
String SQL = "select userPassword from bbs where userID = ?";
try {
pstmt = conn.prepareStatement(SQL);
pstmt.setString(1, userID);
rs = pstmt.executeQuery();
if(rs.next()) {
if(rs.getString(1).contentEquals(userPassword)) {
return 1; //로그인 성공
}
else
return 0; //불일치
}
return -1;
} catch (Exception e) {
e.printStackTrace();
}
return -2; //데이터베이스 오류
}
}


#jsp