package com.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.entity.BankCard;
public class BankImpl implements BankDao {
private Connection conn=null;
private PreparedStatement ptmt=null;
private ResultSet rs=null;
private BaseDao basedao=new BaseDao();
public BankCard findCardByUserid(String userid) {
BankCard bankcard=new BankCard();
try{
String sql="select * from Tbl_bank where userid=?";
conn=basedao.getConn();
ptmt=conn.prepareStatement(sql);
ptmt.setString(1, userid);
rs=ptmt.executeQuery();
if(rs.next()){
bankcard.setUserid(rs.getString(1));
bankcard.setMoney(rs.getFloat(2));
bankcard.setIsPay(rs.getInt(3));
}
}catch(Exception e){
e.printStackTrace();
}finally{
basedao.closeAll(rs, ptmt, conn);
}
return bankcard;
}
public int updateIspay(String userid) {
int i=0;
try{
String sql="update Tbl_bank set isPay=1 where userid=?";
conn=basedao.getConn();
ptmt=conn.prepareStatement(sql);
ptmt.setString(1, userid);
i=ptmt.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}finally{
basedao.closeAll(rs, ptmt, conn);
}
return i;
}
}
BankPro.rar （20个子文件） 
BankPro 
Bank_Data.MDF 1.63MB src com entity BankCard.java 672B dao BaseDao.java 920B BankDao.java 176B BankImpl.java 1KB Bank_Log.LDF 3.38MB .classpath 443B .mymetadata 294B .myeclipse .project 1KB WebRoot META-INF MANIFEST.MF 39B pay.jsp 648B index.jsp 729B result.jsp 618B doPay.jsp 764B doPost.jsp 918B WEB-INF classes com entity BankCard.class 1KB dao BankDao.class 220B BaseDao.class 1KB BankImpl.class 2KB lib web.xml 375B资源评论
政祥2017-09-29没有正式打开
