还好 ？

1:请问要跳转到这个控制器文件CommonControllers.cs的Validate方法链接地址应该怎么写？

 url: "/Common/Validate";

2:创建数据库的语句怎么写？
   

create database 数据库名;

3:创建表的语句怎么写?

create table 表名(字段属性);

4:向表UserInfo插入一条记录怎么写?

insert into  UserAdmin(UserName,UserPwd)values('admin','123');

5:查询表UserInfo中字段UserName为'123'的值SQL语句怎么写?

select * from UserInfo where UserName='123'

6:Ado.Net连接数据库的步骤?
1)创建连接字符串
2)创建SqlConnection连接对象
3)打开连接
4)创建SqlCommand操作对象
5)预处理
6)异常处理
7)关闭连接

7:在写jquery之前,首先第一步要干嘛?

//先引用包：

<script type="text/javascript" src="~/Scripts/jquery-1.9.min.js"></script>

8:Jquery获取元素id为username的值怎么写?

$("#username").val();

9:jquery获取元素class为login的值怎么写?

$(".login").val();

10:元素id为username的鼠标点击事件怎么写?

$("#username").click(function(){})

11:元素id为username的鼠标失去焦点事件怎么写?

 $("#username").blur(function(){})

12:Ajax提交的语法是怎么样的?

var data = {};
    data.UserName = $("#UserName").val();
  $.ajax({
         url: "/Login/AddAdmin",
         data: data,
         type: "post",
         success: function (result) {
                if (result.Success) {
                   alert("登录成功")
                 } else{
                   alert("登录失败")
                 } 
            }
         
        })

13:jquery定义一个对象的语法是什么?
 

var data = {};

14:Ajax接收后台的结果怎么处理,假设后台传递的是一个对象?
  

public JsonResult AdminLogin(Admin admin)
        {
            Admin a = admin;
            Operate operate = new Operate();
            AdminInfoService adminInfoService = new AdminInfoService();
            operate.Success = adminInfoService.LoginAdminInfo(admin) > 0;
            return Json(operate);
        }

 

15:页面用Ajax提交的时候，Form表单要做什么处理?

<form  method="post" action="./login.php" class="form center">
//去除from中method和action元素
<form  class="form center">

16:sql语句怎么参数化处理,需要注意哪些地方?
 

public int AddUserMi(UserMi userMi)
        {
            SqlHelper sqlHelper = new SqlHelper();
            string sql = @"INSERT INTO[MiShop02].[dbo].[UserMi]
           ([UserName]
           ,[UserPwd]
)
     VALUES
           (@UserName
           ,@UserPwd)";
            SqlParameter[] parameters = {
                new SqlParameter()
                {
                    DbType = DbType.String,
                    ParameterName = "@UserName",
                    Value = userMi.UserName
                },
                 new SqlParameter()
                {
                    DbType = DbType.String,
                    ParameterName = "@UserPwd",
                    Value = userMi.UserPwd
                }
            };
            return sqlHelper.ExcuteNoQuery(sql, parameters);
        }

17:数据库连接字符串一般配置在什么地方,后台怎么读取?
 

//存放在web项目中Web.config配置中
//读取步骤:
//1)引用
using System.Configuration;
//2)读取并接收
private string connString = ConfigurationManager.AppSettings["connString"];