编写 Servlet 程序 - 2-优快云博客

Servlet 中的doGet 和 doPost 分别对应信息反馈和信息提交。

一个纯的Servlet就是把网页代码写到outer中！

比如：

out.println("<html>");
out.println("<head><title>演示程序</title></head>");

实现的网页如图：

doGet代码：

response.setContentType("text/html; charset=GBK"); //声明 PrintWriter PrintWriter out=new PrintWriter(response.getOutputStream()); //Properties props=new Properties(); //输出网页代码 out.println("<html>"); out.println("<head><title>演示程序</title></head>"); out.println("<h2><center>"); out.println("标题"); out.println("</center></h2>"); out.println("<br>");//换行 String sURIstr="http://localhost:9090/CarNumber/pastTimeList";//声明 servlet uri out.println("<form method=POST action=/"" +sURIstr +"/">选择时间"); out.println("<select name=pastTime size=1>"); //设置 MS SQL String urlStr="jdbc:jtds:sqlserver://localhost:1433/pubs"; String driverNameStr="net.sourceforge.jtds.jdbc.Driver"; String userNameStr="sa"; String passWordStr="123456"; //输出下拉框数据 String queryStrB="select DISTINCT past_time from trainOrder order by past_time"; outPastTimeList(driverNameStr, urlStr, userNameStr, passWordStr, //props, queryStrB, out); out.println("</select>"); out.println("<input type=submit value=/" 查询 /">"); out.println("</form>"); //输出数据 String pastTimeStr=request.getParameter("pastTime"); String queryStrA="select seriary_number as trainNo,car_number as carN," + "car_marque as carM,carry_weight1 as carSW,self_weight1 as carSW,past_time as pTime " + "from trainOrder where past_time='" +pastTimeStr +"' order by seriary_number"; outCarNumber(driverNameStr, urlStr, userNameStr, passWordStr, //props, queryStrA, out); //输出网页结尾代码 out.println("</body></html>"); //处理 PrintWriter out.flush(); out.close();

代码中：

String urlStr="jdbc:jtds:sqlserver://localhost:1433/pubs";
String driverNameStr="net.sourceforge.jtds.jdbc.Driver";
String userNameStr="sa";
String passWordStr="123456";

设置JDBC中MS SQL 链接各项值！

我用的jdbc 链接器为jtds。

下次，我们讲doPost。