用SQLserver实现某中学排课管理系统。主要功能包括教职工入库信息，排课管理，教职工带课查询，本学期课程设置，打印课程表，打印教师带课表。提供代码

由于涉及到多个模块的代码实现，我将提供简单的代码示例供您参考，具体实现方式可能因需求而异，需要根据实际情况进行调整。

教职工信息入库信息表：

CREATE TABLE [dbo].[TeacherInfo](
    [TeacherId] [VARCHAR](50) NOT NULL PRIMARY KEY,
    [Name] [VARCHAR](50) NOT NULL,
    [Gender] [VARCHAR](10) NOT NULL,
    [BirthDate] [DATE] NOT NULL,
    [Phone] [VARCHAR](20) NOT NULL,
    [Address] [VARCHAR](200) NULL,
    [Department] [VARCHAR](50) NOT NULL,
    [Title] [VARCHAR](50) NULL,
    [JoinDate] [DATE] NOT NULL,
    [IsActive] [BIT] NOT NULL
)

排课管理表：

CREATE TABLE [dbo].[CourseSchedule](
    [ScheduleId] [INT] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [ClassId] [VARCHAR](50) NOT NULL,
    [CourseId] [VARCHAR](50) NOT NULL,
    [TeacherId] [VARCHAR](50) NOT NULL,
    [Classroom] [VARCHAR](50) NOT NULL,
    [Weekday] [INT] NOT NULL,
    [Lesson] [INT] NOT NULL,
    [Term] [VARCHAR](50) NOT NULL,
    [IsActive] [BIT] NOT NULL
)

教职工带课查询表：

CREATE VIEW [dbo].[TeacherCourseView]
AS
SELECT 
    TeacherInfo.Name AS TeacherName, 
    Course.CourseName, 
    Course.Credit, 
    Course.Term, 
    Class.ClassName, 
    CourseSchedule.Weekday, 
    CourseSchedule.Lesson, 
    CourseSchedule.Classroom
FROM 
    TeacherInfo 
    INNER JOIN Course ON TeacherInfo.TeacherId = Course.TeacherId 
    INNER JOIN CourseSchedule ON Course.CourseId = CourseSchedule.CourseId 
    INNER JOIN Class ON CourseSchedule.ClassId = Class.ClassId
WHERE 
    CourseSchedule.IsActive = 1 AND Course.IsActive = 1

本学期课程设置表：

CREATE TABLE [dbo].[Course](
    [CourseId] [VARCHAR](50) NOT NULL PRIMARY KEY,
    [CourseName] [VARCHAR](50) NOT NULL,
    [Credit] [DECIMAL](5, 2) NOT NULL,
    [Term] [VARCHAR](50) NOT NULL,
    [TeacherId] [VARCHAR](50) NOT NULL,
    [IsActive] [BIT] NOT NULL
)

打印课程表和教师带课表的实现可以使用存储过程或者应用程序来完成，这里提供使用存储过程的示例：

CREATE PROCEDURE [dbo].[PrintCourseTable]
    @Term VARCHAR(50),
    @ClassId VARCHAR(50)
AS
BEGIN
    SELECT 
        Course.CourseName, 
        Course.Credit, 
        TeacherInfo.Name AS TeacherName, 
        CourseSchedule.Weekday, 
        CourseSchedule.Lesson, 
        CourseSchedule.Classroom
    FROM 
        Course 
        INNER JOIN CourseSchedule ON Course.CourseId = CourseSchedule.CourseId 
        INNER JOIN TeacherInfo ON Course.TeacherId = TeacherInfo.TeacherId
    WHERE 
        Course.Term = @Term AND CourseSchedule.IsActive = 1 AND Course.IsActive = 1 AND CourseSchedule.ClassId = @ClassId
    ORDER BY 
        CourseSchedule.Weekday ASC, CourseSchedule.Lesson ASC
END

CREATE PROCEDURE [dbo].[PrintTeacherCourseTable]
    @Term VARCHAR(50),
    @TeacherId VARCHAR(50)
AS
BEGIN
    SELECT 
        Course.CourseName, 
        Course.Credit, 
        Class.ClassName, 
        CourseSchedule.Weekday, 
        CourseSchedule.Lesson, 
        CourseSchedule.Classroom
    FROM 
        Course 
        INNER JOIN CourseSchedule ON Course.CourseId = CourseSchedule.CourseId 
        INNER JOIN Class ON CourseSchedule.ClassId = Class.ClassId
    WHERE 
        Course.Term = @Term AND CourseSchedule.IsActive = 1 AND Course.IsActive = 1 AND Course.TeacherId = @TeacherId
    ORDER BY 
        CourseSchedule.Weekday ASC, CourseSchedule.Lesson ASC
END

以上是简单的代码示例，具体实现需要根据实际需求进行调整和完善。