Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

Java¶àÏ̳߳ÌÐòÉè¼ÆÏêϸ½âÎö

 ¡¡Ò»¡¢Àí½â¶àÏß³Ì
¡¡¡¡¶àÏß³ÌÊÇÕâÑùÒ»ÖÖ»úÖÆ£¬ËüÔÊÐíÔÚ³ÌÐòÖв¢·¢Ö´Ðжà¸öÖ¸ÁîÁ÷£¬Ã¿¸öÖ¸ÁîÁ÷¶¼³ÆÎªÒ»¸öỊ̈߳¬±Ë´Ë¼ä»¥Ïà¶ÀÁ¢¡£
¡¡¡¡Ïß³ÌÓÖ³ÆÎªÇáÁ¿¼¶½ø³Ì£¬ËüºÍ½ø³ÌÒ»ÑùÓµÓжÀÁ¢µÄÖ´ÐпØÖÆ£¬ÓɲÙ×÷ϵͳ¸ºÔðµ÷¶È£¬Çø±ðÔÚÓÚÏß³ÌûÓжÀÁ¢µÄ´æ´¢¿Õ¼ä£¬¶øÊǺÍËùÊô½ø³ÌÖÐµÄÆäËüÏ̹߳²ÏíÒ»¸ö´æ´¢¿Õ¼ä£¬ÕâʹµÃÏ̼߳äµÄͨÐÅ ......

java filterÓ÷¨´óÈ«

¹Ø¼ü×Ö: filter
    ¹ýÂËÆ÷FilterÒ²¾ßÓÐÉúÃüÖÜÆÚ£ºinit()->doFilter()->destroy()£¬Óɲ¿ÊðÎļþÖеÄfilterÔªËØÇý¶¯¡£ÔÚservlet2.4ÖУ¬¹ýÂËÆ÷ͬÑù¿ÉÒÔÓÃÓÚÇëÇó·ÖÅÉÆ÷£¬µ«ÐëÔÚweb.xmlÖÐÉùÃ÷£¬<dispatcher>INCLUDE»òFORWARD»òREQUEST»òERROR</dispatcher>¸ÃÔªËØÎ»ÓÚfilter-mappingÖС£
Ò»¡ ......

JavaλËãÊõÔËËã·û

 
1£©&£ºÓëÔËË㣬½«Á½¸öÊý·Ö±ðת»¯³É²¹Â룬Ȼºó½øÐÐÔËË㣨ȫ1µÃ1£¬ÓÐ0³ö0£©¡£
2£©£¡£º·ÇÔËË㣬½«Êý×Ö×ÔÉíÈ¡·´£¨×ª»¯³É²¹Â룬°´Î»È¡·´——1±ä0£¬0±ä1£©¡£
3£©<<£º×óÒÆÔËËã·û£¬½«Ä³¸öÊ®½øÖÆ×ª»»³É¶þ½øÖÆÖ®ºóĩβµÄn¸ö¶þ½øÖÆÊýÒÔ´ËÍù×óÒÆ¶¯£¬Òç³öµÄnλÓÃ0ÔÚĩβ²¹×ã¡£
4£©>>£º´ø·ûºÅÓÒÒÆÔË ......

java»ñÈ¡SQL²éѯ½á¹û¼¯ÖеÄÐÐÊýºÍÁÐÊý

http://cheneyph.javaeye.com/blog/477829
         ÔÚJavaÖУ¬»ñµÃResultSetµÄ×ÜÐÐÊýµÄ·½·¨ÓÐÒÔϼ¸ÖÖ¡£
µÚÒ»ÖÖ£ºÀûÓÃResultSetµÄgetRow·½·¨À´»ñµÃResultSetµÄ×ÜÐÐÊý
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABL ......

ext2.0+java ÎļþÉÏ´«


ÎļþÉÏ´«ÆäʵÊÇÒ»¸öºÜ»ù±¾µÄÒ³Ãæ²Ù×÷£¬ÒÔǰҲ×ö¹ý¡£ÔÚjsp+servletʱ£¬¹Ø¼üµãÊÇÖ»ÒªÖ¸¶¨jspÓÃÓÚÌá½»ÉÏ´«Îļþ×ÊÔ´µÄformµÄenctypeÊôÐÔΪmultipart/form- data¼´¿É¡£Õâ¸öÊôÐÔ ÆäʵÊÇÉèÖÃÁËÌá½»µÄÄÚÈÝÊÇÒÔÊý¾ÝÁ÷µÄ·½Ê½Ìá½»¸øservletµÄ¡£µ±È»Ò²°üº¬ÁËÎļþµÄÁ÷£¬ÕâÑùÔÚservletÀïÀûÓÃcommon- fileupload.jarÀïµÄ½Ó¿Ú·½·¨£¬½âÎöÕâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ