xinwen2.jsp~29~

来自「JAVA实验图形 =各种 的 JAVA简单代码 出初学者必备！！！！！！！！！」· JSP~29~ 代码 · 共 39 行

<%@page language="java" contentType="text/html; charset=GBK"%>
<%@page import="java.sql.*"%><%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%request.setCharacterEncoding("gb2312");%>
<%!
String xinwenname,xinwentype,xinwenshuoming;
%>
<%
    xinwenname=request.getParameter("xinwenname");
   xinwentype=request.getParameter("xinwentype");
    xinwenshuoming=request.getParameter("xinwenshuoming");
//用于获取图皮
String filename=request.getParameter("xinwentupian");
FileInputStream in=new FileInputStream(filename);
  try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            //定义JDBC URL
        }catch (Exception e) {}
          try{

            String url = "jdbc:odbc:s";
            //得到与数据库的连接
            Connection con = DriverManager.getConnection(url);
            //显示UPL和连接信息
            Statement stmt=con.createStatement();
            String sql = "insert into xinwen(xinwenname,xinwentype,xinwenshuoming,xinwentupian) VALUES(?,?,?)";
           PreparedStatement pstmt=con.prepareStatement(sql);
            pstmt.setString(1,xinwenname);
            pstmt.setString(2,xinwentype);
            pstmt.setString(3,xinwenshuoming);
            //读取图片
         pstmt.execute();
            con.close();
            response.sendRedirect("xinwenshow.jsp");
            return;
          }
            catch (Exception e) {}
   %>