如何将以下代码片段从C＃转换为java [英] How can I convert the below code snippet from C# to java

问题描述

private DataSet ds = new DataSet();
 private SqlDataAdapter dbAdapter = new SqlDataAdapter();
  public usertype Getuser(int sCode)
        {
            usertype tuser = new usertype();

            BuildConnstring();

            using (SqlConnection conn = new SqlConnection(connstring))
            {
                using (SqlCommand Command = conn.CreateCommand())
                {
                    conn.Open();
                    Command.CommandText = "select * from sys_user where user_id='" + sCode + "'";
                    Command.CommandType = CommandType.Text;
                    dbAdapter.SelectCommand = Command;
                    ds.Clear();
                    ds.DataSetName = "User";
                    dbAdapter.Fill(ds);
                }
            }
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
                    {
                        tuser = new usertype();
                        tuser.staff_id = Convert.ToInt32(ds.Tables[0].Rows[i]["staff_id"]);
                        tuser.user_id = Convert.ToInt32(ds.Tables[0].Rows[i]["user_id"]);
                        tuser.User_name = ds.Tables[0].Rows[i]["User_name"].ToString();
                        tuser.user_pin = ds.Tables[0].Rows[i]["user_pin"].ToString();
                        tuser.staff_sir_name = ds.Tables[0].Rows[i]["staff_sir_name"].ToString();
               
                    }
                }
            }
            else
            {
                tuser = new usertype();
                tuser.user_id = 0;
            }


            return tuser;
        }

我的尝试：



试图使用转换器低于

What I have tried:

have tried to use converter getting below

if (ds.Tables.size() > 0)
            if (rs. > 0)
        {
            if (ds.Tables[0].Rows.size() > 0)
            {
                for (int i = 0; i <= ds.Tables[0].Rows.size() - 1; i++)
                {
                   //usertype tuser;
                    tuser.getstaff_id()= (int)(ds.Tables[0].Rows[i]["staff_id"]);
                    tuser.getuser_id()= (int)(ds.Tables[0].Rows[i]["user_id"]);
                    tuser.getUser_name()= ds.Tables[0].Rows[i]["User_name"].toString();
                    tuser.getuser_pin()= ds.Tables[0].Rows[i]["user_pin"].toString();
                    tuser.getstaff_sir_name()= ds.Tables[0].Rows[i]["staff_sir_name"].toString();

推荐答案

Quote：

我无法在java中声明数据集

am not able to declare Dataset in java

请参阅： DataSet [ ^ ]

这篇关于如何将以下代码片段从C＃转换为java的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！