pwdedit.jsp

jsp做的一个个人网站

<%@ page contentType="text/html;charset=gb2312" errorPage=""%>
<%@ page import="java.sql.*,java.util.Date,java.text.SimpleDateFormat"%>
<%
request.setCharacterEncoding("gb2312");
int id=Integer.parseInt(request.getParameter("id"));
String pwd=request.getParameter("pwd");

//String publishdate="修改于"+new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss").format(new Date());

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");

String sql="update gly set password='"+pwd+"'where id="+id;
//out.print(sql);
Statement stmt=con.createStatement();
stmt.executeUpdate(sql);
con.close();
out.print("<script language='javascript'>alert('保存成功！');location.href='chakan1.jsp?id="+id+"';</script>");
%>