testexecuteinsertmethod.java

JDBC封装之connectionFactory

package com.passedbylove.database.core.test;

import java.sql.SQLException;

import com.passedbylove.database.core.DBOperationAdapter;
import com.passedbylove.database.core.util.CharEncoding;

public class TestexecuteInsertMethod {
   /** @param argc */
   public static void main(String[] argc) {
   	DBOperationAdapter dbtools=DBOperationAdapter.getInstance();
   	try {
   		int effectedRows=dbtools.executeInsert("insert into userinfo(username,password,birthday,address) values('jdk-tomcat','sun MicroSystem co','1999-9-9','"+CharEncoding.codeToString("美国")+"')");
   		System.out.println("已向数据库提交"+effectedRows+"条记录");
   	} catch (SQLException e) {
   		e.printStackTrace();
   	}
   }

}