package
com.jasonhuang.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import org.apache.log4j.Level;
import org.apache.log4j.Logger;
// import com.mysql.jdbc.Driver;
/**/ /*
* 测试基础MySQL JDBC代码
*/
public class TestMySql ... {
/** *//**
* Log4j日志
*/
private static Logger logger = Logger.getLogger(TestNIO.class);
/** *//**
* @param args
* @throws ClassNotFoundException
*/
public static void main(String[] args) ...{
// 设置日志记录级别为INFO
logger.setLevel(Level.INFO);
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try ...{
Properties props = new Properties();
// 设置数据库用户名和密码
props.put("user", "root");
props.put("password", "");
// 设置数据库连接使用中文字符集
props.put("useUnicode", "true");
props.put("characterEncoding", "GBK");
// 非标准写法
//Driver driver = new Driver();
//conn = driver.connect("jdbc:mysql://localhost:3306/mysql", props);
// 标准JDBC写法
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", props);
// 设置为只读(只允许select)
conn.setReadOnly(true);
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM user");
int n = 0;
while (rs.next()) ...{
logger.info("记录" + ++n + ", " + rs.getString("User"));
}
logger.info("记录总数:" + n);
} catch (Exception e) ...{
e.printStackTrace();
} finally ...{
// 依次关闭数据库资源
if (rs != null) ...{
try ...{
rs.close();
} catch (SQLException e) ...{
e.printStackTrace();
}
rs = null;
}
if (stmt != null) ...{
try ...{
stmt.close();
} catch (SQLException e) ...{
e.printStackTrace();
}
stmt = null;
}
if (conn != null) ...{
try ...{
conn.close();
} catch (SQLException e) ...{
e.printStackTrace();
}
conn = null;
}
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import org.apache.log4j.Level;
import org.apache.log4j.Logger;
// import com.mysql.jdbc.Driver;
/**/ /*
* 测试基础MySQL JDBC代码
*/
public class TestMySql ... {
/** *//**
* Log4j日志
*/
private static Logger logger = Logger.getLogger(TestNIO.class);
/** *//**
* @param args
* @throws ClassNotFoundException
*/
public static void main(String[] args) ...{
// 设置日志记录级别为INFO
logger.setLevel(Level.INFO);
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try ...{
Properties props = new Properties();
// 设置数据库用户名和密码
props.put("user", "root");
props.put("password", "");
// 设置数据库连接使用中文字符集
props.put("useUnicode", "true");
props.put("characterEncoding", "GBK");
// 非标准写法
//Driver driver = new Driver();
//conn = driver.connect("jdbc:mysql://localhost:3306/mysql", props);
// 标准JDBC写法
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", props);
// 设置为只读(只允许select)
conn.setReadOnly(true);
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM user");
int n = 0;
while (rs.next()) ...{
logger.info("记录" + ++n + ", " + rs.getString("User"));
}
logger.info("记录总数:" + n);
} catch (Exception e) ...{
e.printStackTrace();
} finally ...{
// 依次关闭数据库资源
if (rs != null) ...{
try ...{
rs.close();
} catch (SQLException e) ...{
e.printStackTrace();
}
rs = null;
}
if (stmt != null) ...{
try ...{
stmt.close();
} catch (SQLException e) ...{
e.printStackTrace();
}
stmt = null;
}
if (conn != null) ...{
try ...{
conn.close();
} catch (SQLException e) ...{
e.printStackTrace();
}
conn = null;
}
}
}
}