index6.jsp

WEB图书馆系统,jsp编写,适用用于JSP的初始者

<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Exception.*"%>
<%
//数据库连接
String url="jdbc:odbc:xuesheng";
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
  Connection con=DriverManager.getConnection(url);
  Statement stmt=con.createStatement();
  //ResultSet result=stmt.executeQuery("update xinxi_book set");
  //ResultSetMetaData resultmd=result.getMetaData();

//if(request.getParameter("condition5")!=null&&request.getParameter("condition4")!=null&&request.getParameter("condition3")!=null&&request.getParameter("condition52")!=null&&request.getParameter("condition1")!=null)
if(request.getParameter("condition5")!=null)
{
    String condition1=request.getParameter("condition1");
    String condition2=request.getParameter("condition2"); 
    String condition3=request.getParameter("condition3");
    String condition4=request.getParameter("condition4");
    String condition5=request.getParameter("condition5");


condition2 = new String(condition2.getBytes("ISO-8859-1"), "GBK"); 
condition3 = new String(condition3.getBytes("ISO-8859-1"), "GBK");
String sql="insert into xinxi_book (book_id,book_name,book_author,book_prices,book_amount)"+
	"values('"+condition1+"','"+condition2+"','"+condition3+"','"+condition4+"','"+condition5+"')";
//ResultSet result1
//stmt.executeQuery(sql);
out.println("<br>");
//out.println(sql);
out.println("<p>");
out.println("<center>");
int n=stmt.executeUpdate(sql);
if(n>0)
{
	out.println("成功入库");
}
else
{
	out.println("操作未完成");
}
out.println("<p>");
out.println("书号:"+condition1+"<p>");
out.println("书名:"+condition2+"<p>");
out.println("作者:"+condition3+"<p>");
out.println("价格:"+condition4+"<p>");
out.println("数量:"+condition5+"<p>");


stmt.close();
con.close();
}
%>