🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

🏠 Home 📰 News 🗂️ Usenet Search 🔑 Login 📝 Register
Article View: cn.bbs.comp.lang.java
Article #12985
Back to cn.bbs.comp.lang.java Previous Next

JSP������ݿ��ȫ

#12985
From: ���|{�����ɱ�}
Date: Tue, 13 Jul 2004 02:24
203 lines
8924 bytes 
 
�����кö��ѧJSP�����Ѿ���������ݿ���ô���Ӱ�����ô�ϳ��?�������Ҽ��е�����дƪ���¹���Ҳο�����ʵ���ְ���ݿ��߼�ȫ������JSP��δ���Ǻõ����������������ڳ�ѧ��ѧϰ�������Ҿ��������ˣ������ѧ��һ���̶ȵ�ʱ�򣬿��Կ�����MVC��ģʽ����������ϰ��Щ����
��ʱ����һ����JDBC�������ŵ�����������·���Ȼ��Ҫ����ݿ��ｨһ����TEST,�������ֶα���ΪTEST1��TEST2������������SQL��  
CREATE TABLE TEST(TEST1 VARCHAR(20),TEST2 VARCHAR(20) 
Ȼ���������д��һ�����Լ�¼  
��ô���ڿ�ʼ���ǵ�JSP����ݿ�֮�ðɡ�  

һ��JSP����ORACLE8/8I/9I��ݿ⣨��THINģʽ��  
TESTORACLE.JSP���£�  
<%@ PAGE CONTENTTYPE="TEXT/HTML;CHARSET=GB2312"%> 
<%@ PAGE IMPORT="JAVA.SQL.*"%> 
<HTML>  
<BODY>  
<%CLASS.FORNAME("ORACLE.JDBC.DRIVER.ORACLEDRIVER").NEWINSTANCE();  
STRING URL="JDBC:ORACLE:THIN:@LOCALHOST:1521:ORCL"; 
//ORCLΪ�����ݿ��SID  
STRING USER="SCOTT"; 
STRING PASSWORD="TIGER"; 
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>  
  
����JSP����SQL SERVER7.0/2000��ݿ� 
TESTSQLSERVER.JSP���£�  
<%@ PAGE CONTENTTYPE="TEXT/HTML;CHARSET=GB2312"%> 
<%@ PAGE IMPORT="JAVA.SQL.*"%> 
<HTML>  
<BODY>  
<%CLASS.FORNAME("COM.MICROSOFT.JDBC.SQLSERVER.SQLSERVERDRIVER").NEWINSTANCE();  
STRING URL="JDBC:MICROSOFT:SQLSERVER://LOCALHOST:1433;DATABASENAME=PUBS"; 
//PUBSΪ�����ݿ��  
STRING USER="SA"; 
STRING PASSWORD=""; 
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>  
  
��JSP����DB2��ݿ�  
TESTDB2.JSP���£�  
<%@ PAGE CONTENTTYPE="TEXT/HTML;CHARSET=GB2312"%> 
<%@ PAGE IMPORT="JAVA.SQL.*"%> 
<HTML>  
<BODY>  
<%CLASS.FORNAME("COM.IBM.DB2.JDBC.APP.DB2DRIVER ").NEWINSTANCE(); 
STRING URL="JDBC:DB2://LOCALHOST:5000/SAMPLE"; 
//SAMPLEΪ�����ݿ���  
STRING USER="ADMIN"; 
STRING PASSWORD=""; 
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>  
  
�ġ�JSP����INFORMIX��ݿ�  
TESTINFORMIX.JSP���£�  
<%@ PAGE CONTENTTYPE="TEXT/HTML;CHARSET=GB2312"%> 
<%@ PAGE IMPORT="JAVA.SQL.*"%> 
<HTML>  
<BODY>  
<%CLASS.FORNAME("COM.INFORMIX.JDBC.IFXDRIVER").NEWINSTANCE();  
STRING URL = 
"JDBC:INFORMIX-SQLI://123.45.67.89:1533/TESTDB:INFORMIXSERVER=MYSERVER;  
USER=TESTUSER;PASSWORD=TESTPASSWORD";  
//TESTDBΪ�����ݿ���  
CONNECTION CONN= DRIVERMANAGER.GETCONNECTION(URL); 
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>  
  

�塢JSP����SYBASE��ݿ�  
TESTMYSQL.JSP���£�  
<%@ PAGE CONTENTTYPE="TEXT/HTML;CHARSET=GB2312"%> 
<%@ PAGE IMPORT="JAVA.SQL.*"%> 
<HTML>  
<BODY>  
<%CLASS.FORNAME("COM.SYBASE.JDBC.SYBDRIVER").NEWINSTANCE();  
STRING URL =" JDBC:SYBASE:TDS:LOCALHOST:5007/TSDATA"; 
//TSDATAΪ�����ݿ���  
PROPERTIES SYSPROPS = SYSTEM.GETPROPERTIES(); 
SYSPROPS.PUT("USER","USERID");  
SYSPROPS.PUT("PASSWORD","USER_PASSWORD");  
CONNECTION CONN= DRIVERMANAGER.GETCONNECTION(URL, SYSPROPS); 
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>  
  
��JSP����MYSQL��ݿ�  
TESTMYSQL.JSP���£�  
<%@ PAGE CONTENTTYPE="TEXT/HTML;CHARSET=GB2312"%> 
<%@ PAGE IMPORT="JAVA.SQL.*"%> 
<HTML>  
<BODY>  
<%CLASS.FORNAME("ORG.GJT.MM.MYSQL.DRIVER").NEWINSTANCE();  
STRING URL ="JDBC:MYSQL://LOCALHOST/SOFTFORUM?USER=SOFT&PASSWORD=SOFT1234&USEUNICODE=TRUE&CHARACTERENCODING=8859_1" 
//TESTDBΪ�����ݿ���  
CONNECTION CONN= DRIVERMANAGER.GETCONNECTION(URL); 
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>  
  
�ߡ�JSP����POSTGRESQL��ݿ�  
TESTMYSQL.JSP���£�  
<%@ PAGE CONTENTTYPE="TEXT/HTML;CHARSET=GB2312"%> 
<%@ PAGE IMPORT="JAVA.SQL.*"%> 
<HTML>  
<BODY>  
<%CLASS.FORNAME("ORG.POSTGRESQL.DRIVER").NEWINSTANCE();  
STRING URL ="JDBC:POSTGRESQL://LOCALHOST/SOFT" 
//SOFTΪ�����ݿ���  
STRING USER="MYUSER"; 
STRING PASSWORD="MYPASSWORD"; 
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>  


--
http://bbs.tju.edu.cn/TJUBBS/attach/bbscon/user688.jpg?B=Pictures&F=M.1088776759.A&attachpos=168&attachname=/user688.jpg
����˵������˵�߾��ߣ�ֻ���������������....


�� ��Դ:�������ʵBBS bbs.tju.edu.cn��[FROM: 202.113.13.188]
Technical Details
Message-ID: <4DD9aL$AeM@bbs.tju.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news.linkpendium.com!news.linkpendium.com!news.moat.net!ctu-peer!news.nctu.edu.tw!netnews.csie.nctu.edu.tw!maily.cic.tsinghua.edu.cn!news2.happynet.org!TJUBBS

Show Full Headers
Complete Article Headers 
X-Google-Thread: f6cb0,4293baa60577fc7,start
X-Google-Attributes: gidf6cb0,public
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news.linkpendium.com!news.linkpendium.com!news.moat.net!ctu-peer!news.nctu.edu.tw!netnews.csie.nctu.edu.tw!maily.cic.tsinghua.edu.cn!news2.happynet.org!TJUBBS
From: bigbug.bbs@bbs.tju.edu.cn.no.spam (���|{�����ɱ�})
Newsgroups: cn.bbs.comp.lang.java
Subject: JSP������ݿ��ȫ
Date: 13 Jul 2004 02:24:21 GMT
Organization: �����ʵBBSվ
Message-ID: <4DD9aL$AeM@bbs.tju.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: Java/M.1089685461.A
Lines: 203