摘要:
sdent类: package com.myschool.entity; public class student{ private int studentno; private String loginpwd; private String studentname; private int sex 阅读全文
摘要:
Program using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;nam 阅读全文
摘要:
--切换数据库 use MySchool --查询对应年级下的学生人数 SELECT COUNT(1) AS '人数' FROM Student WHERE GradeId=1SELECT COUNT(1) AS '人数' FROM Student WHERE GradeId=2SELECT COU 阅读全文
摘要:
SELECT * FROM StudentUPDATE Student SET StudentName='王波' WHERE StudentNo='Y21003011' --模糊查询:查询学生表中姓’冯‘的学生记录 '%':匹配0-n个任意字符 --'_'匹配单个字符 --'[]'匹配区间内的值:如 阅读全文