java.sql
JDBC访问数据库的流程
获取连接
// 本类只用于数据库连接及关闭操作
package com.lgy.db ;
import java.sql.* ;
public class MysqlConnection
{
// 属性
// 定义数据库操作的常量、对象
// 数据库驱动程序
private final String DBDRIVER = "com.mysql.jdbc.Driver" ;
// 数据库连接地址
private final String DBURL = "jdbc:mysql://localhost:3306/test" ;
// 数据库用户名
private final String DBUSER = "root" ;
// 数据库连接密码
private final String DBPASSWORD = "root" ;
// 声明一个数据库连接对象
private Connection conn = null ;
// 在构造方法之中连接数据库
public MysqlConnection()
{
try
{
// 加载驱动程序
Class.forName(DBDRIVER) ;
// 连接数据库
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
}
catch (Exception e)
{
System.out.println(e) ;
}
}
// 返回一个数据库连接
public Connection getConnection()
{
/// 返回连接对象
return this.conn ;
}
// 关闭数据库连接
public void close()
{
try
{
this.conn.close() ;
}
catch (Exception e)
{
}
}
statement query
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM CUSTOMERS"); //select
while(rs.next()) {
String event = rs.getString("event");
Object count = (Integer) rs.getObject("count");
}
int count = stmt.executeUpdate("DELETE FROM CUSTOMERS WHERE CUSTOMER_ID = 5");
boolean b = stmt.execute(sql);
preparedstatement query
更详细的用法:http://www.011580.cn
PreparedStatement pstmt = con.prepareStatement(
"INSERT INTO ORDERS (ORDER_ID, CUSTOMER_ID, TOTAL) VALUES (?,?,?)");
// Other code
pstmt.clearParameters(); // clear any previous parameter values
pstmt.setInt(1, 2); // set ORDER_ID
pstmt.setInt(2, 4); // set CUSTOMER_ID
pstmt.setDouble(3, 53.43); // set TOTAL
pstmt.executeUpdate(); // execute the stored SQL