库存管理

[c]代码库
CsmsCode.rar(免费下载)[0 次下载]
package com.CsmsCode.Dao;
 
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
import com.CsmsCode.DB.DBConnection;
import com.CsmsCode.VO.UserVo;
 
public class UserDao {
     
     
    public int login(String userLogin,String userPwd) throws ClassNotFoundException, SQLException
    {
         
         
        StringBuffer strSql=new StringBuffer();
        strSql.append("select count(*) from users where userLogin='"+userLogin+"' and userPwd='"+userPwd+"'");
         
        int r=0;
        DBConnection db=new DBConnection();
        Connection conn=db.getConnection();
         
        PreparedStatement pst=conn.prepareStatement(strSql.toString());
         
        ResultSet rs= pst.executeQuery();
         
        while (rs.next())
        {
            r=rs.getInt("count(*)");
        }
         
        return r;
         
    }
     
    public List<UserVo> getUsers(String userLogin,String userName) throws ClassNotFoundException, SQLException
    {
        StringBuffer strSql=new StringBuffer();
         
        strSql.append("select * from users where 1=1 ");
         
        if (!userLogin.equals(""))
        {
             
            strSql.append(" and userLogin='"+userLogin+"' ");
        }
         
        if (!userName.equals(""))
        {
             
            strSql.append(" and userName='"+userName+"'");
        }
         
        DBConnection db=new DBConnection();
        Connection conn=db.getConnection();
        PreparedStatement pst=conn.prepareStatement(strSql.toString());
        ResultSet rs= pst.executeQuery();
         
        List<UserVo> users=new ArrayList<UserVo>();
         
        while (rs.next())
        {
            UserVo myUser=new UserVo();
            myUser.setFlag(rs.getInt("flag"));
            myUser.setUserLogin(rs.getString("userLogin"));
            myUser.setUserName(rs.getString("userName"));
            myUser.setUserNote(rs.getString("userNote"));
            myUser.setUserPwd(rs.getString("userPwd"));
            users.add(myUser);
             
        }
         
        return users;
          
         
    }
     
     
    public void addUser(UserVo uservo) throws ClassNotFoundException, SQLException
    {
        StringBuffer strSql=new StringBuffer();
        strSql.append("insert into users values ('"+uservo.getUserLogin()+"','"+uservo.getUserName()+"','"+uservo.getUserNote()+"','"+uservo.getUserPwd()+"','0)");
         
        DBConnection db=new DBConnection();
        Connection conn=db.getConnection();
         
        PreparedStatement pst=conn.prepareStatement(strSql.toString());
        pst.executeUpdate();
         
    }
     
    public void updateUser(UserVo uservo) throws ClassNotFoundException, SQLException
    {
        StringBuffer strSql=new StringBuffer();
        strSql.append("update users set userName='"+uservo.getUserName()+"',userPwd='"+uservo.getUserPwd()+"',userNote='"+uservo.getUserNote()+"'where userLogin='"+uservo.getUserLogin()+"'");
         
        DBConnection db=new DBConnection();
        Connection conn=db.getConnection();
         
        PreparedStatement pst=conn.prepareStatement(strSql.toString());
        pst.executeUpdate();
         
    }
     
    public void delUser(String userLogin) throws ClassNotFoundException, SQLException
    {
        StringBuffer strSql=new StringBuffer();
        strSql.append("delete from users where userLogin='"+userLogin+"' ");
         
        DBConnection db=new DBConnection();
        Connection conn=db.getConnection();
         
        PreparedStatement pst=conn.prepareStatement(strSql.toString());
        pst.executeUpdate();
         
    }
 
     
 
}
[源代码打包下载]
CsmsCode.rar(免费下载)[0 次下载]
用户注册

用户登录

发表随想

该用户最新代码

编程随想

[c]代码库

[源代码打包下载]

网友评论 (发表评论)

发表评论：

评论须知：

扫码下载

输入口令后可复制整站源码
