1 package com.test; 2 import java.sql.connection; 3 import java.sql.drivermanager; 4 import java.sql.preparedstatement; 5 import java.sql.resultset; 6 import java.util.vector; 7 public class dbutil { 8 9 //定义连接数据库需要的10 connection ct=null;11 preparedstatement ps=null;12 resultset rs=null;13 private static string url = jdbc:mysql://+dbsometype.mysqlurl+:3306/weixin?characterencoding=utf-8&autoreconnect=true;14 private static string drivername = com.mysql.jdbc.driver;15 16 /**17 * 数据库查询，本操作查询完需手动关闭连接18 * @param sql19 * @param params20 * @return 查询结果resultset21 */22 public resultset getslect(string sql,object ...params){23 vector rowdate=new vector();24 vector columndate =new vector();25 try {26 ct = connectwithdb();27 ps=ct.preparestatement(sql);28 for(int i = 0;i