updatebook_db.jsp

网上书店网站源代码

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<%! 
    String id=new String();
    String name=new String();
	String author=new String();
	String press=new String();
	String price=new String(); 
	String note=new String();
%>
<% 
       id=request.getParameter("id");
	   pass1=request.getParameter("text2");
	  String sex=new String(request.getParameter("text3").trim().getBytes("8859_1"));
	   //sex=request.getParameter("text3");
	   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:bookstore");
		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("loginuser")+"'";
		st.executeUpdate(sql);
		System.out.println("已经成功的修改");
		st.close();
		con.close();
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
%>
<style type="text/css">
<!--
.style1 {
	font-size: 18px;
	color: #0000FF;
	font-weight: bold;
}
-->
</style>