ÈçºÎÓÃjspÁ¬½Ópostgresql£¿Íò·Ö¸Ðл£¡
ÎÒ¸Õ¸Õ½Ó´¥postgresql£¬²»ÖªµÀÄÜ·ñÓÃjspÁ¬½Ópostgresql¡£ÍøÉÏÏà¹Ø×ÊÁϺÜÉÙ£¬Íû´óϺÃÇÖ¸½Ì£¡Ð¡Å®×Óߵл£¡£¡
ĿǰÎÒ¿´µ½µÄ×éºÏ¶¼ÊÇ£ºPHP+Apache+Postgresql
ÊÇ·ñ¿ÉÒÔÓãºJSP+TOMCAT+Postgresql??
Çë˵ϾßÌå·½·¨£¡£¡Íò·Ö¸Ðл£¡£¡
JSP »òÕß java Á¬½ÓÆäËüÊý¾Ý¿âÄãÊÇÈçºÎʵÏֵģ¿
<%@ page contentType="text/html;charset=UTF-8"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.postgresql.Driver").newInstance();
String url ="jdbc:postgresql://localhost:5432/dbTest" //dbTestΪÄãµÄÊý¾Ý¿âÃû
String user="postgres";
String password="postgres";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
ÄúµÄµÚÒ»¸ö×Ö¶ÎÄÚÈÝΪ£º <%=rs.getString(1)%>
ÄúµÄµÚ¶þ¸ö×Ö¶ÎÄÚÈÝΪ£º <%=rs.getString(2)%>
<%}%>
<%out.print("Êý¾Ý¿â²Ù×÷³É¹¦!!!");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
²»Ðа¡£¬ÏÔʾÓдíÎó¡£
org.apache.jasper.JasperException: Unable to compile class for JSP.
ÎÒÔÚ»·¾
Ïà¹ØÎÊ´ð£º
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
ÎҵijÌÐòÈçÏ£º
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv=&q ......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
×î½üÓöµ½Ò»Ð© jspÒ³ÃæµÄȡֵ¡£Ã»Óмû¹ý¡£Ò²²»ÖªµÀʲôÒâ˼¡£ÄÄλ´óÏÀ¸øÎÒ˵˵ ȡֵµÄÖÖÀàºÍ·½·¨°¡
request.getParameter£¬»òÕßÓÃbean£¬¼´ÔÚjspÒ³ÃæÖÐÉùÃ÷jsp:usebeanÖ®ºó¿ÉÒÔÖ±½Ósetproperty »òÕßgetproperty¡£Ò ......