该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
这是NameExistCheck.java。。
package client;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class NameExistCheck
*/
@WebServlet("/NameExistCheck")
public class NameExistCheck extends HttpServlet {
private static final long serialVersionUID = 1L;
public NameExistCheck() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf8");
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
PrintWriter pw = response.getWriter();
String name = request.getParameter("name");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception e ) {
e.printStackTrace();
}
try {
conn =DriverManager.getConnection("jdbc:mysql://localhost/mystore?"+"user=root&password=jim1");
String sql = "select id from clientbasic where name = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,name);
rs = pstmt.executeQuery();
if(rs.next()){
pw.print("true");
} else {
pw.print("false");
}
} catch (SQLException e) {
e.printStackTrace();
}
finally{
try{
rs.close();
pstmt.close();
conn.close();
} catch(Exception e) {
e.printStackTrace();
}
}
}
}