ibatis简单登陆

po

package po;

import java.io.Serializable;

public class User implements Serializable {

private static final long serialVersionUID = 1L;

private String username;
private String password;

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}
}

po映射

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"     
    "\\WEB-INF\\sql-map-2.dtd">

<sqlMap>

  <select id="selectlogin" parameterClass="po.User" resultClass="po.User">
    select username,password from user where username = #username# and password = #password#
  </select>
 
</sqlMap>


servlet

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import po.User;
import dao.Cilent;

public class Login extends HttpServlet {

private static final long serialVersionUID = 1L;

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
User user = new User();
user.setUsername(request.getParameter("username"));
user.setPassword(request.getParameter("password"));
Cilent cil = new Cilent();
Boolean bool = cil.loginValidate(user);

if(bool){
response.sendRedirect("success.jsp");
}
else
response.sendRedirect("login.jsp");
}
}

dao

package dao;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;

import po.User;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class Cilent {

public static SqlMapClient sqlMapper = null;
public static Reader reader;

public Cilent(){
try {
reader = Resources.getResourceAsReader("SqlMapConfig.xml");
sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
} catch (IOException e) {
e.printStackTrace();
}
}

public boolean loginValidate(User user) {
try {
List<User> list = sqlMapper.queryForList("selectlogin", user);
for (Iterator<User> it = list.iterator(); it.hasNext();) {
User user1 = new User();
user1 = it.next();
if (user1 != null)
return true;
}
} catch (SQLException e) {
e.printStackTrace();
}

finally {
try {
reader.close();
} catch (IOException e) {
e.printStackTrace();
}
}
return false;
}
}


<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMapConfig     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"     
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

  <transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/ibatis"/>
      <property name="JDBC.Username" value="root"/>
      <property name="JDBC.Password" value="root"/>
    </dataSource>
  </transactionManager>

  <sqlMap resource="po/User.xml"/>

</sqlMapConfig>