£¨ÇóÖú£©Ò»¸öJavaÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣡
ÏÂÃæÊÇÎÒдµÄÒ»¸ö²Ù×÷Êý¾Ý¿âµÄ¼òµ¥³ÌÐò
Java code:
import java.sql.*;
public class Gradation {
static Connection con;
static Statement sql;
static ResultSet res;
public Connection getConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Êý¾Ý¿âÇý¶¯¼ÓÔسɹ¦");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
try{
con = DriverManager.getConnection("jbdc:odbc:javaicq","","");
System.out.println("Êý¾Ý¿âÁ¬½Ó³É¹¦");
}catch(SQLException e){
e.printStackTrace();
}
return con;
}
public static void main(String[] args) {
Gradation c = new Gradation();
con = c.getConnection();
try{
sql = con.createStatement();
res = sql.executeQuery("select * from student");
while(res.next()){
String id = res.getString("id");
String name = res.getString("name");
int age = res.getInt(3);
System.out.println("±àºÅ£º "+id);
System.out.println("ÐԱ𣺠"+name);
System.out.println("±àºÅ£º "+age);
Ïà¹ØÎÊ´ð£º
ͨ¹ýjava³ÌÐò£¬ÏȱàÒëc³ÌÐò£¬Èç³öÏÖ´íÎó£¬ÌáʾC³ÌÐòÖеĴíÎ󣬱àÒë³É¹¦¾ÍÔËÐУ¬ÏÔʾCµÄÔËÐнá¹û£¬×îºÃ°ÑCµÄÔËÐÐʱ¼äºÍÄÚ´æµÈ¶¼ÏÔʾ³öÀ´
¸÷λ´ó¸ç´ó½ã°ï°ï棬СµÜ¸Ð¼¤²»¾¡£¡
ÓÃjavaµÄ½ø³ÌÀàÊÔÊÔ
ÎÒ¸øÄãת ......
ÏÖÔÚ»¹ÓкܶàÈ˸㲻¶®PHPºÍJAVA¿ª·¢µÄÐͬOAµ½µ×ÓÐʲô²»Í¬£¬¶Ô×Ô¼ºµ½µ×ÓÐʲôӰÏ죬ÒÔÖÁÓÚ×ö³öÁË´íÎóµÄÑ¡Ôñ¶øêݺ¦ÎÞÇî¡£±ÊÕ߸ù¾ÝÁ½ÖÖ¼¼ÊõµÄÌصãÖØÐÂÕûÀíÁËÒ»¸ö¶Ô±È£¬¸ø¹ØÐÄÐͬOA¼¼ÊõµÄ¶ÁÕß×ö¸ö²Î¿¼¡£
»ªÌ춯Á¦Ð ......
ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......