Servlet读出一条记录

CREATE DATABASE IF NOT EXISTS db_BlodMay default charset utf8 COLLATE utf8_general_ci; 

use db_BlodMay;

CREATE TABLE tb_consumer(
  id int(6) NOT NULL auto_increment,
  account varchar(50) default '#',
  password varchar(50) default NULL,
  name varchar(50) default '#',
  sex varchar(10) default 'M',
  QQNumber varchar(15) default NULL,
  mainPage varchar(50) default 'http',
  interest varchar(50) default 'no',
  eMail varchar(50) default 'a@b',
  manageLevel varchar(50) default 'http',
  KEY id (id)
) default charset=gb2312;

博客网站代码，用户登录部分，先按用户名读出数据库的所有字段，然后再比较从数据中读出的密码与表单中提交的密码

insert into tb_consumer(account,password,name,sex,qqNumber,mainPage,interest,eMail,manageLevel) values("liulixin","123","刘

利新","公","18802930979","www.188029.net","吃货","liulixin@facebook.com","admin")

//刘利新代码，加上关闭连接
    public void closeCon(){
    	 try{  
             if(con!=null){  
                 con.close(); 
                 System.out.println("closed");
             }  
         }catch(SQLException e){  
             System.out.println("关闭con对象失败！");  
             e.printStackTrace();  
         }  
    }

测试与数据库的连接：

package com.wy.tool;

public class test_con {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		JDBConnection k=new JDBConnection();
		k.creatConnection();
		k.closeCon();

	}

}

先不让servlet往jsp页面走

// 用户登录操作
	public void checkConsumer(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("gb2312");
		String account = request.getParameter("account");
		consumerDao = new ConsumerDao();
		ConsumerForm consumerForm = consumerDao.getConsumerForm(account);
		if (consumerForm == null) {
			request.setAttribute("information", "您输入的用户名不存在，请重新输入！");
		} else if (!consumerForm.getPassword().equals(
				request.getParameter("password"))) {
			request.setAttribute("information", "您输入的登录密码有误，请重新输入！");
		} else {

			request.setAttribute("form", consumerForm);
			System.out.println("user checked");
		}
		/*RequestDispatcher requestDispatcher = request
				.getRequestDispatcher("dealwith.jsp");
		requestDispatcher.forward(request, response);*/
	}

在后台看看读出的记录

// 以用户名为查询条件，查询一组数据
	public ConsumerForm getConsumerForm(String account) {
		String sql = "select * from tb_consumer where account='" + account
				+ "'";
		try {
			ResultSet rs = connection.executeQuery(sql);
			while (rs.next()) {
				consumerForm = new ConsumerForm();
				consumerForm.setId(Integer.valueOf(rs.getString(1)));
				System.out.println(rs.getString(1));
				//有爱，数据库第一字段是int
				consumerForm.setAccount(rs.getString(2));
				System.out.println(rs.getString(2));
				consumerForm.setPassword(rs.getString(3));
				System.out.println(rs.getString(3));
				consumerForm.setName(rs.getString(4));
				System.out.println(rs.getString(4));
				consumerForm.setSex(rs.getString(5));
				System.out.println(rs.getString(5));
				consumerForm.setQQNumber(rs.getString(6));
				System.out.println(rs.getString(6));
				consumerForm.setMainPage(rs.getString(7));
				System.out.println(rs.getString(7));
				consumerForm.setInterest(rs.getString(8));
				System.out.println(rs.getString(8));
				consumerForm.setEMail(rs.getString(9));
				System.out.println(rs.getString(9));
				consumerForm.setManageLevel(rs.getString(10));
				System.out.println(rs.getString(10));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return consumerForm;
	}

源代码：http://pan.baidu.com/share/link?shareid=2237420396&uk=3878681452