📄 mid.jsp

📁 这个一个用J2EE弄的使用JDBC实现对网页美容的分页显示的例子
💻 JSP
字号:
<%--     Document   : mid    Created on : 2009-4-14, 17:57:38    Author     : Administrator--%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"   "http://www.w3.org/TR/html4/loose.dtd"><%@page contentType="text/html;charset=gb2312"%><%@page import="java.sql.*"%><%request.setCharacterEncoding("GBK");java.sql.Connection conn=null;java.lang.String strConn;java.sql.PreparedStatement preparedStmt=null;//语句对象java.sql.Statement sqlStmt=null;//语句对象java.sql.ResultSet sqlRst=null;//结果对象try{Class.forName("org.gjt.mm.mysql.Driver").newInstance();conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/","root","root");sqlStmt=conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);//执行SQL语句     String sqlQuery="create database if not exists student;";     int n=sqlStmt.executeUpdate(sqlQuery);     if(n==0){     String sqlQuery1="USE student;";         String sqlQuery2=""       +"DROP TABLE IF EXISTS ff;";          String sqlQuery3=""       +"CREATE TABLE if not exists ff ("       +"SNO char(10) default NULL,"       +"SNA  char(12) default NULL,"       +"PHONE char(18) default NULL"       +" ) ENGINE=InnoDB DEFAULT CHARSET=gbk;"       ;     int m=sqlStmt.executeUpdate(sqlQuery1);         //m=sqlStmt.executeUpdate(sqlQuery2);         m=sqlStmt.executeUpdate(sqlQuery3);     }     System.out.println(n);     preparedStmt=conn.prepareStatement("INSERT INTO ff(SNO,SNA,PHONE) VALUES(?,?,?)");     String parm11=request.getParameter("parm1");    String parm22=request.getParameter("parm2");    String parm33=request.getParameter("parm3");    if(parm11!=null)preparedStmt.setString(1,parm11);    if(parm22!=null)preparedStmt.setString(2,parm22);    if(parm33!=null)preparedStmt.setString(3,parm33);    boolean m=preparedStmt.execute();    //sqlRst=preparedStmt.executeQuery("SELECT* FROM ff;"); }catch(java.sql.SQLException e){ out.println(e.toString()); }finally{//关闭结果集对象    if(sqlRst!=null)try{sqlRst.close();}catch(java.sql.SQLException e1){        out.println(e1.toString());}finally{    try{        //关闭语句对象        if(sqlStmt!=null)sqlStmt.close();        }catch(java.sql.SQLException e2){            out.println(e2.toString());            }    finally{        try{            //关闭数据库连接            if(conn!=null)conn.close();            }        catch(java.sql.SQLException e3){            out.println(e3.toString());          }        }      }    }%><html>    <head>        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">        <title>数据成功导入到数据库</title>    </head>    <body bgcolor="black" text="red">                <hr align="center" width="600" size="1" color="#0000FF">        <center><h1><marquee direction="left" behavior="alternate">您输入的数据已经成功导入到数据库!</marquee></h1></center>        <hr align="center" width="600" size="1" color="#0000FF">         <table  align="center" border="1" width="80%" bordercolorlight="#0000FF" cellpadding="2" bordercolordark="FFFFFF" cellspacing="0">            <tr>                <td align="center">                    <a href="UseJavaBean.jsp">继续向数据库录数据</a>                </td>                <td align="center">                    <a href="page.jsp">查看已录入的数据</a>                </td>            </tr>        </table>    </body></html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -