asp.net Ö´ÐÐupdateÓï¾äʱ oracleÊý¾Ýʱû·´Ó¦
Default.aspx
protected void LinkButton1_Click(object sender, EventArgs e)
{
int i= DBHelper.ExecuteSql("update Leather_qty_t set qty='100.0' where stock_id=7 and grade='A'");
this.LinkButton1.Text = i.ToString();
}
DBHelper.cs
public static int ExecuteSql(string sqlString)
{
using (OracleConnection connection = new OracleConnection(connString))
{
using (OracleCommand cmd = new OracleCommand(sqlString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();//µ½ÕâÀï¾ÍͣסÁË.È»ºó¾ÍûÓз´Ó¦..Ò²²»±¨´í!!!!
return rows;
}
Ïà¹ØÎÊ´ð£º
·þÎñÆ÷ÏÖÔÚÊÇ¡£net 2.0µÄ
ÎÒÏÖÔÚµÄÏîÄ¿¾ÍÊÇasp.net mvc + linqµÄ£¬ÏÖÔÚ·þÎñÆ÷µÄ»·¾³ÅäÖÃÓò»ÁË¡£
²»ÖªµÀÓÐǰ±²Åöµ½¹ýÕâÑùµÄÎÊÌâû¡£
ÄѵÀ·þÎñÆ÷±ØÐëҪװ.net3.5 ºÍ asp.net mvc
Çëǰ±²Ö¸µã
²»×°ÄãÈÏΪÄãÒªÔõô ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......