Question

急！！从字符串向datetime转换时失败！！

public int tb_EmpInfoAdd(tb_EmpInfo Empinfo)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_EmpInfo values( ";
str_Add+=" '"+Empinfo.intEmpId+"','"+Empinfo.strEmpName+"','"+Empinfo.strEmpLoginName+"',";
str_Add+=" '"+Empinfo.strEmpLoginPwd+"','"+Empinfo.intEmpSex+"','"+Empinfo.daEmpBirthday+"',";
str_Add+=" '"+Empinfo.strEmpDept+"','"+Empinfo.strEmpPost+"','"+Empinfo.strEmpPhone+"',";
str_Add+=" '"+Empinfo.strEmpPhoneM+"','"+Empinfo.strEmpAddress+"',";
str_Add+=""+Empinfo.intEmpFalg+")";
getSqlConnection getConnection = new getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Add,conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return intFalg;

}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return intFalg;

}
}

Answer 1

public int tb_EmpInfoAdd(tb_EmpInfo Empinfo)
{
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
int intFalg = 0;
try
{
String str_Add = "insert into tb_EmpInfo values( ";
str_Add+=" '"+Empinfo.intEmpId+"','"+Empinfo.strEmpName+"','"+Empinfo.strEmpLoginName+"',";
str_Add+=" '"+Empinfo.strEmpLoginPwd+"','"+Empinfo.intEmpSex+"','"+formatter.format(Empinfo.daEmpBirthday)+"',";
str_Add+=" '"+Empinfo.strEmpDept+"','"+Empinfo.strEmpPost+"','"+Empinfo.strEmpPhone+"',";
str_Add+=" '"+Empinfo.strEmpPhoneM+"','"+Empinfo.strEmpAddress+"',";
str_Add+=""+Empinfo.intEmpFalg+")";
getSqlConnection getConnection = new getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Add,conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return intFalg;
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return intFalg;
}
}

Answer 2

java的日期转String
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String dateString = formatter.format(Empinfo.daEmpBirthday);

你那么直接连接虽然编译通过，但实际上格式不被认识

追问

额。。。没怎么懂，具体怎么改，这个放在哪啊

追答

执行
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String dateString = formatter.format(Empinfo.daEmpBirthday);

然后 用dateString 替换里面的 Empinfo.daEmpBirthday