java傻瓜_JAVA写接口傻瓜（%）教程（五）

importcom.alibaba.fastjson.JSONObject;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importjava.io.IOException;importjava.io.PrintWriter;import java.sql.*;import java.util.*;importjava.util.Date;

@WebServlet("/hello")//注解，免于在xml注册，/hello表示在主页后加/hello访问此页面

public class test extendsHttpServlet {privateString message;public void init() throwsServletException{

}public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException {//相应不带参数的get

String dbURL="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=S-T";

String userName="sa";

String userPwd="111";

List students=new ArrayList<>();

Connection dbConn=null;try{

String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";

Class.forName(driverName);//反射JDBC包，这个一定要加，不然会报错//设置响应内容类型

response.setContentType("text/html");

response.setCharacterEncoding("UTF-8");

dbConn=DriverManager.getConnection(dbURL,userName,userPwd);

String sql="select * from Student where Sage="+request.getParameter("age");//拼接SQL语句

System.out.println(sql);

Statement statement=dbConn.createStatement();

ResultSet resultSet=statement.executeQuery(sql);while(resultSet.next()){

student st=newstudent();

st.setName(resultSet.getString("Sname"));

st.setId(resultSet.getString("Sno"));

st.setSex(resultSet.getString("Ssex"));

st.setAge(resultSet.getString("Sage"));

students.add(st);

}

response.getWriter().println(JSONObject.toJSONString(students));//注意这里不是控制台输出了，是HttpServletResponse，用于返回json给http请求方//response.getWriter().println(request.getParameter("age"));

} catch(SQLException e) {

e.printStackTrace();

}catch(ClassNotFoundException e) {

e.printStackTrace();

}finally{try{//关闭连接

if(dbConn!=null)

{

dbConn.close();

dbConn=null;

}

}catch(Exception ex)

{

}

}

}

}