C#原代码(使用sql数据库)
最佳答案
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace LoginApp
{
public partial class Form1 : Form
{
private string strcon = "server=localhost;database=studb;uid=sa;pwd=";//连接的字符
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strcon);//连接
SqlCommand cmd = new SqlCommand();//实例化连接的命令
if (this.textBox1.Text.Trim().Equals("") || this.textBox2.Text.Trim().Equals(""))
{
MessageBox.Show("用户名或者密码不能为空");
}
else
{
try
{
cmd.CommandText = "select count(*) from customer "
+ "where cname='" + this.textBox1.Text.Trim() + "' and "
+ "pwd='" + this.textBox2.Text.Trim() + "'";//命令
cmd.Connection = con;
cmd.CommandTimeout = 10;//超时设置
con.Open();//打开连接
object obj = cmd.ExecuteScalar();//执行命令
int c = Convert.ToInt32(obj);
if (c == 0)
{
MessageBox.Show("登录失败!");
}
else
{
MessageBox.Show("登录成功!");
this.textBox1.Text = "";
this.textBox2.Text = "";
}
con.Close();
}
catch (Exception)
{
MessageBox.Show("程序发生异常,请检查.");
}
}
}
}
}