java代码:
package com.wangbingan.item;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class QueryServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doPost(HttpServletRequest request, HttpServletResponse response) {
// 数据库连接
Connection conn = null;
// sql方法
PreparedStatement stmt = null;
// 结果级
ResultSet result = null;
// 接收传入ID
String id = request.getParameter("id");
try {
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 获取数据库链接
conn = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3307/test", "root", "wangbingan");
stmt = conn.prepareStatement("select * from best where id=?");
stmt.setInt(1, Integer.valueOf(id));
result = stmt.executeQuery();
if (result.next()) {
System.out.println("姓名:" + result.getString("name") + "-电话:"
+ result.getString("phone"));
}
} catch (Exception e) {
System.out.println("[OK]");
e.printStackTrace();
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response) {
this.doPost(request, response);
}
}