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

JSPÁ¬½ÓACCESSÊý¾Ý¿âµÄ¼òµ¥´úÂë

Á¬½ÓACCESSÊý¾Ý¿âµÄ¼òµ¥JSP´úÂ룺
  <%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=" + application.getRealPath("jsp.mdb"); //ÓëJSPÎļþͬһĿ¼ÏµÄACCESSÊý¾Ý¿âÎļþÃû£ºjsp.mdb
Connection conn = DriverManager.getConnection(url,"",""); //Á¬½ÓACCESSÊý¾Ý¿â£¨url,"Óû§Ãû","ÃÜÂë"),Ϊ¿Õ¼´Ã»ÓÐÉèÖÃÊý¾ÝµÄµÇ¼ÃÜÂë¡£
Statement stmt=conn.createStatement();

String sql="select * from login"; //¹¹ÔìSQLÓï¾ä

ResultSet rs=stmt.executeQuery(sql);

while(rs.next()){
int id=rs.getInt("id"); //µÃµ½Êý¾Ý¿âÀïÃæµÄ×Ö¶ÎidµÄÖµ¡£
String username=rs.getString("username"); //µÃµ½Êý¾Ý¿âÀïÃæµÄ×Ö¶ÎusernameµÄÖµ¡£
String password=rs.getString("password");
}

//¹Ø±ÕÓëÊý¾Ý¿âµÄÁ¬½Ó
rs.close();
stmt.close();
conn.close();

}
catch(Exception e)
{
e.printStackTrace();
}
%>

</table>
</center>
<html>
<head>
<title>Á¬½ÓÊý¾Ý¿â</title>
</head>
<body>
</body>
</html>


Ïà¹ØÎĵµ£º

Douyu»áÊÇSSH¹¹¼ÜÓëJSP/Servlet¼¼ÊõµÄÖÕ½áÕßÂð?

 DouyuÊÇÒ»ÖÖÍêÈ«²ÉÈ¡JavaÓïÑÔ¿ª·¢µÄ¡¢ÔË×÷ÓÚJVMÒÔÉϵÄÐÂʽ»ù´¡¿ª·¢Æ½Ì¨¡£
ÔÚweb²ã£¬DouyuÍêÈ«ÒÅÆúÁËJSP/Servlet£¬
ÔÚÊý¾Ý¿â·ÃÎʲ㣬Douyu²»ÒÀÀµÓÚÈκÎORM(¶ÔÏñ¹ØÏµÕÕÉä)¹¹¼Ü(ÈçHibernate)¡£
Douyu½«JavaÓïÑÔ±àÒëÆ÷¡¢Http·þÎñÆ÷¡¢MVCÔ²Âúµ÷ÕûÔÚÒ»Æð£¬
²îµã¶ù¶ÒÏÖÁËORMÈ«×Ô¶¯»¯£¬Í¬Ê±ÔÚJavaÓïÑÔ²ãÃæÒý³öÁËȨÏÞÖ ......

asp jspʵս´úÂë

 Ì½Ë÷Èí¼þ¹¤×÷ÊÒ³¤ÆÚרҵ³Ð½ÓÖÐСÐÍÉÌÒµÈí¼þ»òÍøÕ¾£¬×îÓŻݵļ۸ñºÍ¸ßÖÊÁ¿µÄ·þÎñÆÚ´ýÄúµÄ»Ý¹Ë£¡
±¾¹¤×÷ÊÒ³Ð½Ó JSP ASP  VB  PB  LotusNotes µÈÓïÑÔÒªÇóµÄÓ¦ÓÃϵͳ¿ª·¢ÒµÎñ
java jspʵսԴ³ÌÐò´úÂë:
                ......

½¨Á¢JSP開發環¾³

 1.  JRE °²裝 (¿É從 http://java.sun.com/ÏÂ載)
       Java SE Runtime Environment (JRE)   JRE 6 Update 17
 2.  JDK°²裝   (¿É從 http://java.sun.com/ÏÂ載)
      Java SE ......

c#²Ù×÷accessÊý¾Ý¿â

 using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace AddressList
{
public partial class FrmAccessUse : Form
{
public Fr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ