📄 addmessagetodb.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%
/**
* Title: 使用JSP创建留言板
* Description: 教学示范
* Copyright: Copyright (c) 2003
* Company: 北京师范大学计算机系
* @author 孙一林
* @version 1.0
*/
%>
<html>
<%@ page language="java" import="java.sql.*"%>
<head>
<title>添加留言成功</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
String title = new String(request.getParameter("title").getBytes("8859_1")); //获取用户留言信息
String userName = new String(request.getParameter("userName").getBytes("8859_1"));
String message = new String(request.getParameter("messageField").getBytes("8859_1"));
Date curDate = new Date(new java.util.Date().getTime()); //获取用户留言时间
String time = curDate.toLocaleString();
Connection connection = null; //定义与数据库进行连接的Connection对象
Statement statement = null; //定义查询数据库的Statement对象
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //指定与数据库连接使用JDBC-ODBC桥驱动程序
String url = "jdbc:odbc:MessageBoard"; //指定数据源名
connection = DriverManager.getConnection(url); //与数据源建立连接
statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //创建Statement接口实例
String sql = "insert into MessageBoard(MessageTitle, MessageDate, MessageUser, MessageContent) values ('" + title + "', '" + time + "', '" + userName + "', '" + message + "')"; //创建向MessageBoard表中插入数据的SQL语句
statement.executeUpdate(sql); //向表中插入数据
}
catch(SQLException ex){ //捕捉异常
System.out.println("\nERROR:----- SQLException -----\n");
while (ex != null) {
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex ) {
ex.printStackTrace();
}
finally {
try {
if(statement != null)
{
statement.close(); //关闭Statement接口实例
}
if(connection != null)
{
connection.close(); //关闭Connection接口实例
}
}
catch (SQLException ex) {
System.out.println("\nERROR:----- SQLException -----\n");
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
}
}
%>
<p align="center">留言成功</p>
<p align="center"><a href="ShowMessage.jsp?pageNumber=0">返回主页</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -