update_db.jsp

来自「网上书店网站源代码」· JSP 代码 · 共 43 行

<%@ page contentType="text/html;charset=utf-8" %>
<%@ page import="java.sql.*" %> 
<%! 
    String name=new String().trim();
    String pass=new String().trim();
	String pass1=new String().trim();
	String sex=new String().trim();
	String birthday=new String().trim();
	String mail=new String().trim(); 
	String address=new String().trim();
	String phone=new String().trim();
%>
<% 
       pass=request.getParameter("text2");
	   pass1=request.getParameter("text2");
	   sex=request.getParameter("text3").getBytes("8859_1");
	   birthday=request.getParameter("text4");
	   mail=request.getParameter("text5");
	   address=request.getParameter("text6");
	   phone=request.getParameter("text7");
       Connection con;
		Statement st;
		try
		{
		System.out.println("a");
		System.out.println("正在连接数据库");
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		System.out.println("b");
		con=DriverManager.getConnection("jdbc:odbc:book");
		System.out.println("c");
		st=con.createStatement();
		System.out.println("d");
		String sql="update b_user set u_pass='"+pass+"',u_sex='"+sex+"',u_birthday='"+birthday+"',u_mail='"+mail+"',u_address='"+address+"',u_phone='"+phone+"'where u_name='"+session.getAttribute("u_name")+"'";
		st.executeUpdate(sql);
		System.out.println("已经成功的修改");
		st.close();
		con.close();
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
%>