ÓÃ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
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÔÊý¾Ý
ÉÌÆ· Ô¼Û ´òÕÛ·½Ê½1 ÕÛ¿Û1 ´òÕÛ·½Ê½2 ÕÛ¿Û2
±Ê¼Ç±¾ 10000 NULL 0 NULL&nb ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE
ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......