ѧ Éú ʵ Ñé ±¨ ¸æ
¿Î³ÌÃû³Æ£º
ѧÉúѧºÅ£º
ËùÊôÔº²¿£º
£¨Àí¹¤Àࣩ
Èí¼þÌåϵ½á¹¹ רҵ°à¼¶£º13Èí¼þ¹¤³Ì2°à 1305104067 ѧÉúÐÕÃû£º »Æ¿É·Ç
Èí¼þ¹¤³ÌѧԺ Ö¸µ¼½Ìʦ£º ³ÂÊ¥¹ú
20 15 ¡ª¡ª20 16 ѧÄê µÚ 1 ѧÆÚ
½ðÁê¿Æ¼¼Ñ§Ôº½ÌÎñ´¦ÖÆ
ʵÑ鱨¸æÊéдҪÇó
ʵÑ鱨¸æÔÔòÉÏÒªÇóѧÉúÊÖд£¬ÒªÇóÊéд¹¤Õû¡£ÈôÒò¿Î³ÌÌØµãÐè´òÓ¡µÄ£¬Òª×ñÕÕÒÔÏÂ×ÖÌå¡¢×ֺš¢¼ä¾àµÈµÄ¾ßÌåÒªÇó¡£Ö½ÕÅÒ»ÂɲÉÓÃA4µÄÖ½ÕÅ¡£
ʵÑ鱨¸æÊéд˵Ã÷
ʵÑ鱨¸æÖÐÒ»ÖÁËÄÏîÄÚÈÝΪ±ØÌîÏ°üÀ¨ÊµÑéÄ¿µÄºÍÒªÇó£»ÊµÑéÒÇÆ÷ºÍÉ豸£»ÊµÑéÄÚÈÝÓë¹ý³Ì£»ÊµÑé½á¹ûÓë·ÖÎö¡£¸÷Ôº²¿¿É¸ù¾Ýѧ¿ÆÌصãºÍʵÑé¾ßÌåÒªÇóÔö¼ÓÏîÄ¿¡£
ÌîдעÒâÊÂÏî
£¨1£©Ï¸Ö¹۲죬¼°Ê±¡¢×¼È·¡¢Èçʵ¼Ç¼¡£ £¨2£©×¼È·ËµÃ÷£¬²ã´ÎÇåÎú¡£
£¨3£©¾¡Á¿²ÉÓÃרÓÃÊõÓïÀ´ËµÃ÷ÊÂÎï¡£
£¨4£©ÍâÎÄ¡¢·ûºÅ¡¢¹«Ê½Òª×¼È·£¬Ó¦Ê¹ÓÃͳһ¹æ¶¨µÄÃû´ÊºÍ·ûºÅ¡£ £¨5£©Ó¦¶ÀÁ¢Íê³ÉʵÑ鱨¸æµÄÊéд£¬ÑϽû³Ï®¡¢¸´Ó¡£¬Ò»¾·¢ÏÖ£¬ÒÔÁã·ÖÂÛ´¦¡£
ʵÑ鱨¸æÅú¸Ä˵Ã÷
ʵÑ鱨¸æµÄÅú¸ÄÒª¼°Ê±¡¢ÈÏÕæ¡¢×Ðϸ£¬Ò»ÂÉÓúìÉ«±ÊÅú¸Ä¡£ÊµÑ鱨¸æµÄÅú¸Ä³É¼¨²ÉÓðٷÖÖÆ£¬¾ßÌåÆÀ·Ö±ê×¼Óɸ÷Ôº²¿×ÔÐÐÖÆ¶¨¡£
ʵÑ鱨¸æ×°¶©ÒªÇó
ʵÑéÅú¸ÄÍê±Ïºó£¬ÈοÎÀÏʦ½«Ã¿Ãſγ̵Äÿ¸öʵÑéÏîÄ¿µÄʵÑ鱨¸æÒÔ×ÔÈ»°àΪµ¥Î»¡¢°´Ñ§ºÅÉýÐòÅÅÁУ¬×°¶©³É²á£¬²¢¸½ÉÏÒ»·Ý¸ÃÃſγ̵ÄʵÑé´ó¸Ù¡£
ʵÑéÏîÄ¿Ãû³Æ£º¾µäÈí¼þÌåϵ½á¹¹·ç¸ñ ʵÑéѧʱ£º 4ѧʱ ͬ×éѧÉúÐÕÃû£º ʵÑ鵨µã£º 1216 ʵÑéÈÕÆÚ£º 2015.10.27-2015.11.3 ʵÑé³É¼¨£º Åú¸Ä½Ìʦ£º Åú¸Äʱ¼ä£º
Ò»¡¢ ʵÑéÄ¿µÄºÍÒªÇó
£¨1£©Àí½â¹ÜµÀ-¹ýÂËÆ÷Èí¼þÌåϵ½á¹¹¡¢ÃæÏò¶ÔÏóÈí¼þÌåϵ½á¹¹µÄÔÀí £¨2£©ÕÆÎչܵÀ-¹ýÂËÆ÷Èí¼þÌåϵ½á¹¹¡¢ÃæÏò¶ÔÏóÈí¼þÌåϵ½á¹¹Ìص㠣¨3£©ÃæÏò¶ÔÏóÈí¼þÌåϵ½á¹¹µÄ±à³ÌʵÏÖ
¶þ¡¢ ʵÑéÒÇÆ÷ºÍÉ豸
±¼ÌÚÒÔÉϼÆËã»ú£¬Windows 10 ¡¢Visual Studio 2013¡¢MySQL
Èý¡¢ ʵÑé¹ý³Ì
£¨1£©ÔÚdosÏÂÌå»á¹ÜµÀ¹ýÂËÆ÷µÄÌåϵ½á¹¹¡£
ʹÓà dir | more ÃüÁîÁ˽â¹ÜµÀ-¹ýÂËÆ÷·ç¸ñµÄ³ÌÐò¡£
£¨2£©Êý¾Ý³éÏóºÍÃæÏò¶ÔÏóÈí¼þÌåϵ½á¹¹Éè¼ÆÊµÏÖ¡£Éè¼ÆÒ»¸öÓ¦ÓóÌÐò£¬ÔڸóÌÐò¶¨ÒåÆ½ÃæÍ¼ÐεijéÏóÀàºÍÆäÅÉÉúÀàÔ²¡¢¾ØÐΡ¢Èý½ÇÐΣ¬ÍÖÔ²¡£¸Ã³ÌÐòµÄ¹¦ÄܰüÀ¨£ºÊäÈëÏàÓ¦µÄͼÐβÎÊý£¬Èç¾ØÐεij¤ºÍ¿í£¬µ¥»÷ÏàÓ¦°´Å¥£¬Äܸù¾ÝÊäÈë²ÎÊý´´½¨Í¼ÐÎÀಢÊä³ö¸Ã¶ÔÏóµÄÃæ»ý¡£Ê¹ÓÃc#¡¢c++»òJava»òÓïÑÔ½øÐÐÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼Æ£º£¨1£©Ê×ÏÈ¿¼ÂÇÊý¾Ý·â×°ÐÔ£¬£¨2£©¿¼ÂǼ̳ÐÐÔ£¬£¨3£©¿¼ÂdzéÏóÀà¡£
Ó¦ÓóÌÐò´úÂ룺 Graphic.cs:
namespace WindowsFormsApplication1 {
public abstract class Graphic {
public abstract double Area(); } }
Rectangle.cs:
namespace WindowsFormsApplication1 {
public class Rectangle : Graphic {
double len; double wid;
public Rectangle(double length,double width) {
len = length; wid = width; }
public override double Area() {
return len * wid; } } }
Triangle.cs:
namespace WindowsFormsApplication1 {
public class Triangle : Graphic {
double btm; double hgt;
public Triangle(double bottom, double height) {
btm=bottom; hgt=height; }
public override double Area() {
return btm * hgt/2; } } }
Circle.cs:
namespace WindowsFormsApplication1 {
public class Circle:Graphic {
double radius;
public Circle(double r) {
radius = r; }
public override double Area() {
return radius * radius * 3.14; } } }
Ellipse.cs:
using System;
using System.Collections.Generic; using System.Linq; using System.Text;
namespace WindowsFormsApplication1 {
public class Ellipse : Graphic {
double la; double lb;
public Ellipse(double a, double b) {
la = a; lb = b; }
public override double Area() {
return la * lb*3.14; } } }
From1.cs:
using System;
using System.Collections.Generic; using System.ComponentModel; using System.Data;
using System.Drawing; using System.Linq; using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1 {
public partial class Form1 : Form {
public Form1() {
InitializeComponent(); }
private void button1_Click(object sender, EventArgs e) {
if (comboBox1.SelectedItem == \Ô²\ {
double r=Convert.ToDouble(textBox1.Text); Circle circle=new Circle(r);
textBox4.Text = Convert.ToString(circle.Area()); }
else if (comboBox1.SelectedItem == \¾ØÐÎ\ {
double len = Convert.ToDouble(textBox1.Text); double wid = Convert.ToDouble(textBox2.Text); Rectangle rec = new Rectangle(len, wid); textBox4.Text = Convert.ToString(rec.Area()); }
else if (comboBox1.SelectedItem == \Èý½ÇÐÎ\ {
double btm = Convert.ToDouble(textBox1.Text); double hgt = Convert.ToDouble(textBox3.Text); Triangle tri = new Triangle(btm, hgt); textBox4.Text = Convert.ToString(tri.Area()); }
else if (comboBox1.SelectedItem == \ÍÖÔ²\ {
double a = Convert.ToDouble(textBox1.Text); double b = Convert.ToDouble(textBox2.Text); Ellipse elp = new Ellipse(a, b);
textBox4.Text = Convert.ToString(elp.Area()); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) {
if (comboBox1.SelectedItem == \Ô²\ {
label1.Text = \°ë¾¶\ label2.Visible = false; label3.Visible = false; textBox2.Visible = false; textBox3.Visible = false; }
else if (comboBox1.SelectedItem == \ {
label1.Text = \ label2.Visible = true; textBox2.Visible = true; label3.Visible = false; textBox3.Visible = false; }
else if (comboBox1.SelectedItem == \ {
label1.Text = \ label3.Visible = true; textBox3.Visible = true; label2.Visible = false; textBox2.Visible = false; }
else if (comboBox1.SelectedItem == \ {
label1.Text = \ label2.Text = \ label2.Visible = true; textBox2.Visible = true; label3.Visible = false; textBox3.Visible = false; } } } }
¾ØÐÎ\³¤\Èý½ÇÐÎ\µ×\ÍÖÔ²\°ë³¤Öá\°ë¶ÌÖá\
ËÄ¡¢ ʵÑé½á¹ûÓë·ÖÎö ³ÌÐò³õʼ½çÃæ£º
ÈçÑ¡ÔñÍÖÔ²£¬ÊäÈë°ë³¤ÖáºÍ°ë¶ÌÖᣬµã»÷¼ÆË㣬Êä³ö½á¹û£º
ÈçÑ¡ÔñÈý½ÇÐΣ¬ÊäÈëµ×ºÍ¸ß£¬µã»÷¼ÆË㣬Êä³ö½á¹û£º
Îå¡¢ ˼¿¼Ìâ
£¨1£© ¹ÜµÀ-¹ýÂËÆ÷Èí¼þÌåϵ½á¹¹ÓëÅú´¦ÀíÈí¼þÌåϵ½á¹¹µÄÇø±ðºÍÁªÏµÊÇʲô£¿
´ð£º¹ÜµÀ/¹ýÂËÆ÷½á¹¹Í¨³£µ¼Ö½ø³Ì³ÉΪÅú´¦ÀíµÄ½á¹¹£¬ÒòΪËäÈ»¹ýÂËÆ÷¿ÉÔöÁ¿Ê½µØ´¦ÀíÊý¾Ý£¬µ«ËüÃÇÊǶÀÁ¢µÄ£¬ËùÒÔÉè¼ÆÕß±ØÐ뽫ÿһ¸ö¹ýÂËÆ÷¿´³ÉÒ»¸öÍêÕûµÄ´ÓÊäÈëµ½Êä³öµÄת»»¡£.ÏÞ¶¨¹ýÂËÆ÷µÄÊý¾Ý´æ´¢ÈÝÁ¿£¬¾Í¿ÉÒԵõ½Óнç¹ÜµÀ/¹ýÂËÆ÷¡£¹ýÂËÆ÷½«ËùÓÐÊäÈëÊý¾Ý×÷Ϊµ¥¸öʵÌå½øÐд¦Àí£¬Õâ¾ÍÊÇÅú´¦Àíϵͳ £¨2£© ÃæÏò¶ÔÏóÈí¼þÌåϵ½á¹¹ÓëÖ÷³ÌÐò-×Ó³ÌÐòÈí¼þÌåϵ½á¹¹µÄÇø±ðºÍÁªÏµÊÇʲô£¿
´ð£ºÖ÷³ÌÐò-×Ó³ÌÐòÌåϵ½á¹¹ÔÚÉè¼ÆÉÏʹÓòã´Î»¯µÄ»®·Ö·½·¨£¬Í¨³£²ÉÓÃ×Ô¶¥ÏòÏµĹ¦ÄÜ»¯Éè¼Æ·½·¨£¬ÃæÏò¶ÔÏóÌåϵ½á¹¹ÔÚÉè¼ÆÉÏʹÓÃÃæÏò¶ÔÏóµÄÉè¼Æ·½·¨£¬¿ÉÒÔÒþ²Ø¶ÔÏóµÄÄÚ²¿×´Ì¬²¢ÇÒÒªÇóËùÓжÔÏó¼äµÄ½»»¥¶¼Í¨¹ý¸Ã·½·¨£¬¼´½øÐÐÁËÊý¾Ý·â×°£¬ÕâÒ²ÊÇÃæÏò¶ÔÏó±à³ÌµÄ»ù±¾ÔÔò
Áù¡¢ÊµÑéÐĵÃÓëÌå»á
ÔڹܵÀ/¹ýÂËÆ÷·ç¸ñµÄÈí¼þÌåϵ½á¹¹ÖУ¬Ã¿¸ö¹¹¼þ¶¼ÓÐÒ»×éÊäÈëºÍÊä³ö£¬¹¹¼þ¶ÁÊäÈëµÄÊý¾ÝÁ÷£¬¾¹ýÄÚ²¿´¦Àí£¬È»ºó²úÉúÊä³öÊý¾ÝÁ÷¡£Õâ¸ö¹ý³Ìͨ³£Í¨¹ý¶ÔÊäÈëÁ÷µÄ±ä»»¼°ÔöÁ¿¼ÆËãÀ´Íê³É£¬ËùÒÔÔÚÊäÈë±»ÍêÈ«Ïû·Ñ֮ǰ£¬Êä³ö±ã²úÉúÁË¡£Òò´Ë£¬ÕâÀïµÄ¹¹¼þ±»³ÆÎª¹ýÂËÆ÷£¬ÕâÖÖ·ç¸ñµÄÁ¬½Ó¼þ¾ÍÏóÊÇÊý¾ÝÁ÷´«ÊäµÄ¹ÜµÀ£¬½«Ò»¸ö¹ýÂËÆ÷µÄÊä³ö´«µ½ÁíÒ»¹ýÂËÆ÷µÄÊäÈ롣ͨ¹ýʵÑ飬ÎÒ¶ÔÕâÖÖÈí¼þÌåϵ½á¹¹ÓÐÁ˽øÒ»²½Á˽⡣
ʵÑéÏîÄ¿Ãû³Æ£º¶à²ãC/S½á¹¹Ó¦ÓÃÉè¼Æ ʵÑéѧʱ£º 4ѧʱ ͬ×éѧÉúÐÕÃû£º ʵÑ鵨µã£º 1216 ʵÑéÈÕÆÚ£º 2015.11.10-2015.11.24 ʵÑé³É¼¨£º Åú¸Ä½Ìʦ£º Åú¸Äʱ¼ä£º
Ò»¡¢ ʵÑéÄ¿µÄºÍÒªÇó
Éè¼Æ²¢ÊµÏÖÒ»¸ö»ùÓÚ¶à²ãC/S½á¹¹µÄÊý¾Ý¿âÓ¦Óã¬ÊìϤ¶à²ãC/SÌåϵ½á¹¹¼°Æä»ù±¾´¦ÀíÁ÷³Ì£¬Á˽â¶à²ã½á¹¹±íÏֲ㡢ҵÎñÂß¼²ã£¨¹¦Äܲ㣩¡¢Êý¾Ý·ÃÎʲãËùÍê³ÉµÄ¹¦ÄÜ£¬ÕÆÎÕ¶à²ãC/S½á¹¹µÄÊý¾Ý¿âÓ¦ÓÃÉè¼Æ·½·¨£¬¶ÔÕâÈý²ã½øÐÐÃ÷È··Ö¸î£¬²¢ÔÚÂß¼ÉÏʹÆä¶ÀÁ¢¡£Ñ§Éúͨ¹ý±¾ÊµÑéµÄѵÁ·Äܹ»ÊìÁ·ÕÆÎÕ¶ÔСÐÍÊý¾Ý¿âÓ¦ÓÃϵͳÈý²ã½á¹¹²ã´Î»®·Ö·½·¨¼°ÏµÍ³ÊµÏÖ¼¼Êõ¡£
¶þ¡¢ ʵÑéÒÇÆ÷ºÍÉ豸
±¼ÌÚÒÔÉϼÆËã»ú£¬Windows 10 ¡¢Visual Studio 2013¡¢MySQL
Èý¡¢ ʵÑé¹ý³Ì
·Ö±ð²ÉÓöþ²ãC/S½á¹¹ºÍ¶à²ãC/S½á¹¹ÊµÏÖ¸öÈËͨѶ¼ϵͳ¡£¸ÃϵͳµÄÉè¼ÆÄ¿±êÊÇÄܹ»ÇáËɵعÜÀí¸öÈ˵ÄÁªÏµÈËÐÅÏ¢£¬°üÀ¨Ìí¼Ó¡¢Ð޸ĺÍɾ³ý²Ù×÷¡£ÁªÏµÈËÐÅÏ¢°üÀ¨ÐÕÃû¡¢×¡Ö·¡¢µç»°¡£Õû¸öϵͳµÄ¹¦ÄÜͼÈçÏÂͼËùʾ£º
Ó¦ÓóÌÐò´úÂ룺
using System;
using System.Windows.Forms; using MySql.Data.MySqlClient;
namespace WindowsFormsApplication2 {
public partial class Form1 : Form {
public int action = 0;//0:Ìí¼Ó£»1£ºÐÞ¸Ä public Form1() {
InitializeComponent(); }
private void groupBox3_Enter(object sender, EventArgs e) {
}
private void button3_Click(object sender, EventArgs e) {
frm1.Enabled = true; frm2.Enabled = false; action = 0;
}
private void add() {
long id=0;
int count=list1.Items.Count; if (count == 0) {
id = 1001; } else {
id = long.Parse(list1.Items[count - 1].Text)+1; }
Dbcon connector = new Dbcon();
MySqlConnection con = connector.dbcon(); con.Open();
MySqlCommand cmd = new MySqlCommand(\(id,name,phoneno,location) values(@id,@name,@phoneno,@location)\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.ExecuteNonQuery();
con.Close(); build(); }
private void modify() {
foreach (ListViewItem item in list1.SelectedItems) {
Dbcon connector = new Dbcon();
MySqlConnection con = connector.dbcon(); con.Open();
MySqlCommand cmd = con.CreateCommand(); cmd.CommandText=\
name=@name,phoneno=@phoneno,location=@location where id=@id\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\
cmd.ExecuteNonQuery(); con.Close(); } build(); }
private void button1_Click(object sender, EventArgs e) {
if (action == 0) {
add(); }
else if (action == 1) {
modify(); }
name.Clear(); phoneno.Clear(); location.Clear(); frm2.Enabled = true; frm1.Enabled = false; }
private void button4_Click(object sender, EventArgs e) {
foreach (ListViewItem item in list1.SelectedItems) {
frm1.Enabled = true; frm2.Enabled = false;
name.Text = item.SubItems[1].Text; phoneno.Text = item.SubItems[2].Text; location.Text = item.SubItems[3].Text; action = 1; } }
private void Form1_Load(object sender, EventArgs e) {
build();
}
public void build() {
list1.BeginUpdate(); list1.Items.Clear();
Dbcon connector = new Dbcon();
MySqlConnection con = connector.dbcon(); con.Open();
MySqlCommand cmd = new MySqlCommand(\* from person\con); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) {
ListViewItem item = new ListViewItem(); item.Text = Convert.ToString(dr[\
item.SubItems.Add(Convert.ToString(dr[\ item.SubItems.Add(Convert.ToString(dr[\ item.SubItems.Add(Convert.ToString(dr[\ list1.Items.Add(item); }
dr.Close(); con.Close(); list1.EndUpdate(); }
private void button5_Click(object sender, EventArgs e) {
foreach (ListViewItem item in list1.SelectedItems) {
Dbcon connector = new Dbcon();
MySqlConnection con = connector.dbcon(); con.Open();
MySqlCommand cmd = new MySqlCommand(\from person where id=\
cmd.ExecuteNonQuery(); } build(); }
private void button2_Click(object sender, EventArgs e) {
frm2.Enabled = true; frm1.Enabled = false; name.Clear(); phoneno.Clear(); location.Clear(); }
private void textBox2_TextChanged(object sender, EventArgs e) {
}
private void list1_SelectedIndexChanged(object sender, EventArgs e) {
//MessageBox.Show(); }
private void button6_Click(object sender, EventArgs e) {
MessageBox.Show(\ } }
public class Dbcon {
public MySqlConnection dbcon()
{
String constr = \Id=root;password=root;Database=contact\
MySqlConnection con = new MySqlConnection(constr); return con; } } }
ËÄ¡¢ ʵÑé½á¹ûÓë·ÖÎö ³ÌÐòÖ÷½çÃæ£º
µã»÷¡°Ìí¼ÓÁªÏµÈËÐÅÏ¢¡±£º
µã»÷¡°È·¶¨¡±£º
Ñ¡ÖÐÁбíÉϵÄijÏîÄÚÈÝ£¬µã»÷¡°ÐÞ¸ÄÁªÏµÈËÐÅÏ¢¡±£º
ÐÞ¸ÄÐÅÏ¢²¢µã»÷¡°È·¶¨¡±£º
Î塢˼¿¼Ìâ
Óë¶þ²ãC/SÌåϵ½á¹¹±È½Ï£¬Èý²ã(¶à²ã)Ìåϵ½á¹¹ÓÐʲôÓŵ㣿²ÉÓÃÈý²ãÌåϵ½á¹¹ÔÚϵͳÉè¼ÆÊ±Ó¦¸Ã×¢ÒâÄÄЩÎÊÌ⣿ ´ð£ºÈý²ãÌåϵ½á¹¹µÄÓŵ㣺
¢ÙÔÊÐíºÏÀíµØ»®·ÖÈý²ã½á¹¹µÄ¹¦ÄÜ£¬Ê¹Ö®ÔÚÂß¼Éϱ£³ÖÏà¶Ô¶ÀÁ¢ÐÔ ¢ÚÔÊÐí¸üÁé»îÓÐЧµØÑ¡ÓÃÏàÓ¦µÄƽ̨ºÍÓ²¼þϵͳ
¢ÛÈý²ãC/S½á¹¹ÖУ¬Ó¦Óõĸ÷²ã¿ÉÒÔ²¢Ðпª·¢£¬¸÷²ãÒ²¿ÉÒÔÑ¡Ôñ¸÷×Ô×îºÏÊʵĿª·¢ÓïÑÔ¡£ ¢ÜÔÊÐí³ä·ÖÀûÓù¦ÄܲãÓÐЧµØ¸ôÀë²ã±íʾ²ãÓëÊý¾Ý²ã¡£ ¢ÝÈý²ãC/S½á¹¹¸÷²ã¼äµÄͨÐÅЧÂÊÈô²»¸ß£¬¼´Ê¹·ÖÅ䏸¸÷²ãµÄÓ²¼þÄÜÁ¦ºÜÇ¿£¬Æä×÷ΪÕûÌåÀ´ËµÒ²´ï²»µ½ËùÒªÇóµÄÐÔÄÜ¡£
ÔÚÉè¼ÆÈý²ã½á¹¹Ê±£¬Ê×ÏÈÒª¿¼ÂǵÄÎÊÌâÔÚÓÚÊý¾Ý²ãºÍÒµÎñ²ãµÄÁ¬½ÓÊÇ·ñ³©Í¨£¬Êý¾ÝµÄÍÌÍÂÁ¿ÊÇ·ñ¹ý´ó¡£ÔÚÓû§¶ÔÓÚ³ÌÐòÏàÓ¦ËÙ¶ÈÒªÇóÒ»°ã»òÕßÊý¾ÝÍÌÍÂÁ¿½ÏСµÄÇé¿öÏ£¬¿ÉÒÔ²ÉÓÃÈý²ã½á¹¹½øÐÐÉè¼Æ
Áù¡¢ÊµÑéÐĵÃÓëÌå»á
ʵÑéÉæ¼°µ½c#¼¼Êõ¶ÔÓÚJDBCµÄ²Ù×÷£¬Óöµ½Ò»¶¨À§ÄÑ£¬µ«¶¼ÍêÃÀ½â¾öÁË¡£ÊÕ»ñÁ˺ܶà¾ÑéºÍ֪ʶ¡£Í¬Ê±ÎÒ¶Ô¶à²ãc/s½á¹¹Ò²ÓÐÁ˸ü¼ÓÉî¿ÌµÄÈÏÖªºÍÁË½â£¬ÕÆÎÕÁËÕâÖÖÈí¼þÌåϵ½á¹¹Ïë±ØÊ®·ÖÓÐÓá£
ʵÑéÏîÄ¿Ãû³Æ£ºB/S½á¹¹Ó¦ÓÃÉè¼Æ ʵÑéѧʱ£º 4ѧʱ ͬ×éѧÉúÐÕÃû£º ʵÑ鵨µã£º 1216 ʵÑéÈÕÆÚ£º2015.12.01-2015.12.15 ʵÑé³É¼¨£º Åú¸Ä½Ìʦ£º Åú¸Äʱ¼ä£º
Ò»¡¢ ʵÑéÄ¿µÄºÍÒªÇó
Éè¼Æ²¢ÊµÏÖÒ»¸ö»ùÓÚB/S½á¹¹µÄÊý¾Ý¿âÓ¦Óã¬ÊìϤB/SÌåϵ½á¹¹¼°Æä»ù±¾´¦ÀíÁ÷³Ì£¬Á˽âB/S½á¹¹ÏµÍ³¸÷²¿·ÖËùÍê³ÉµÄ¹¦ÄÜ£¬ÕÆÎÕB/S½á¹¹µÄÊý¾Ý¿âÓ¦ÓÃÉè¼Æ·½·¨¡£Ñ§Éúͨ¹ý±¾ÊµÑéµÄѵÁ·Äܹ»ÊìÁ·ÕÆÎÕ¶ÔСÐÍÊý¾Ý¿âÓ¦ÓÃϵͳB/S½á¹¹Éè¼Æ¼°ÏµÍ³ÊµÏÖ¼¼Êõ¡£
¶þ¡¢ ʵÑéÒÇÆ÷ºÍÉ豸
±¼ÌÚÒÔÉϼÆËã»ú£¬Windows 10¡¢MyEclipse2014¡¢Sencha CMD¡¢MySQL
Èý¡¢ ʵÑé¹ý³Ì
1.²ÉÓÃB/S½á¹¹ÊµÏÖ¸öÈËͨѶ¼ϵͳ¡£¸ÃϵͳµÄÉè¼ÆÄ¿±êÊÇÄܹ»ÇáËɵعÜÀí¸öÈ˵ÄÁªÏµÈËÐÅÏ¢£¬°üÀ¨Ìí¼Ó¡¢Ð޸ĺÍɾ³ý²Ù×÷¡£ÁªÏµÈËÐÅÏ¢°üÀ¨ÐÕÃû¡¢×¡Ö·¡¢µç»°¡£Õû¸öϵͳµÄ¹¦ÄÜͼÈçÏÂͼËùʾ£º
2.Èý²ãB/S½á¹¹µÄ¸öÈËͨѶ¼ 2.1.ÏîÄ¿½á¹¹½ØÍ¼
2.2.ÔËÐÐЧ¹û½ØÍ¼£º
2.3.¡°Ìí¼ÓÁªÏµÈË¡±¹¦ÄÜ£º
Ìí¼ÓºóµÄЧ¹û£º
¡°Ìí¼Ó¡±¹¦ÄܵĴúÂ룺
public void AddFriend(ContactEntry friend) {
SqlConnection conn = new SqlConnection(); conn.ConnectionString =
ConfigurationManager.AppSettings[\];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = \; cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
int[] temp = new int[2]; temp[0] = 0;
while (reader.Read()) {
temp[1] = reader.GetInt32(0); if (temp[0] < temp[1]) {
temp[0] = temp[1]; } }
int cID = temp[0] + 1;
reader.Close(); conn.Close();
conn = new SqlConnection(); conn.ConnectionString =
ConfigurationManager.AppSettings[\];
cmd = new SqlCommand();
cmd.CommandText = \; cmd.CommandText += \ + cID + \; cmd.CommandText += friend.CName + \; cmd.CommandText += friend.CAddress + \; cmd.CommandText += friend.CPhone + \; cmd.CommandText += friend.CEmail + \; cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery(); conn.Close(); }
µ÷ÓÃBeanÖеÄÊôÐÔ£º
µ÷ÓÃÅäÖÃÎļþÖеÄÐÅÏ¢£º
2.4.¡°ÐÞ¸ÄÁªÏµÈËÐÅÏ¢¡±¹¦ÄÜ£º
µã»÷Ò»ÌõÐÅÏ¢Óұߵġ°Ð޸ġ±°´Å¥½øÈëÐ޸ĽçÃæ£º
¡°Ð޸ġ±¹¦ÄܵĴúÂ룺
public void UpdateFriendByID(ContactEntry friend) {
SqlConnection conn = new SqlConnection(); conn.ConnectionString =
ConfigurationManager.AppSettings[\];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = \ + friend.CName; cmd.CommandText += \ + friend.CAddress; cmd.CommandText += \ + friend.CEmail;
cmd.CommandText += \ + friend.CPhone + \; cmd.CommandText += \ + friend.ID; cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close(); }
2.5.¡°É¾³ý¡±ÁªÏµÈ˹¦ÄÜ£º
µã»÷Ò»ÌõÐÅÏ¢Óұߵġ°É¾³ý¡±°´Å¥¼´½«ÐÅϢɾ³ý£º £¨É¾³ýǰ£©
£¨É¾³ýºó£©
¡°É¾³ý¡±¹¦ÄܵĴúÂë:
public void DeleteFriendByID(int id) {
SqlConnection conn = new SqlConnection(); conn.ConnectionString =
ConfigurationManager.AppSettings[\];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = \ + id; cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close(); }
2.6.¡°ËÑË÷¡±ÁªÏµÈ˹¦ÄÜ£º
¡°ËÑË÷¡±¹¦ÄܵĴúÂ룺
public SqlDataReader GetFriendKey(string key) {
SqlConnection conn = new SqlConnection(); conn.ConnectionString =
ConfigurationManager.AppSettings[\];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = \; cmd.CommandText += \ + key + \; cmd.CommandText += \ + key + \; cmd.CommandText += \ + key + \; cmd.CommandText += \ + key + \; cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return reader; }
3.¶þ²ãB/S½á¹¹¸öÈËͨѶ¼
3.1.¶þ²ãB/S½á¹¹ºÍÈý²ãB/S½á¹¹µÄÇø±ð£º
3.2.¶þ²ãB/S½á¹¹½çÃæÉè¼ÆºÍÂß¼´úÂëδ·ÖÀë
£¨Ê¾Àý£ºÍ¼ÖеļýÍ·±ê¼ÇµÄÊÇ¡°Ö´ÐÐÌí¼Ó¡±°´Å¥µÄʼþ£©
protected void Button1_Click(object sender, EventArgs e) {
if(Page.IsValid) {
SqlConnection conn = new SqlConnection(); conn.ConnectionString =
ConfigurationManager.AppSettings[\];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = \into contact(ID,cName,cAddress,cPhone,cEmail)\; cmd.CommandText += \ + cID + \; cmd.CommandText += TextBox1.Text + \; cmd.CommandText += TextBox2.Text + \; cmd.CommandText += TextBox3.Text + \; cmd.CommandText += TextBox4.Text + \; cID++;
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect(\); } }
Îå¡¢ ˼¿¼Ìâ
ÓëC/SÌåϵ½á¹¹±È½Ï£¬B/SÌåϵ½á¹¹ÓÐʲôÓŵ㣿²ÉÓÃB/SÓëC/S»ìºÏÌåϵ½á¹¹ÔÚϵͳÉè¼ÆÊ±Ó¦¸Ã×¢ÒâÄÄЩÎÊÌ⣿
´ð£º »ùÓÚB/SÌåϵ½á¹¹µÄÈí¼þ£¬ÏµÍ³°²×°¡¢Ð޸ĺÍά»¤È«ÔÚ·þÎñÆ÷¶Ë½â¾ö¡£Óû§ÔÚʹÓÃϵ
ͳʱ£¬½öÐèÒªÒ»¸öä¯ÀÀÆ÷¾Í¿ÉÒÔÔËÐÐÈ«²¿µÄÄ£¿é£¬ÕæÕý´ïµ½ÁË¡°Áã¿Í»§¶Ë¡±µÄ¹¦ÄÜ£¬ºÜÈÝÒ×ÔÚÔËÐÐʱ×Ô¶¯Éý¼¶¡£B/SÌåϵ½á¹¹»¹ÌṩÁËÒìÖÖ»ú¡¢ÒìÖÖÍø¡¢ÒìÖÖÓ¦Ó÷þÎñµÄÁª»ú¡¢ÁªÍø¡¢Í³Ò»·þÎñµÄ×îÏÖʵµÄ¿ª·¢ÐÔ»ù´¡¡£ÓÃB/SºÍC/S»ìºÏ½á¹¹Éè¼ÆÊ±Ó¦¿¼ÂÇB/S¡¢C/SµÄ¾ßÌåʹÓû·¾³¡£±ÈÈçB/SÊÊÓÃÓÚÍⲿԶ³Ì·ÃÎÊ£¬C/SÊÊÓÃÓÚÄÚ²¿¾ÖÓòÍø·ÃÎÊ£¬·þÎñ¶ËÒ²ÄܶԿͻ§¶Ë¼ÓÒÔʶ±ð£¬±ÜÃâÔ¶³ÌÖ÷»úʹÓÃC/SµÄȨÏÞ½øÐзǷ¨·ÃÎÊ
Áù¡¢ÊµÑéÐĵÃÓëÌå»á
Èý²ãB/S½á¹¹ÊµÏÖÁ˽çÃæÉè¼ÆºÍÂß¼´úÂëµÄ·ÖÀ룬¸ü¼Ó¹æ·¶»¯£¬Ê¹ºóÆÚµÄÐ޸ĴúÂëºÍά»¤¸ü¼Ó±ãÀû¡£ÔÚÖÆ×÷µÄʱºòÒ²Óöµ½ÁËһЩÂé·³£¬±ÈÈçÓÉÓÚ²»Ð¡ÐÄÊäÈësql´úÂë×Ö¶ÎûÓÐÌí¼Ó¿Õ¸ñ£¬µ¼ÖÂÔËÐеÄʱºòûÓб¨ÈκδíÎó£¬È´Ê¹µÃϵͳһֱ¿¨ÔÚÄÇÀֻºÃÓÃÈÎÎñ¹ÜÀíÆ÷½«ËûÖսᣬ²ÅʹµÃϵͳÍ˳öÔËÐУ¬ºóÀ´Óöϵãµ÷ÊÔ£¬·¢ÏÖÔËÐе½Ö´ÐÐsqlÓï¾äÏÂÒ»¾äµÄʱºò£¬¸ø³öµÄ²ÎÊýÖµÓÐÎÊÌ⣬ÓÚÊDzŷ¢ÏÖÎÊÌâËùÔÚ¡£