lx1.jsp
来自「--- --^_^-------------- 广师公寓中心 1.请装上」· JSP 代码 · 共 53 行
JSP
53 行
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*,java.util.Date,java.text.*" %>
<%
SimpleDateFormat formatter = new SimpleDateFormat( "yyyy-MM-dd hh:mm:ss" );
Date date=new Date();
String booktime = formatter.format(date);
%>
<%!
String name="";
String word="";
%>
<%
request.setCharacterEncoding("gb2312");
name=request.getParameter("MbName");
word=request.getParameter("TxtContent");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
try{
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
strDirPath=application.getRealPath("ODBC/gongyu.mdb");
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath;
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String sql="insert into liuyan(word,name,shijian) values('"+word+"','"+name+"','"+booktime+"')";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(Exception ex)
{
out.print(ex);
}
%>
<jsp:forward page="lx.jsp"/>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?