数据库技术2016年B卷(含答案)(2)

<form action =”insert.do” method=”post” >

<label>单位编号</label> <input type="text" name=”deptId “> <br>

<label>单位名称</label> <input type="text" name=”deptName”> <br>

<button type="submit"> 插入</button>

</form>

</body>

insert.do页

public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {

request.setCharacterEncoding("UTF-8");

response.setContentType("text/html; charset=UTF-8");

try {

//请填写下方的程序段来完成插入的程序

String deptId = request.getParameter("deptId");

String deptName = request.getParameter("deptName");

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

String url ="jdbc:sqlserver://exam:8888;DatabaseName=dept";

Connection conn = DriverManager.getConnection(url,"sa","123");

Statement stmt = conn.createStatement();

String sql= " insert into dept values('"+deptId+"', '"+deptName+"' ) ";

Boolean flag= stmt.execute(sql);

stmt.close();

conn.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

}