java中条件范围怎么写_java中的条件查询怎么写

匿名用户

1级

2016-04-29 回答

import java.sql.Connection;

import java.sql.Date;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.sql.PreparedStatement;

public class JDBC {

private Connection con = null;

private Statement stmt = null;

private ResultSet rs = null;

private String driver = "com.mysql.jdbc.Driver";

private String url="jdbc:mysql://localhost:3306/dataname

?characterEncoding=GBK";

private String user = "root";

private String password = "mysql";

/**

* 准备连接

*/

public void startConnection() throws ClassNotFoundException, SQLException {

Class.forName(driver); //注册数据库驱动

con = DriverManager.getConnection(url, user, password); //获得数据库连接

}

/**

* 执行select 并返回结果集 throws SQLException

*/

public ResultSet query(String sql) throws SQLException {

stmt = con.createStatement(); //创建Statement

rs = stmt.executeQuery(sql); //执行查询

return rs;

}

/**

* 执行insert update delete

*/

public int update(String sql) throws SQLException {

stmt = con.createStatement();

int r = stmt.executeUpdate(sql);

return r;

}

/**

* 释放资源(连接)

*/

public void releaseConnection() {

try {

if (rs != null)

rs.close();

stmt.close();

if (con != null)

con.close();

} catch (SQLException e) {

e.printStackTrace(); }

} }