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

JAVA JDBC·ÃÎÊÊý¾Ý¿â±ê×¼´úÂë

 package edu.zzu.jdbc.Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import com.ambow.jdbc.entity.Student;
public class TestDBConn{
 
 public static void main(String args[]){
  
  String url="jdbc:sqlserver://localhost:1433;databaseName=zzu";
  String username="sa";
  String password="123456";
  Connection conn =null;
  Statement stmt =null;
  ResultSet rs =null;
  
     try {
      //1¡¢¼ÓÔØÇý¶¯
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   //2¡¢Í¨¹ýDriverManagee»ñÈ¡Á¬½Ó°üÀ¨(Êý¾Ý¿âÁ¬½Ó×Ö·û´®,Óû§Ãû,ÃÜÂë)
   conn = DriverManager.getConnection(url, username, password);
   //3¡¢Í¨¹ý Connection ¶ÔÏóÀ´´´½¨ createStatement
   stmt = conn.createStatement();
   //4¡¢×Ô¶¨Òå SQL Óï¾ä
//   String sql = " select * from student "; 
   String sql = "insert into student values (?,?,?) "; 
   //5¡¢Í¨¹ý statement ¶ÔÏóÀ´Ö´ÐÐ SQL Óï¾ä£¬²¢ÇÒ·µ»Ø½á¹û¸ø ResultSet
   rs =stmt.executeQuery(sql);
   while(rs.next()){
    System.out.print(rs.getInt("id")+" ");
    System.out.print(rs.getString("name")+" ");
    System.out.println(rs.getString("password"));
   }
  } catch (Exception e) {
   e.printStackTrace();
  } finally{
   try{
    if(conn!=null){
     conn.close();
     conn=null;
    }
    if(stmt!=null){
     stmt.close();
     stmt=null;
   &n


Ïà¹ØÎĵµ£º

tomcat×Ô¶¯¼ÓÔØÐ޸ĺóµÄjavaÀà

ʹÓõ÷ÊÔģʽ¼´¿É¡£
½øTOMCATµÄmanager¿ØÖÆÌ¨£¬¿ÉÒÔ¶ÔÖ¸¶¨µÄÐéÄâĿ¼½øÐпØÖÆ£¨¼ÓÔØ£¬ÖØÔØ£¬Ð¶ÔØ£©£¬±ÈÖØÆô¿ìµÄ¶à£¬ÔÚTOMCATµÄĬÈÏÊ×Ò³ÉÏÓÐÁ´½Ó¡£
============================================================================================
ÎÒÃÇÔÚ¿ª·¢µÄ¹ý³Ì¾­³£ÐèÒªµ÷ÊÔ£¬Ò²³£³£ÐèÒªÐÞ¸ÄʹÓõÄÀàºÍservlet£¬Èç¹û ......

Java BeanÔ­ÀíÓëÓ¦ÓÃ

   ¡¡¡¡1¡¢Ê²Ã´ÊÇJavaBean£¿  
   
  ¡¡¡¡JavaBeanÊÇÃèÊöJavaµÄÈí¼þ×é¼þÄ£ÐÍ£¬ÓеãÀàËÆÓÚMicrosoftµÄCOM×é¼þ¸ÅÄî¡£ÔÚJavaÄ£ÐÍÖУ¬Í¨¹ýJavaBean¿ÉÒÔÎÞÏÞÀ©³äJava³ÌÐòµÄ¹¦ÄÜ£¬Í¨¹ýJavaBeanµÄ×éºÏ¿ÉÒÔ¿ìËÙµÄÉú³ÉеÄÓ¦ÓóÌÐò¡£¶ÔÓÚ³ÌÐòÔ±À´Ëµ£¬×îºÃµÄÒ»µã¾ÍÊÇJavaBean¿ÉÒÔʵÏÖ´úÂëµÄÖØ¸´ÀûÓ ......

ÓÃJavaдµÄMy SQL²Ù×÷·â×°Àà

Kagula
2009-11-17
 
¹Ø¼ü´Ê
    Java My SQL
 
¸ÅÒª£º
    ¶ÔMy SQL²Ù×÷·â×°µÄJavaÔ´ÂëʾÀý¡£
 
ÒªÇó»·¾³£º
    J2SE1.5 + Eclipse3.4.2
 
ÕýÎÄ£º
Ïȵ½ÍøÉÏÏÂÔØmysql-connector-java-5.0.8-bin.jar£¬²¢°ÑËü·Åµ½ÄãµÄJava ProjectµÄUser Lib ......

javaÉè¼ÆÄ£Ê½

ÎÊÌâÓò:
 --ϵͳÖÐÄãÐèÒª»ñµÃij¸öÀàµÄΨһʵÀý£¬ËùÓпͻ§¶Ë¶ÔËüµÄ·ÃÎʶ¼½«Í¨¹ýÒ»¸ö¹«¹²µÄ·ÃÎʵã»ñµÃ
 --´´½¨Ò»¸öÀಢʹÆä£º(A)¶¨ÒåÒ»¸ö˽ÓеĹ¹ÔìÆ÷£¨B£©¶¨ÒåÒ»¸ö˽ÓС¢¾²Ì¬µÄ±äÁ¿Ö¸Ïò×Ô¼º£¨C£©¶¨ÒåÒ»¸ö¹«ÓС¢¾²Ì¬µÄ·ÃÎÊ·½·¨ÓÃÓÚ·µ»Ø¸ÃÀàµÄÒ»¸öΨһʵÀý
·ÖΪ ¶öººÊ½ ºÍ ÀÁººÊ½,ÏÂÃæÊÇÒ»¸ö¼òµ¥µÄʾÀý´úÂ룬Ӧ¸Ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ