填空题（答案涉及的英文数字全部使用相应的半角符号）将数据表teacherinfo中的数据进行如下清洗：所有性别为m的改为男，性别为f的改为女。jdbc编程访问salary数据库中teacherinfo表，teacherinfo表包含5个属性，分别为：tno char(5)教师编号teachername varchar(10)教师姓名age int年龄sex char(1)性别“男”或”女”title varchar(10)职称关键代码如下：<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><%@page import="java.sql.*"%><%String psql1 = "update teacherinfo set sex='女' where sex=（第一空）";String psql2 = "update teacherinfo set sex='男' where sex=（第二空）";try {Connection con;con = DriverManager.getConnection("jdbc:sqlserver://localhost;databaseName=salary", "sa","123456");PreparedStatement pstat= con.prepareStatement(（第三空）);pstat.executeUpdate();pstat= con.prepareStatement(（第四空）);pstat.executeUpdate();} catch (Exception e) {e.printStackTrace();}%>