addClientCheck
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="gbk"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>处理客户添加数据</title>
</head>
<body>
<%
String clientName=new String(request.getParameter("clientName").getBytes("ISO-8859-1"),"gbk");
String clientTelephone=new String(request.getParameter("clientTelephone").getBytes("ISO-8859-1"),"gbk");
String clientAddress=new String(request.getParameter("clientAddress").getBytes("ISO-8859-1"),"gbk");
String clientEmail=new String(request.getParameter("clientEmail").getBytes("ISO-8859-1"),"gbk");
Connection con=null;
Statement st=null;
try{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/eims?useUnicode=true&characterEncoding=gbk";
con=DriverManager.getConnection(url,"root","21328");
st=con.createStatement();
String sql="insert into client(clientName,clientTelephone,clientAddress,clientEmail) values ('"+clientName+"','"+clientTelephone+"','"+clientAddress+"','"+clientEmail+"')";
st.executeUpdate(sql);
response.sendRedirect("http://localhost:8080/EIMS/clientManage/lookClient.jsp");
}
catch(Exception e){
e.printStackTrace();
}
finally{
st.close();
con.close();
}
%>
</body>
</html>