userdaoimpl.java

一个经典购物车（shoppingcart）实例代码

package com.jpioneer.application.user.dao.impl;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import com.jpioneer.application.user.dao.UserDao;
import com.jpioneer.application.util.DBCon;

public class UserDaoImpl implements UserDao {

	public boolean Login(String loginId, String password) throws Exception{
		Connection con=DBCon.getCon();
		Statement stm=con.createStatement();
		String sql="select count(*) from users where loginId='"+loginId+"' and password='"+password+"'";
		ResultSet rs=stm.executeQuery(sql);
		rs.next();
		boolean flag=false;
		if(rs.getInt(1)>0){
			flag=true;
		}
		return flag;
	}
}