?? act.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:numb1");
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = st.executeQuery("select id from lyb");
rs.last();
int no;
if(rs.getRow()!=0){
no=rs.getInt(1);
no++;
}else{no=1;}
rs.close();
request.setCharacterEncoding("gb2312");
String title=request.getParameter("title");
String name=request.getParameter("name");
String mail=request.getParameter("mail");
String web=request.getParameter("web");
String qq=request.getParameter("qq");
String txt=request.getParameter("text");
String ip=request.getRemoteAddr();
String id=""+no;
String sql="insert into lyb values("+id+",'"+title+"','"+name+"','"+mail+"','"+web+"','"+qq+"','"+ip+"',now(),'"+txt+"','','n')";
st.executeUpdate(sql);
st.close();
con.close();
response.sendRedirect("index.jsp");
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -