mysqlhelper.java

来自「本方案是在与***信息技术（北京）有限公司相关人员协商并分析了北京****投资有」· Java 代码 · 共 46 行

package com.test.dao.sqlhelp;

import java.sql.Date;

import com.test.model.LoginBean;
import com.test.model.UserBean;

/**
 * 字符串提供类，mysql的实现
 * 
 * @author pwf
 * @version 1.0 2008.4.14
 */
public class MySqlHelper implements ISqlHelper {

	public String createGetUserByPk_idText(String pk_id) {
		return "select str_c,signtime,pk_id from build where pk_id = "+pk_id;
	}

	// 添加用户
	public String createSaveUserText() {
		return "insert into insert_info(username,str_a,str_b) values(?,?,?)";
	}

	// 根据条件查询用户
	public String createFillUserByPk_idText() {
		return "select username,str_a,str_b,state,state_now  from insert_info where pk_id=?";
	}

	public String createGetAdminsText() {
		return "select u.user_id,u.username,u.password,r.state,r.state_pwf,r.state_lb from user_info u,role_info r where u.user_id = r.role_id";
	}

	public String createUpdataUserStateText(LoginBean admin) {
		return "update user_info set username='"+admin.getUsername()+"' where user_id="+admin.getUser_id();
	}

	public String createUpdateUserRoleText(LoginBean admin) {
		return "update role_info set state="+admin.isLogout()+",state_pwf="+
		admin.isState_pwf()+",state_lb="+admin.isState_lb()+" where role_id="+
		admin.getUser_id();
	}
	

}