mysql jdbc连接 优化_如何优化MYSQL中的JDBC性能

import java.sql.connection;

import java.sql.drivermanager;

import java.sql.resultset;

import java.sql.statement;

/**

* @author qingsongwang

* @2008.11.16

*

* 说明:实现与数据库相连,取出数据库的内容显示

*/

public class myjdbctest {

public static void main(string[] args) throws exception {

class.forname("com.mysql.jdbc.driver");

connection conn = drivermanager

.getconnection("jdbc:mysql://localhost:3306/testdb?user=root&password=greatwqs");

if (conn != null) {

system.out.println("数据库连接成功!");

}

statement stmt = conn.createstatement();

resultset rs = stmt.executequery("select * from person_table");

while (rs.next()) {

system.out.println("name = " + rs.getstring("name"));

}

rs.close();

stmt.close();

conn.close();

}

}