您的位置：程序门 -> .net技术 -> j#

operation db

[收藏此页] [打印本页]选择字色：背景色：字体：[大][中][小]

operation db

发表于：2007-09-06 00:34:06 楼主

using system;
using system.data;
using system.collections;
using system.text;
using system.data.sqlclient;
using system.configuration;

namespace accessdb
{
/// <summary>
/// class1 偺奣梫偺愢柧偱偡丅
/// </summary>
public class commondb
{
//db愙懕傪奐偗傞
public string connectstring = "server=192.168.1.88;database=java;uid=sa;pwd=sa ";
public commondb（)
{
//
// todo: 僐儞僗僩儔僋僞儘僕僢僋傪偙偙偵捛壛偟偰偔偩偝偄丅
//
}

private void preparecommand（sqlcommand i_cmd, sqlconnection i_conn,
sqltransaction i_trans, commandtype i_cmdtype,
string i_cmdtext, sqlparameter[] i_cmdparms)
{

//db愙懕傪僙僢僩
if （i_conn.state != connectionstate.open)
{
i_conn.open（);
}
i_cmd.connection = i_conn;
// sql暥傪僙僢僩
i_cmd.commandtext = i_cmdtext;

// 僩儔儞僓僋僔儑儞傪僙僢僩
if （i_trans != null)
{
i_cmd.transaction = i_trans;
}

// commandtype傪僙僢僩
i_cmd.commandtype = i_cmdtype;

// 僷儔儊乕僞傪僙僢僩
if （i_cmdparms != null)
{
foreach （sqlparameter parm in i_cmdparms)
{
if （parm.value == null)
{
parm.value = string.empty;
}
i_cmd.parameters.add（parm);
}
}

}

public int updatedb（sqltransaction trans , stringbuilder strsql, sqlparameter[] parms)
{

// 僋僄儕懳徾傪弶婜壔
sqlcommand i_cmd = new sqlcommand（);
// db愙懕傪奐偗傞
sqlconnection conn = new sqlconnection（connectstring);

// 僋僄儕懳徾傪弨旛
preparecommand（i_cmd, trans.connection, trans, commandtype.text, strsql.tostring（), parms);
//僋僄儕傪幚峴丄偦偟偰db愙懕傪暵傔傞
return i_cmd.ＥＸＥＣutenonquery（);

}

public sqldatareader select（stringbuilder sqltext, sqlparameter[] sqlparameter)
{
sqlcommand i_cmd = new sqlcommand（);
sqldatareader result = null;
sqlconnection conn = new sqlconnection（connectstring);
try
{
// 僋僄儕懳徾傪弨旛
preparecommand（i_cmd, conn, null , commandtype.text ,sqltext.tostring（), sqlparameter);
result = i_cmd.ＥＸＥＣutereader（);
}
catch （exception exc)
{
if （conn.state == connectionstate.open)
{
conn.close（);

}
throw exc;
}
finally
{
}
return result;
}

public string getvalue（sqldatareader i_rdr, string i_string )
{
string strret = string.empty;
try
{
if （convert.isdbnull（i_rdr[i_string]) == false)
{
strret = convert.tostring（i_rdr[i_string]);
}
}
catch
{
return " ";
}
return strret;
}
}
}

发表于：2007-09-06 00:37:141楼得分:0

commondb accessdb = new commondb（);

string code = textbox1.text.trimend（);

stringbuilder strsql = new stringbuilder（);
strsql.append（ " select name from javatmp ");
strsql.append（ " where ");
strsql.append（ " code = @code ");

//僷儔儊乕僞惗惉
sqlparameter[] parms = {
new sqlparameter（ "@code ", code)
};

sqldatareader result = accessdb.select（strsql, parms);
if （result.read（))
{
textbox2.text = accessdb.getvalue（result, "name ");
}
else
{
messagebox.show （ "奩摉僨乕僞偑懚嵼偟傑偣傫丅 ");
}

}

发表于：2007-09-06 00:40:432楼得分:0

private void button2_click（object sender, system.eventargs e)
{
commondb accessdb = new commondb（);

string code = textbox1.text.trimend（);
string name = textbox2.text.trimend（);

stringbuilder strsql = new stringbuilder（);
strsql.append（ " update javatmp set name = @name ");
strsql.append（ " where ");
strsql.append（ " code = @code ");

//僷儔儊乕僞惗惉
sqlparameter[] parms = {
new sqlparameter（ "@code ", code),
new sqlparameter（ "@name ", name)
};

sqltransaction trans = null;
sqlconnection conn = new sqlconnection（accessdb.connectstring);
try
{
conn.open（);
trans = conn.begintransaction（);
int i = accessdb.updatedb（trans, strsql, parms);
trans.commit（);
textbox1.text = " ";
textbox2.text = " ";
messagebox.show （ "峏怴偟傑偟偨丅 ");
}
catch （exception ex)
{
system.console.writeline（ex.tostring（));
trans.rollback（);
}
finally
{
conn.close（);
}
}

发表于：2007-09-15 23:46:443楼得分:0

学习中～

发表于：2007-09-17 17:09:494楼得分:0

偷偷飘过~

其他资讯