📄 jieshu2.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Exception.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.util.*"%>
<%
//数据库连接
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("condition1")!=null)
{
GregorianCalendar now = new GregorianCalendar();
SimpleDateFormat df =new SimpleDateFormat("yyyy-MM-dd",Locale.US);
String mDateTime= df.format(now.getTime()) ;
//out.println("当前时间"+mDateTime);
String condition1=request.getParameter("condition1");
String condition2=request.getParameter("condition2");
String condition3=request.getParameter("condition3");
String condition4=request.getParameter("condition4");
condition2 = new String(condition2.getBytes("ISO-8859-1"), "GBK");
condition4 = new String(condition4.getBytes("ISO-8859-1"), "GBK");
String sql1="select study_id,study_name from xinxi_study where study_id = '"+condition1+"' and study_name = '"+condition2+"'";
ResultSet result1=stmt.executeQuery(sql1);
//out.println(sql1);
if (result1.next())
{
String sql2="select book_id,book_name from xinxi_book where book_id = '"+condition3+"' and book_name ='"+condition4+"'";
ResultSet result2=stmt.executeQuery(sql2);
//out.println(sql2);
if(result2.next())
{
String sql="insert into xinxi_jieshu (jieshu_study_id,jieshu_study_name,jieshu_book_id,jieshu_book_name,jieshu_date)"+
"values('"+condition1+"','"+condition2+"','"+condition3+"','"+condition4+"','"+mDateTime+"')";
//out.prinln(sql)
//ResultSet result1
//stmt.executeQuery(sql);
out.println("<br>");
out.println("<p>");
out.println("<center>");
int n=stmt.executeUpdate(sql);
if(n>0 )
{
out.println("借书成功"+"<p>");
out.println(condition2+"同学 请保管好你的图书"+"<p>");
String sql3="update xinxi_book set book_amount = book_amount - 1" + "where book_id = "+"'"+condition3+"'" ;
//out.println(sql3);
stmt.executeUpdate(sql3);
}
else
{
out.println("操作未完成");
}
}
else
{
out.println("信息错误，请核对图书的信息");
}
}else{
out.println("信息错误，请核对你的信息");
}
stmt.close();
con.close();
}
%>
<html>
<body>
<A href="jieshu.jsp">返回上一页</A>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -