🚀 go-pugleaf

������jdbc-odbc������,����odbc�������ӿ��Գɹ�,��ݿ���Ϊhehe,����ֻ��һ����,
����Ϊuser,������ֶ�,���ͷֱ�Ϊ:smallint,varchar,varchar,�Ұ��������access��

�ݿ�,��ͬ��Ĵ��������ʾ����,������sql serverȴʲô���ݶ�������ʾ,���λ����
��æ,��ʤ�м�,���õ�Դ��������:
import java.awt.*;
import java.sql.*;

public class jTest {
   public static void main(String args[])
   {    
        String url="jdbc:odbc:hehe";
        Connection con=null;
        Statement  sm=null;
        ResultSet  rs=null;
        
         try
         {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         }
         catch(Exception e)
         {
                System.out.println("cannot create jdbcOdbcDriver");
                return;
         }
         
         
         
         try
         {
                
                con=DriverManager.getConnection(url,"sa","");
                
                sm=con.createStatement();
          //sm.executeUpdate("delete from guestbook where content=''");
          //sm.executeUpdate("insert  into user  values('1004','hehe','234') 
");
                
                rs=sm.executeQuery("select * from user");
                
                while(rs.next())
                  {
                    short  user_id=rs.getShort("id");
                        String  user_name=rs.getString("name");
                        String  user_pass=rs.getString("password");
                    System.out.println("the user id is: "+user_id );
                        System.out.println("the user room is "+ user_name);
                        System.out.println("the user day is "+ user_pass);
                        
                  }
                  
                  }
                 catch(Exception e)
                 {}
                 
                 finally
                  {
                        try
                        {
                                rs.close();
                                sm.close();
                                con.close();
                        }
                         catch(Exception e)
                         {}
                        }
                  }
         }
                    

--
�� ��Դ:������δ��վ bbs.pku.edu.cn��[FROM: 210.34.50.72]