gnl

          java 學習
          隨筆 - 17, 文章 - 0, 評論 - 2, 引用 - 0
          數據加載中……

          2013年5月19日

          個人常用工具記錄


          一、Firefox
          1、屏蔽廣告插件 Adblock Plus
          2、取色工具 ColorZilla
          3、調試工具  Firebug
          4、另一款web調試工具  Web Developer
          5、網頁存儲為圖片 Pearl Crescent
          6、另一款網頁切圖工具 
          7、火狐主頁
          8、火狐附加組件
          9、Image-Show-Hide(待試用)


          10、解壓版Firefox下載
          11、Firefox幫助



          二、圖片在線編輯工具
          1、ps工具
          2、ps工具



          三、常用軟件下載地址
          1、常用軟件下載網站

          2、(1)gvim下載地址
              (2)gvim下載地址
              (3)gvim下載地址
              (4)gvim下載地址
             
          四、網站使用工具
          1、網站使用工具
          2、網絡知識
          五、Windows 幫助使用資料
          1、windows xp 幫助



          ??一個可以使用的幫助網站
          六、求職網站記錄
          1、拉勾網




          posted @ 2015-02-11 15:12 一江 閱讀(3542) | 評論 (0)編輯 收藏

          JDBC----------建立數據庫連接


          1、什么是JDBC
                  Java 數據庫連接,(Java Database Connectivity,簡稱JDBC)是Java語言中用來規范客戶端程序如何來訪問數據庫的應用程序接口,提供了諸如查詢和更新數據庫中數據的方法。JDBC也是Sun Microsystems的商標。它JDBC是面向關系型數據庫的(來源:維基百科   )。JDBC是我們通過外部程序操作數據庫的一個工具。
                                                                                                                                                                                                                                                         
          2、編寫JDBC的步驟
              (1)加載驅動
              (2)傳遞參數獲得連接
              (3)獲取數據庫連接  

              我在這里用了一個properties的配置文件來(database.properties)設置我的我的配置參數

                  #mysqluse
                  driver=com.mysql.jdbc.Driver
                  url=jdbc:mysql://127.0.0.1:3306/dotestuse
                  username=root
                  password=
          程序代碼         
          1.             import java.io.IOException;
          2.             import java.io.InputStream;
          3.             import java.sql.Connection;
          4.             import java.sql.DriverManager;
          5.             import java.sql.SQLException;
          6.             import java.util.Properties;
          7.             
          8.             public class GetConnectionT {
          9.             
          10.                 public static void main(String[] args) {
          11.             
          12.                     try {
          13.             
          14.                         //讀取配置文件參數
          15.                         InputStream in = GetConnectionT.class.getClassLoader().getResourceAsStream("propert.properties");
          16.                         Properties pr = new Properties();
          17.                         pr.load(in);
          18.                         Class.forName(pr.getProperty("driver"));
          19.                         //通過驅動管理器獲得數據庫連接        
          20.                         Connection con = DriverManager.getConnection(pr.getProperty("url"),    pr.getProperty("username"), pr.getProperty("password"));
          21.                         System.out.println(con);
          22.                         con.close();
          23.             
          24.                     } catch (ClassNotFoundException e) {
          25.             
          26.                         System.err.println("加載驅動失敗"+e.getLocalizedMessage());
          27.                     } catch (IOException e) {
          28.                         System.err.println("加載配置文件失敗"+e.getLocalizedMessage());
          29.                     } catch (SQLException e) {
          30.                         System.err.println("建立數據庫連接失敗"+e.getLocalizedMessage());
          31.                     }
          32.                 }
          33.             }

          這里只是一個簡單的獲得JDBC的例子,在實際工作中我們最好用單例模式來獲得數據庫連接

          posted @ 2013-07-05 11:48 一江 閱讀(274) | 評論 (0)編輯 收藏

          mybatis 學習記錄

          在mybatis 中無法插入記錄

          顯示信息如下:

          SLF4J: This version of SLF4J requires log4j version 1.2.12 or later. See also http://www.slf4j.org/codes.html#log4j_version
          0    DEBUG [main]  org.apache.ibatis.logging.LogFactory     - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
          31   DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource     - PooledDataSource forcefully closed/removed all connections.
          31   DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource     - PooledDataSource forcefully closed/removed all connections.
          31   DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource     - PooledDataSource forcefully closed/removed all connections.
          31   DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource     - PooledDataSource forcefully closed/removed all connections.
          140  DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction     - Opening JDBC Connection
          483  DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource     - Created connection 6259058.
          483  DEBUG [main] com.te.mybatis.persitence.ifance.PersonDao.insertperson     - ooo Using Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
          483  DEBUG [main] com.te.mybatis.persitence.ifance.PersonDao.insertperson     - ==>  Preparing: insert into person(username) values('tomcat23')
          530  DEBUG [main] com.te.mybatis.persitence.ifance.PersonDao.insertperson     - ==> Parameters:
          530  DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction     - Rolling back JDBC Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
          561  DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction     - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
          561  DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction     - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
          561  DEBUG [main] org.apache.ibatis.datasource.pooled.PooledDataSource     - Returned connection 6259058 to pool.

          運行插入語句始終不能成功,但是一直沒有注意這個語句
          530  DEBUG [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction     - Rolling back JDBC Connection [com.mysql.jdbc.JDBC4Connection@5f8172]
          想一想在insert里面也沒有用到事務啊,不知道是什么原因?

          在執行語句出添加事務提交 就可以插入成功 ,

                  SqlSession sqlsesstion = sc.openSession();

                  sqlsesstion.insert("insertperson", person);
                  sqlsesstion.commit();  //還不知道是什么原因要提交事務才可以插入數據成功,但是每一次似乎都對數據庫產生了影響
                  sqlsesstion.close();



          有一點亂 !!!





          posted @ 2013-07-04 12:10 一江 閱讀(3106) | 評論 (1)編輯 收藏

          火狐瀏覽器使用記錄

          1、配置多個用戶
              在火狐關閉的的情況下 在命令行窗口 輸入firefox -p  調出 配置文件管理項 詳細操作參考 管理用戶配置文件

          2、設置可以啟動多個賬戶
               打開自己的firefox 啟動快捷鍵=》目標。在目標里面加上配置文件即可 如  D:\officeprograme\internettool\Firefox\firefox.exe --no-remote -p usephp      --no-remote -p usephp 指定用戶配置 參考  火狐常見啟動參數介紹



               



          posted @ 2013-05-20 22:53 一江 閱讀(217) | 評論 (0)編輯 收藏

          ibatis 中使用select 查詢 數據庫中存在查詢項是null 是報錯

          在使用ibatis 進行查詢數據庫是報錯
          錯誤如下:

          查詢失敗  
          --- The error occurred in com/sqlmap/person.xml.  
          --- The error occurred while applying a result map.  
          --- Check the lisper-AutoResultMap.  
          --- The error happened while setting a property on the result object.  
          --- Cause: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of '230kims                00'.  Cause: java.lang.IllegalArgumentException
          Caused by: java.lang.IllegalArgumentException
          com.ibatis.common.jdbc.exception.NestedSQLException:   
          --- The error occurred in com/sqlmap/person.xml.  
          --- The error occurred while applying a result map.  
          --- Check the lisper-AutoResultMap.  
          --- The error happened while setting a property on the result object.  
          --- Cause: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of '230kims                00'.  Cause: java.lang.IllegalArgumentException
          Caused by: java.lang.IllegalArgumentException
          Caused by: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of '230kims                00'.  Cause: java.lang.IllegalArgumentException
          Caused by: java.lang.IllegalArgumentException
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
              at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
              at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
              at com.bean.persondaoim.PersonDaoIm.lsper(PersonDaoIm.java:43)
              at com.bean.persondaoim.PersonDaoIm.main(PersonDaoIm.java:67)
          Caused by: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of '230kims                00'.  Cause: java.lang.IllegalArgumentException
          Caused by: java.lang.IllegalArgumentException
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:51)
              at com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:112)
              at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:333)
              at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:63)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:391)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:184)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
              ... 7 more
          Caused by: java.lang.IllegalArgumentException
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:45)
              ... 14 more

          Caused by:
          com.ibatis.common.exception.NestedRuntimeException: Error setting properties of '230kims                00'.  Cause: java.lang.IllegalArgumentException
          Caused by: java.lang.IllegalArgumentException
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:51)
              at com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:112)
              at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:333)
              at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:63)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:391)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:184)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
              at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
              at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
              at com.bean.persondaoim.PersonDaoIm.lsper(PersonDaoIm.java:43)
              at com.bean.persondaoim.PersonDaoIm.main(PersonDaoIm.java:67)
          Caused by: java.lang.IllegalArgumentException
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:45)
              ... 14 more

          Caused by:
          java.lang.IllegalArgumentException
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:45)
              at com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:112)
              at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:333)
              at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:63)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:391)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:184)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
              at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
              at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
              at com.bean.persondaoim.PersonDaoIm.lsper(PersonDaoIm.java:43)
              at com.bean.persondaoim.PersonDaoIm.main(PersonDaoIm.java:67)

          Caused by:
          com.ibatis.common.exception.NestedRuntimeException: Error setting properties of '230kims                00'.  Cause: java.lang.IllegalArgumentException
          Caused by: java.lang.IllegalArgumentException
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:51)
              at com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:112)
              at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:333)
              at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:63)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:391)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:184)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
              at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
              at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
              at com.bean.persondaoim.PersonDaoIm.lsper(PersonDaoIm.java:43)
              at com.bean.persondaoim.PersonDaoIm.main(PersonDaoIm.java:67)
          Caused by: java.lang.IllegalArgumentException
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:45)
              ... 14 more

          Caused by:
          java.lang.IllegalArgumentException
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:45)
              at com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:112)
              at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:333)
              at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:63)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:391)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:184)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
              at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
              at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
              at com.bean.persondaoim.PersonDaoIm.lsper(PersonDaoIm.java:43)
              at com.bean.persondaoim.PersonDaoIm.main(PersonDaoIm.java:67)

          Caused by:
          java.lang.IllegalArgumentException
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:45)
              at com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:112)
              at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:333)
              at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:63)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:391)
              at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:184)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
              at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
              at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
              at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
              at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
              at com.bean.persondaoim.PersonDaoIm.lsper(PersonDaoIm.java:43)
              at com.bean.persondaoim.PersonDaoIm.main(PersonDaoIm.java:67)
          Exception in thread "main" java.lang.NullPointerException
              at com.bean.persondaoim.PersonDaoIm.main(PersonDaoIm.java:70)


          posted @ 2013-05-19 21:31 一江 閱讀(632) | 評論 (1)編輯 收藏

          主站蜘蛛池模板: 永年县| 沾益县| 静宁县| 弥勒县| 七台河市| 台北县| 惠安县| 自治县| 泰兴市| 保德县| 凤城市| 南宁市| 益阳市| 邵阳市| 含山县| 吴桥县| 香港 | 无棣县| 宁都县| 咸丰县| 青神县| 志丹县| 玛沁县| 西充县| 巩义市| 栾城县| 镇远县| 仪征市| 工布江达县| 密云县| 恩平市| 襄垣县| 临高县| 邯郸市| 济阳县| 保康县| 延川县| 石泉县| 神木县| 永靖县| 长治市|