package db.dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Locale;
import javabean.User;
import db.DBManager;
public class UserDao {
private static SimpleDateFormat _DateFormat = new SimpleDateFormat( " yyyy-MM-dd HH:mm:ss " );
public UserDao(){
}
public User findUser(String id,String pwd){
DBManager dbm = new DBManager();
Connection con = dbm.makeCon();
String sql = "select * from MTP_USER_TAB where USER_ID='"+id+
"' and USER_PWD='"+pwd+"'";
ResultSet rs = null;;
User user = null;
try {
rs = con.prepareStatement(sql).executeQuery();
if(rs.next()){
user = new User();
user.setUSER_ID(rs.getString("USER_ID"));
user.setUSER_PWD(rs.getString("USER_PWD"));
user.setUSER_STATUS(rs.getString("USER_STATUS"));
user.setUSER_NAME(rs.getString("USER_NAME"));
user.setUSER_CERT_ID(rs.getString("USER_CERT_ID"));
user.setREG_SP_STATUS(rs.getString("REG_SP_STATUS"));
user.setUSER_BALANCE(rs.getFloat("USER_BALANCE"));
user.setUPDATE_DATE(rs.getString("UPDATE_DATE"));
user.setLOGIN_DATE(rs.getString("LOGIN_DATE"));
}
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
dbm.closeCon();
return user;
}
public void updateLoginDate(String id){
DBManager dbm = new DBManager();
Connection con = dbm.makeCon();
Calendar ca = Calendar.getInstance(Locale.CHINA);
String sql = "update MTP_USER_TAB set LOGIN_DATE=TO_DATE('"+_DateFormat.format(ca.getTime())+"','YYYY-MM-DD HH24:MI:SS')where USER_ID='"+id+"'";
System.out.println(sql);
try {
System.out.println("开始更新........");
con.prepareStatement(sql).executeUpdate();
System.out.println("结束更新........");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
dbm.closeCon();
}
public boolean updatePw(String id,String pw){
DBManager dbm = new DBManager();
Connection con = dbm.makeCon();
String sql = "update MTP_USER_TAB set USER_PWD='"+pw+"' where USER_ID='"+id+"'";
int count = 0;
try {
count = con.prepareStatement(sql).executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(count!=0){
return true;
}else{
return false;
}
}
}
mtp_c.rar （46个子文件） 
mtp_c mtp_c 
.project 1KB .settings .jsdtscope 500B org.eclipse.wst.jsdt.ui.superType.container 49B org.eclipse.wst.jsdt.ui.superType.name 6B .mymetadata 288B WebRoot login.jsp 1KB css style.css 4KB updatePwdSuccess.jsp 846B WEB-INF web.xml 622B lib 
classes12.jar 1.52MB classes javabean User.class 2KB page PageBean.class 259B db dao UserDao.class 3KB DBManager.class 1KB table testdate.sql 902B alltable.sql 4KB webapplication page action UpdatePwdAction.class 2KB LoginAction.class 2KB BalanceAction.class 1KB LogoutAction.class 807B factory ActionFactory.class 2KB controller CServlet.class 2KB filter AthenticationFilter.class 2KB META-INF MANIFEST.MF 36B updatePwd.jsp 1KB balance.jsp 607B src javabean db dao table alltable.sql 4KB webapplication page action factory controller filter AthenticationFilter.java 122B main.jsp 1KB images 
login.gif 64KB
top.jpg 79KB js calendar.js 13KB .myeclipse src javabean User.java 2KB page PageBean.java 47B db dao UserDao.java 2KB DBManager.java 825B table testdate.sql 902B alltable.sql 4KB webapplication page action LoginAction.java 2KB BalanceAction.java 713B UpdatePwdAction.java 2KB factory ActionFactory.java 1KB LogoutAction.java 428B controller CServlet.java 2KB filter AthenticationFilter.java 1KB .classpath 434B
- 1
- 2
前往页