ÓÃsqlÊä³öÕýÏÒÇúÏß
¾Íµ±»îÔ¾»îÔ¾Æø·Õ°É~
sf
²»ºÃÒâ˼.ÔÀ´ÊǼ¼ÊõÌû.
·¹ý
Ç¿´ó
¸ßÊÖÃDz»Áߨĵϰ ÓÃsqlдд°É
C# code:
//c#µÄ
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
int x1, x2, y1, y2;
Boolean ht = false;//ÅжÏÊÇ·ñ°´ÏÂÊó±ê×ó¼ü£¬Ä¬ÈÏΪûÓа´¼ü
Boolean dr = true; //ÅжÏÊÇ·ñÒѾÏÔʾÇúÏߣ¬Ä¬ÈÏΪÏÔʾ
public Form1()
{
InitializeComponent();
}
/// <summary>
/// Êó±êµ¥»÷ʼþ·½·¨
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form1_MouseDown(object sender, MouseEventArgs e)
{
//sinline();
x1 = e.X; //»ñÈ¡µã»÷´¦µÄ×ø±êXÖµ
y1 = e.Y; //»ñÈ¡µã»÷´¦µÄ×ø±êYÖµ
ht = true; //¸³ÖµÎªÕ棬֤Ã÷ÒѾ°´ÏÂ×ó¼ü
if (dr == true) //ÅжÏÏÔʾÇúÏßµÄÌõ¼þÊÇ·ñÎªÕæ£¬Èç¹ûÎªÕæÔòÇå³þÊó±êËù»µÄ¸÷ÖÖͼÐÎ
{
Graphics g = this.Crea
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2   ......
Èç¹ûÓÃsqlÓï¾ä¸ü¸Älj×ֶεÄ·¾¶£¬ÈçÏ£º
lj
7/200781616183095962.jar
8/f_200812111413292.jar
8/f_200812111413291.jar
µÃµ½µÄ½á¹ûÈçÏ£º
lj
1/7/200781616183095962.jar
1/8/f_20081 ......