Java---连接MySQL数据库

本示例在Maven项目下实现，连接需导入相应的Jar包，poem代码如下：

// 对应的Jar包
		<dependency>
			<groupId>com.jfinal</groupId>
			<artifactId>jfinal</artifactId>
			<version>2.2</version>
		</dependency>
		<dependency>
			<groupId>c3p0</groupId>
			<artifactId>c3p0</artifactId>
			<version>0.9.1.2</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.34</version>
		</dependency>

代码如下：

public static void main(String[] args) throws IOException {
		
		// 
		String url = "localhost:3306";//数据库地址，本地数据库为localhost：3306
		String DBname = "数据库名";
		String user = "账户";
		String password = "密码";
		C3p0Plugin c3p0PluginCrawl1 = new C3p0Plugin(
				"jdbc:mysql://"+url+"/" + DBname
						+ "?rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&autoReconnect=true",
				user, 
				password);
		c3p0PluginCrawl.start();
		new ActiveRecordPlugin("connect", c3p0PluginCrawl1).start();
		DbPro dbPro = Db.use("connect");
		
		//SQL语句
		String sql = "select * from tablename where xxxx;";
		//进行查询，返回List对象，该List中每个Reord对应MySQL中的一行记录。
		List<Record> result = dbPro.find(sql);
		for(Record record : result){
			//循环遍历List，取出每个record
			System.out.println(record.getInt("id"));
			System.out.println(record.getStr("name"));
		}
		//其他操作可查看DbPro 代码模块
		*****
}

完！