jdbc连接mysql数据库需要jia包吗

只需要mysql的驱动包：包名为：mysql-connector-java-5.1.37-bin.jar

源码如下：

import java.sql.Connection

import java.sql.DriverManager

import java.sql.PreparedStatement

import org.junit.Test

public class JdbcMysql {

@Test

public void connection() throws Exception{

String username = "root"

String password = "root"

String url = "jdbc:mysql://localhost:3306/exam?characterEncoding=utf-8"

String sql = "UPDATE s_cust SET cust_name=? WHERE cid = ? "

//加载mysql的驱动类，获得连接，获取SQL的预编译，设置参数，执行SQL语句

Class.forName("com.mysql.jdbc.Driver")

Connection con = DriverManager.getConnection(url, username, password)

PreparedStatement ps = con.prepareStatement(sql)

ps.setString(1, "北京")

ps.setInt(2, 6)

ps.execute()

ps.close()

con.close()

}

}

1、把数据库驱动包 copy 到 %CATALINA_HOME%\common\lib 下。 2、修改 %CATALINA_HOME%\conf\server.xml 文件，在 节点下添加： XML/HTML code?

背景介绍

国内xwiki安装使用资料较少,根据自己使用xwiki经验,总结出来,供参考,同时希望感兴趣的朋友能够一起讨论,XWiki是一个强大的Java开源的Wiki引擎。

它支持一些受欢迎的特性如：（内容管理(浏览/编辑/预览/保存)，支持附件，版本控制，全文本搜索，权限管理使用hibernate进行数据存储，RSS输出与显示外部的RSS feeds，多语言支持，提供XML/RPC的API,WYSIWYG HTML编辑器,导出为PDFGroovy脚本支持等等）

环境准备

MySQL（已经安装，不扯蛋了）

apache-tomcat-7.0.42-windows-x64.zip

xwiki-enterprise-web-6.2.2.war

xwiki-enterprise-ui-mainwiki-all-6.2.2.xar

xwiki下载地址 http://enterprise.xwiki.org/xwiki/bin/view/Main/Download

使用Tomcat服务器和mysql数据库

把xwiki-enterprise-web-6.2.2.war 放到 $TOMCAT_HOME/webapps 下 启动tomcat，待war包全部解压完成后关闭tomcat，并删除war包；

1：修改xwiki.cfg，开启superadmin；

[java] view plain copy print?

#-# Enable to allow superadmin. It is disabled by default as this could be a

#-# security breach if it were set and you forgot about it. Should only be enabled

#-# for recovering the Wiki when the rights are completely messed.

xwiki.superadminpassword=system

2：修改hibernate.hbm.xml，启动mysql数据库连接；

[java] view plain copy print?

<!-- Configuration for the default database.

Comment out this section and uncomment other sections below if you want to use another database.

Note that the database tables will be created automatically if they don't already exist.

<property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_dbshutdown=true</property>

<property name="connection.username">sa</property>

<property name="connection.password"></property>

<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>

<property name="dialect">org.hibernate.dialect.HSQLDialect</property>

<mapping resource="xwiki.hbm.xml"/>

<mapping resource="feeds.hbm.xml"/>

<mapping resource="activitystream.hbm.xml"/>

<mapping resource="instance.hbm.xml"/>

-->

<!-- MySQL configuration.

Uncomment if you want to use MySQL and comment out other database configurations.

-->

<property name="connection.url">jdbc:mysql://localhost/xwiki</property>

<property name="connection.username">xwiki</property>

<property name="connection.password">xwiki</property>

<property name="connection.driver_class">com.mysql.jdbc.Driver</property>

<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>

<property name="dbcp.ps.maxActive">20</property>

<mapping resource="xwiki.hbm.xml"/>

<mapping resource="feeds.hbm.xml"/>

<mapping resource="activitystream.hbm.xml"/>

<mapping resource="instance.hbm.xml"/>

需要在mysql中建立数据库xwiki，且授予相关的权限：

[java] view plain copy print?

create database xwiki default character set utf8

grant all privileges on xwiki.* to xwiki@localhost identified by "xwiki"

安装过程中出现的问题

1：中文乱码的解决（$TOMCAT_HOME/conf/server.xml该文件下Connector节中增加URIEncoding="UTF8"）

[java] view plain copy print?

<Connector port="8080" protocol="HTTP/1.1"

connectionTimeout="20000"

redirectPort="8443" URIEncoding="UTF-8" />

<!-- Define an AJP 1.3 Connector on port 8009 -->

<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" URIEncoding="UTF-8" />

2：java.lang.OutOfMemoryError（在$TOMCAT_HOME/bin/catalina.bat中增加） 183行前

[java] view plain copy print?

set JAVA_OPTS=-Xms256m -Xmx768m -XX:PermSize=256m -XX:MaxPermSize=768m -Djava.awt.headless=true

内存溢出之Tomcat内存配置 http://blog.csdn.net/crazy_kis/article/details/7535932

Linux下：

[java] view plain copy print?

JAVA_OPTS='-server -Xms256m -Xmx512m -XX:PermSize=128M -XX:MaxPermSize=256M -Djava.awt.headless=true'

3：java.sql.BatchUpdateException: Packet for query is too large (1808035 >1048576)

修改MySQL/MySQL Server 5.5/my.ini

[java] view plain copy print?

[mysqld]

max_allowed_packet = 10M

# The TCP/IP Port the MySQL Server will listen on

port=3306

把mysql的驱动包放到$TOMCAT_HOME/lib下

启动tomcat，并访问localhost:8080/xwiki；

按照安装向导一步步的完成安装

1：

2：

3：

4：

5：

6： 后台登陆 superadmin/system，设置中文

---