Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃ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


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

ÇóÒ»SQLÓï¾ä

Ô­Êý¾Ý

ÉÌÆ·    Ô­¼Û    ´òÕÛ·½Ê½1  ÕÛ¿Û1    ´òÕÛ·½Ê½2  ÕÛ¿Û2
±Ê¼Ç±¾  10000  NULL        0      NULL&nb ......

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......

OracleÖвéѯ×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¿

ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE


ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ