book_db.jsp

网上书店网站源代码

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<% 
String id=(String)session.getAttribute("id");
String name=(String)session.getAttribute("name");
String author=(String)session.getAttribute("author");
String press=(String)session.getAttribute("press");
String price=(String)session.getAttribute("price");
String note=(String)session.getAttribute("note");
       Connection con;
		Statement st;


		try
		{
		System.out.println("正在连接数据库");
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:bookstore");
		st=con.createStatement();%>
		<%String sql="insert into b_book values('   "+id+"   ',' "+name+"','"+author+"',' "+press+"',' "+price+"',' "+note+"')";
		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>
<span class="style1">恭喜，添加成功！！！</span>