////////留言本程序///////////<%-- MySQL数据文件 gb.sql
CREATE TABLE gb (
name varchar(50) NOT NULL,
content varchar(250) NOT NULL,
time varchar(50) NOT NULL
);--%><%-- 留言本程序文件 gb.jsp --%>
<%@ page contentType="text/html; charset=gb2312" %>
<HTML><BODY bgcolor="#FFFFFF" text="#0000C0">
<FORM method="POST" action=gb.jsp>
<INPUT type="text" name="name" size="21" value="姓名和留言" onFocus="this.value=''">
<BR><TEXTAREA rows="4" name="content" cols="20"></TEXTAREA>
<INPUT type="submit" value="提交">
</FORM>
<%
// 初始化
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
java.sql.Connection sqlConn
= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/gb","root","111111");
java.sql.Statement sqlStmt = sqlConn.createStatement();
// 写入数据
sqlStmt.executeUpdate("insert into gb(name,content,time)"
+ "values('" + request.getParameter("name")+ "','" + request.getParameter("content")
+ "','" + new java.util.Date() + "');"
);
// 读取数据
java.sql.ResultSet sqlRst = sqlStmt.executeQuery("select * from gb;");
while (sqlRst.next()) {
out.println("<B STYLE='FONT-SIZE:9pt'>" + sqlRst.getString("name")
+ ":</B><FONT STYLE='FONT-SIZE:9pt;COLOR:#C00000'> " + sqlRst.getString("content")
+ "</FONT><FONT STYLE='FONT-SIZE:9pt;COLOR:#CCCCCC'> @ " + sqlRst.getString("time")
+ "</FONT><BR>");
}
sqlStmt.close();
sqlConn.close();
%>
</body></html>
CREATE TABLE gb (
name varchar(50) NOT NULL,
content varchar(250) NOT NULL,
time varchar(50) NOT NULL
);--%><%-- 留言本程序文件 gb.jsp --%>
<%@ page contentType="text/html; charset=gb2312" %>
<HTML><BODY bgcolor="#FFFFFF" text="#0000C0">
<FORM method="POST" action=gb.jsp>
<INPUT type="text" name="name" size="21" value="姓名和留言" onFocus="this.value=''">
<BR><TEXTAREA rows="4" name="content" cols="20"></TEXTAREA>
<INPUT type="submit" value="提交">
</FORM>
<%
// 初始化
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
java.sql.Connection sqlConn
= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/gb","root","111111");
java.sql.Statement sqlStmt = sqlConn.createStatement();
// 写入数据
sqlStmt.executeUpdate("insert into gb(name,content,time)"
+ "values('" + request.getParameter("name")+ "','" + request.getParameter("content")
+ "','" + new java.util.Date() + "');"
);
// 读取数据
java.sql.ResultSet sqlRst = sqlStmt.executeQuery("select * from gb;");
while (sqlRst.next()) {
out.println("<B STYLE='FONT-SIZE:9pt'>" + sqlRst.getString("name")
+ ":</B><FONT STYLE='FONT-SIZE:9pt;COLOR:#C00000'> " + sqlRst.getString("content")
+ "</FONT><FONT STYLE='FONT-SIZE:9pt;COLOR:#CCCCCC'> @ " + sqlRst.getString("time")
+ "</FONT><BR>");
}
sqlStmt.close();
sqlConn.close();
%>
</body></html>
<head>
The first Jsp program
<br>
</head>
<body>
<%@page language="java"%>
<hr>
<%out.print("Hello World!");%>
<br>
Today is <%
java.util.Date date=new java.util.Date();
out.println(date);
%>
</body>
</html>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@erdos00:1521:erdos";
//String image_id = (String) request.getParameter("id");
//out.print(image_id);
Connection con=DriverManager.getConnection(url,"system","manager");
PreparedStatement sql=con.prepareStatement("select * from blob_test WHERE rno =14" );
ResultSet rs = sql.executeQuery();
rs.next();
//输入img字段内容到in
InputStream in = rs.getBinaryStream("photo");
//out.println("22222222222222");//以下可是任何处理,比如向页面输出:response.reset();
//此处的image/jpeg似乎与显示的图片格式无关
//因为我显示jsp和gif都没有错误
//out.println("22222222222222");
response.setContentType("image/bmp");
// 把bmp用
byte[] b = new byte[1024*1024];
int len;
while((len=in.read(b)) >0)
response.getOutputStream().write(b,0,len);in.close();
rs.close();
%>