userdao.java~3~

java,酒店管理系统, 单机版程序,适合小型应用

package jiudian.db.dao;

  import java.sql.*;
  import java.util.*;
  import jiudian.db.dto.*;

public class UserDAO {
    String driver = "org.gjt.mm.mysql.Driver";
    String url = "jdbc:mysql://localhost:3306/dstore";
    String username = "root";
    String password = "111111";

    public void createUser(UserDTO user)
    {
        Connection con=null;
        Statement stmt=null;
        ResultSet rs=null;

        try{
            Class.forName(driver);
            con = DriverManager.getConnection(url,username,password);
            String sql="insert into user (userId,username,password,name) values("
                   +    user.getUserId() + "'"
                   + "'" + user.getUsername() + "'" + "'"
                   + "'" + user.getPassword() + "'" + "'"
                   + "'" + user.getName() + "'" + "'"
                   +")";
        stmt = con.createStatement();
        stmt.execute(sql);
        }
        catch(Exception sqlexl)
        {
            sqlexl.printStackTrace();
        }
        finally
        {
            if (con !=null){
            try {
                con.close();
            }
            catch(SQLException sqlex2)
            {
                sqlex2.printStackTrace();
            }
            }
            }
        }
    }

public void updateUser(UserDTO user)
    {
        Connection con=null;
       Statement stmt=null;
       ResultSet rs=null;

       try{
           Class.forName(driver);
           con = DriverManager.getConnection(url,username,password);
           String sql ="updata user set"
                       + "username='" + user.getUsername() + "',"
                       + "password ='" + user.getPassword() + "',"
                       + "name" + user.getName() + "',"
                       + " where userId = " +user.getUserId()
                       ;
           stmt = con.createStatement();
           stmt.executeUpdata(sql);
       }

    }