<%@ page language="java" contentType="text/html; charset=utf-8"%>
<%@ page import="java.sql.*"%>
<% request.setCharacterEncoding("utf-8") ;%>
<%-- <%@ page import="com.mchange.v2.c3p0.ComboPooledDataSource" %> --%>
Insert title here
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/kui"; //指向数据库table1
String username = "root";
String password = "001011";
Connection conn = null;
conn = DriverManager.getConnection(url, username, password);
if(conn != null){
/* Statement stmt = conn.createStatement(); */
String result=request.getParameter("result");
String name=request.getParameter("name");
String calssGrent=request.getParameter("calssGrent");
if(calssGrent.equals("")|name.equals("")|result.equals("")){
response.sendRedirect("dele.jsp");
}else{
Statement stmt = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
//String sql = "insert into title(id,name,sex) values('"+id+"','"+name+"','"+sex+"')";
//String sql = "INSERT INTO title (id,name,age,gender) "
//+"VALUES (880,'菜菜',12,'女')";
String sql = "update student set calssGrent='" + calssGrent +"',result='"+result+ "' where name='" + name + "'";
pstmt = conn.prepareStatement(sql);
pstmt.executeUpdate();
out.print("");
out.println("恭喜！修改成功！
");
out.println("");
/* name=new String(name.getBytes("utf-8"));
out.print(name); */
// rs.next();
}
}
else{
out.print("连接失败！");
}
%>