java技術博客
          

          jsp博客
          

          

          


          
    
           數據加載中……
          
    
          
        
					
	
          
		
          
			JDBC連接SQLSERVER
		
          
		
          <%@page language="java" import="java.util.*,java.sql.*,Oper.*,voo.*" pageEncoding="GBK"%>
          
          <table border=1>
          
          <tr>
          
              <th>編號</th>
          
              <th>名稱</th>
          
              <th>類別</th>
          
              </tr>
          
          <%
          
DbOper op          =new DbOper();
          
ArrayList al          =op.select();
          
          for(int i=0;i<al.size();i++)
          
          {
          
    Book book          =(Book)al.get(i);
          
              %>
          
          <tr><td><%=book.getTitleid()%></td>
          
          <td><%=book.getTitle()%></td>
          
          <td><%=book.getType()%></td>
          
          <td><%=book.getPrice()%></td>
          
          </tr>
          
          <%
          
}          %>
          
          </table>
          

          

          

          

          

          

          

          package db;
          
          import java.sql.*;
          
          public class DbConn{
          
          public static Connection getConn(){
          
              return getConnByJar();
          
    
          
    }
          

          

          

          
          public static Connection getConnByJar(){Connection conn=null;
          
          try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
          
    conn          =DriverManger.getConnection("jdbc:sqlserver://localhost:1433;databasename=pubs","sa","");
          
    }
          
          catch(Exception e)
          
          {
          
    e.printStackTrace();
          
    }          return conn;
          
}
          
          //XP4不支持導入jar文件，只能用橋接JDBC－ODBC
          

          

          

          

          

          

          
          public static Connection getConnByODBC(){
          
    Connection conn          =null;
          
              try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          
        conn          =DriverManager.getConnection("jdbc:odbc:abc");
          
        }
          
              catch(Exception e)
          
              {
          
        
          
        e.printStackTrace();
          
        }
          
                  return conn;}
          
}
          

          

          

          

          

          package db;
          
          import java.sql.*;
          
          public class DbConn{
          
          public static Connection getConn(){
          
              return getConnByJar();
          
    
          
    }
          

          

          

          
          public static Connection getConnByJar(){Connection conn=null;
          
          try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
          
    conn          =DriverManger.getConnection("jdbc:sqlserver://localhost:1433;databasename=pubs","sa","");
          
    }
          
          catch(Exception e)
          
          {
          
    e.printStackTrace();
          
    }          return conn;
          
}
          
          //XP4不支持導入jar文件，只能用橋接JDBC－ODBC
          

          

          

          

          

          

          
          public static Connection getConnByODBC(){
          
    Connection conn          =null;
          
              try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          
        conn          =DriverManager.getConnection("jdbc:odbc:abc");
          
        }
          
              catch(Exception e)
          
              {
          
        
          
        e.printStackTrace();
          
        }
          
                  return conn;}
          
}
          

          

          

          package oper;
          
          import java.sql.Connection;
          
          import java.sql.SQLException;
          
          import java.util.ArrayList;
          
          import voo.Book;
          

          
          public class DbOper{
          
              public ArrayList select(){//動態數組和連接無關,不用resultset
          
                  Connction conn=null;
          
        java.sql.PreparedStatement pstmt          =null;
          
        java.sql.ResultSet rs          =null;
          
        ArrayList al          =new ArrayList();
          
                  try{
          
            conn          =db.DbConn.getConn();
          
            pstmt          =conn.prepareStatement("select title_id,title,type,price from titles");
          
            rs          =pstmt.executeQuery();
          
                      while(rs.next())
          
                      {
          
                Book b          =new Book();
          
                b.setTitleid(rs.getString(          1));
          
                b.setType(rs.getString(          2));
          
                b.setPrice(rs.getString(          3));
          
                b.setPrice(rs.getFloat(          4))
          
                al.add(b);
          
                }          }
          
                          catch(SQLException e)
          
                          {
          
                    e.printStackTrace();
          
                    }
          
                              finally{
          
                                  if(rs!=null)
          
                                  try{
          
                            rs.close();
          
                            }
          
                                      catch(SQLException e)
          
                                      {
          
                                e.printStackTrace();
          
                                }
          
                                          if(pstmt!=null)
          
                                          try{
          
                                    pstmt.close();
          
                                    }
          
                                              catch(SQLException e)
          
                                              {
          
                                        e.printStackTrace();
          
                                        }
          
                                                  if(conn!=null)
          
                                                  try{
          
                                    conn.close();}
          
                                              catch(SQLException e)
          
                                              {
          
                                        e.printStackTrace();
          
                                        }
          
                                    }
          
                                              return al;
          
        
          
        }
          
        
          
}
          

          

          

          package voo;
          
          public class Book{
          
              private String titleid;
          
              private String title;
          
              private String type;
          
              private float price;
          
    //set和get方法就不再哆嗦了
          
    ........}
          

          

          

          


          
		
          
			posted on 2008-10-26 09:46 郭興華 閱讀(1824) 評論(0)  編輯  收藏  
		
          
	
          
	
	


	


          
	    
    




          





          


          

	
          
		
          
				
		
	
		
          
		
		
          只有注冊用戶登錄后才能發表評論。
          
		
          
			
		
          
			
		
          
		
		
          
		


          

		          		
		
          
		
          			
		
		
		
		
          
		
          
		
		
          
		
          
			網站導航:
		
		
          
		
          
			
		
          	
		
          
			 
		
          
		
          
			
		
          
		
          
			
				
		
          		
	
          	

          



          

				
    
          
    

          

	

    







          
        
	




主站蜘蛛池模板：
平陆县|
开阳县|
嘉义县|
宣威市|
栾川县|
察雅县|
富蕴县|
信阳市|
洛阳市|
湖北省|
新邵县|
遂溪县|
巫山县|
綦江县|
韶关市|
郎溪县|
大田县|
准格尔旗|
高邮市|
特克斯县|
德钦县|
明光市|
阿勒泰市|
鄂托克旗|
余庆县|
勃利县|
和平县|
库尔勒市|
三台县|
峨边|
余干县|
剑阁县|
黎城县|
上栗县|
应城市|
喜德县|
九龙城区|
卢龙县|
原平市|
积石山|
镇巴县|