java从入门到精髓 - 数据库操作PrepareStatementTest

import  java.net.URLDecoder;
import  java.sql.Connection;
import  java.sql.DriverManager;
import  java.sql.PreparedStatement;
import  java.sql.ResultSet;
import  java.sql.SQLException;
import  java.sql.Statement;
public   class  PrepareStatementTest {

     /**
     * 取得相对路径的Connection
     *  @return
      */
     public   static  Connection getConnection(){
      Connection conn = null ;
       try {
           String path = "" ;
           Class theClass  =  PrepareStatementTest. class ;
            // System.out.println(ConnTest2.class.getResourceAsStream("db.mdb"));
           java.net.URL  u =  theClass.getResource( " db.mdb " );   
           String ChinesePath  =  URLDecoder.decode(u.getPath().substring( 1 ,u.getPath().length()).replaceAll( " %20 " ,  "   " ), " UTF-8 " );
            // System.out.println(ChinesePath);
           String url = " jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ= " + ChinesePath;
           Class.forName( " sun.jdbc.odbc.JdbcOdbcDriver " );
            // System.out.println("before connection");
           conn = DriverManager.getConnection(url);
         } catch (Exception ee){
           System.out.println( " connect db error: " + ee.getMessage());
         }
          return  conn;
    }
     /**
     *  @param  args
      */
     public   static   void  main(String[] args) {
         //  TODO Auto-generated method stub
        Connection conn  =  PrepareStatementTest.getConnection();    // 获得connection
         try
        {
             // Statement stmt = conn.createStatement();    // 获得statement
            PreparedStatement stmt  =  conn.prepareStatement( " select * from test where name =? " );   // 生成preparedStatement
            stmt.setString( 1 ,  " x " );          // 对第一个通配符赋值
            ResultSet rs  =  stmt.executeQuery();    // 执行查询
             while (rs.next())    // 取出相应的结果
            {
                String id  =  rs.getString( " 编号 " );
                String name  =  rs.getString( " name " );
                String age  =  rs.getString( " age " );
                String address  =  rs.getString( " address " );
                String memo  =  rs.getString( " memo " );
                System.out.print( " 编号:  " + id);
                System.out.print( "  name:  " + name);
                System.out.print( "  age:  " + age);
                System.out.print( "  address:  " + address);
                System.out.println( "  memo:  " + memo);
            }
        } catch (Exception e)
        {
            
        }
    }

}

 

转载于:https://www.cnblogs.com/maxblog/archive/2010/09/02/1816151.html