public void delete(string username)
{
string sql = "DELETE FROM \"USER\" WHERE USERNAME=@USERNAME";
using (iDB2Connection conn = new iDB2Connection(DB2Helper.ConnectionString))
{
conn.Open();
iDB2Parameter[] parms = new iDB2Parameter[] {
new iDB2Parameter("@USERNAME", username)
};
DB2Helper.ExecuteNonQuery(conn, CommandType.Text, sql, parms);
}
}
public void update(User user)
{
string sql = "UPDATE \"USER\" SET PASSWORD=@PASSWORD WHERE USERNAME=@USERNAME";
using (iDB2Connection conn = new iDB2Connection(DB2Helper.ConnectionString))
{
conn.Open();
iDB2Parameter[] parms = new iDB2Parameter[] {
new iDB2Parameter("@PASSWORD", user.password),
new iDB2Parameter("@USERNAME", user.username)
};
DB2Helper.ExecuteNonQuery(conn, CommandType.Text, sql, parms);
}
}
public void create(User user)
{
string sql = "INSERT INTO \"USER\"(USER_NO,USERNAME,PASSWORD) VALUES(@USER_NO,@USERNAME,@PASSWORD)";
using (iDB2Connection conn = new iDB2Connection(DB2Helper.ConnectionString))
{
conn.Open();
long userNo = DB2Helper.GetSequence(conn, "USER");
iDB2Parameter[] parms = new iDB2Parameter[] {
new iDB2Parameter("@USER_NO", userNo),
new iDB2Parameter("@USERNAME", user.username),
new iDB2Parameter("@PASSWORD", user.password)
};
DB2Helper.ExecuteNonQuery(conn, CommandType.Text, sql, parms);
}
}