Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

JSPÖÐÁ¬½Óoracle

Ê×ÏÈÔÚweb-inf/libÏÂÌí¼ÓoracleÊý¾Ý¿âÇý¶¯class12.jar
<%
        Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();  
        String url = "jdbc:oracle:thin:@172.16.218.20:1521:hzdb";
        String user = "sunzags";
        String password = "sunzags";
        Connection conn = DriverManager.getConnection(url,user,password);
        Statement stmt = null;
        ResultSet rs = null;
        List<String> appList = new ArrayList();
        String app = "";
        try{
                stmt = conn.createStatement();  
                String sql = "select FEATURECODE from TBDICGISFEATURE where FEATUREID in (select FEATUREID from TBRELAPPFEATURE where APPID=8)";  
                rs = stmt.executeQuery(sql);  
                while(rs.next()) {
                        app = rs.getString("FEATURECODE");
                        appList.add(app);
                   


Ïà¹ØÎĵµ£º

ÎÒµÄJSPѧϰ±Ê¼Ç JSPÒ³ÃæÖеÄÖ¸Áî

JSPµÄÖ¸ÁîÊÇÓÃÀ´°üº¬ÍⲿÎļþ»òÊǽøÐÐÒ³ÃæÈ«¾ÖÉèÖõģ»ËüµÄÓÐÈýÖÖ£¬·Ö±ðÊÇpage£¬include£¬taglibÖ¸Áî
1.pageÖ¸Áî
 ÐÎÈç<%@page ÊôÐÔ='Öµ'    ÊôÐÔ='Öµ'   ........ %>
 ÊôÐÔÓУº
 language=''java''   £º É趨jspÒ³ÃæµÄ½Å±¾ÓïÑÔ£¬Ä¿Ç°Ö»Ö§³Öjava£¬Ä¬ÈÏÊÇjava ......

½«jspÍøÒ³Êý¾ÝÊä³öΪExcel»òWordÎļþ

½«Ò»¸öJSPÒ³ÃæÖеÄ<%@ page contentType="text/html; charset=GBK" language="java" %>Ìæ»»Îª
<%@ page contentType="application/vnd.ms-Excel;charset=GBK" language="java"%> //Excel
»ò
<%@ page contentType="application/vnd.ms-word;charset=GBK" language="java"%> //Word
ÔÚÒ³Ãæ¿ªÊ¼Êä³öÊý¾ ......

jspÖÐÎÄÂÒÂë½â¾ö·½°¸


1¡¢jspÒ³ÃæÂÒÂ룺
ÔÚjspÒ³Ãæ¿ªÊ¼Ìí¼Ó<%pageEncoding="uft-8"%>
2¡¢servletÊä³öÂÒÂ룺
ÔÚÊä³öÄÚÈÝ֮ǰ£¬ÏÈÖ´ÐÐresponse.setContentType
("text/html;charset=utf-8")
3¡¢ÔÚformÀïÓÃpost·½Ê½Ìá½»²ÎÊý£º
1£©½ÓÊÕʱ¼Órequest.setCharacterEncoding("utf-8")
2£©Ê¹ÓùýÂËÆ÷£¬ÔÚ½ÓÊÕ²ÎÊý֮ǰ£¬É趨´«µÝµÄ²ÎÊýÄ ......

jspÉÏ´«Í·ÏñÒÔ¼°Éú³ÉËõÂÔͼ


<%@ page autoFlush="false" contentType="text/html;charset=utf-8" language="java" import="java.io.*,java.awt.Image,java.awt.image.*,com.sun.image.codec.jpeg.*,java.sql.*,com.jspsmart.upload.*,java.util.*,java.io.FileInputStream,java.io.FileOutputStream,java.awt.*"%>
<%@ page import="com.b ......

oracle+jspÖÐblobÀàÐÍ´æ´¢´óÎı¾ÎÊÌâ½â¾ö·½·¨


 
 
 
 
 
oracle+jspÖÐblobÀàÐÍ´æ´¢´óÎı¾ÎÊÌâ½â¾ö·½·¨
oracle ´æ´¢´óÎı¾Ò»Ö±ÊÇÒ»¸ö¼¬ÊÖµÄÎÊÌâ¡£
Ò»¡¢´æÊý¾Ý¿â£º
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
//¶¨Òå±äÁ¿
java.sql.Connection conn; //Êý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ