sql×¢Èë - .NET¼¼Êõ / C#
ÎÒдÁËÒ»¸öÓû§×¢²áºóÊý¾Ý´æÈëÊý¾Ý¿â£¬¿ÉÊǾÍÊÇ´æ²»½øÈ¥
ÏÂÃæÊÇ´úÂ룺string sql = "";
Óû§ user = new Óû§();
user.Name = textBox1.Text;
user.MiMa = textBox2.Text;
user.QMiMa = textBox3.Text;
user.Sex = comboBox1.Text;
user.Age = Convert.ToInt16(textBox4.Text);
if (user.Name != null)
{
if (user.MiMa != null)
{
if (user.MiMa == user.QMiMa)
{
sql = "insert into user(Óû§Ãû,ÃÜÂë,ÄêÁä,ÐÔ±ð) values ('" + textBox1.Text + "'," + Convert.ToInt16(textBox2.Text) + "," + Convert.ToInt16(textBox4.Text) + ",'" + comboBox1.Text + "')";
OleDbCommand command = new OleDbCommand(sql,con );
con.Open();
int num = Convert.ToInt32(command.ExecuteNonQuery());
if (num == 1)
{
this.Close();
}
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......