来个大佬,救救孩子吧
我在idea里面用Java写的servlet能够使我获取到前端的数据到Tomcat,但不知道为什么Tomcat始终无法获取到前端选项中的内容,只能获取到输入的东西。
另外,Tomcat获取到的数据始终无法链接到我的数据库,将获取的数据传到数据库建的表里面。下面是我的servlet代码
@WebServlet(name = "Servlet",urlPatterns = "/Servlet")
public class Servlet extends HttpServlet {
private static final String DBDRIVER = "com.mysql.jdbc.Driver"; //驱动程序名
private static final String DBURL = "jdbc:mysql://192.16.48.11:3306/db"; //URL指向要访问的数据库名
private static final String DBUSER = "scott"; //MySQL配置时的用户名
private static final String DBPASSWORD = "123456";
public static Connection getConnection(){
Connection conn =null;
try {
Class.forName(DBDRIVER); //注册驱动
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD); //获得连接对象
Statement statement = conn.createStatement();
String sql ="select * from course ";
ResultSet rs = statement.executeQuery(sql);
} catch (ClassNotFoundException e) { //捕获驱动类无法找到异常
e.printStackTrace();
} catch (SQLException e) { //捕获SQL异常
e.printStackTrace();
}
return conn;
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try{
request.setCharacterEncoding("UTF-8");
response.setContentType("application/json; charset=utf-8");
BufferedReader streamReader = new BufferedReader(new InputStreamReader(request.getInputStream() ));
StringBuilder responseStrBuilder =new StringBuilder();
String inputStr=null;
while ((inputStr = streamReader.readLine()) !=null)
responseStrBuilder.append(inputStr);
PrintWriter out =response.getWriter();
out.println(responseStrBuilder.toString());
System.out.println(responseStrBuilder.toString());
} catch (Exception e) {
e.printStackTrace();
}
}
}
最后,我不知道如何让前端获取到数据库中的数据,下面是我前端提交和获取数据的代码
methods: {
save() {
axios
.post("/api",JSON.stringify(this.form))
.then((res) => {
console.log(res);
})
.catch((err) => {
console.log(err);
})
},
getdata() {
axios
.get("/api",JSON.stringify(this.form))
.then((res) => {
console.log(res);
})
.catch((err) => {
console.log(err);
})
}
}
建议你,前端先console看看能否获取信息,看你说的问题,应该是前台问题
你的servlet只有post,无get
您好,我是问答小助手,你的问题已经有小伙伴为您解答了问题,您看下是否解决了您的问题,可以追评进行沟通哦~
如果有您比较满意的答案 / 帮您提供解决思路的答案,可以点击【采纳】按钮,给回答的小伙伴一些鼓励哦~~