锐客网

  1. 首页 > 生活百科 > it技术 > >

mysql省市区怎么 mysql地理位置( 二 )

IT技术数据库


e.printStackTrace();
}
}
if(ct!=null){
try {
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
DAO.java的代码如下
[java] view plain copy
package com.xiaojie.dao;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.xiaojie.beans.City;
import com.xiaojie.beans.County;
import com.xiaojie.beans.Province;
public class DAO {
public ListProvince getprovince(String sql ,Object...args) throws ClassNotFoundException, SQLException, IOException{
ListProvince provinces=new ArrayListProvince();
//准备去查数据库
Connection ct=null;
ct=Jdbctools.getConnection();
System.out.println("获取到数据库的连接了");
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;iargs.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
provinces.add(new Province(rs.getInt("province_id"),rs.getString("province_name")));
}
Jdbctools.shifanglianjie(ct, ps, rs);
return provinces;
}
public ListCity getcity(String sql ,Object...args) throws SQLException, ClassNotFoundException, IOException{
ListCity cities=new ArrayListCity();
//准备去查数据库
Jdbctools jt=new Jdbctools();
Connection ct=null;
ct=jt.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;iargs.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
cities.add(new City(rs.getInt("city_id"),rs.getString("city_name")));
}
jt.shifanglianjie(ct, ps, rs);
return cities;
}
public ListCounty getcounty(String sql,Object...args ) throws SQLException, ClassNotFoundException, IOException{
ListCounty counties=new ArrayListCounty();
//准备去查数据库
Jdbctools jt=new Jdbctools();
Connection ct=null;
ct=jt.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
ps=ct.prepareStatement(sql);
for(int i=0;iargs.length;i++){
ps.setObject(i+1, args[i]);
}
rs=ps.executeQuery();
while(rs.next()){
counties.add(new County(rs.getInt("county_id"),rs.getString("county_name")));
}
jt.shifanglianjie(ct, ps, rs);
return counties;
}
}
c3p0-config.xml的代码如下：
[html] view plain copy
?xml version="1.0" encoding="UTF-8"?
c3p0-config
named-config name="helloc3p0"
!--连接数据源的基本属性 --
property name="user"root/property
property name="password"/property
property name="driverClass"com.mysql.jdbc.Driver/property
property name="jdbcUrl"jdbc:mysql:///thereaction/property
!--若数据库中连接数不足时 ， 一次向数据库服务器申请多少个连接--
property name="acquireIncrement"5/property
!--初始化数据库连接池时连接的数量 --
property name="initialPoolSize"5/property
!--数据库连接池中的最小的数据库连接数 --
property name="minPoolSize"5/property
!--数据库连接池中的最大的数据库连接数 --
property name="maxPoolSize"10/property
!--c3p0数据库连接可以维护的statement的个数 --
property name="maxStatements"20/property
!--每个连接同时可以使用的statement对象的个数 --
property name="maxStatementsPerConnection"5/property
/named-config
/c3p0-config
创建servlet.java 文件
[java] view plain copy

推荐阅读


上一篇：wordpress在线阅读主题，wordpress文章主题

下一篇：行业市场如何营销，市场营销企业应该怎么做