package cn.com.sohocat.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.Random;
public class DButil {
private String driver;
private String url;
private String username;
private String password;
private Connection connection;
private Statement statement;
private ResultSet rs;
private void init() {
this.driver="com.mysql.jdbc.Driver";
this.url = "jdbc:mysql://10.0.0.58:3306/HereOnLine";
this.username = "root";
this.password = "soho2010here";
}
private Connection getConnect() {
try {
Class.forName(this.driver);
try {
this.connection = DriverManager.getConnection(this.url, this.username, this.password);
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return this.connection;
}
public DButil(){
this.init();
this.getConnect();
}
public int updateSQl(String SQL) {
try {
this.statement = this.connection.createStatement();
return this.statement.executeUpdate(SQL);
} catch (SQLException e) {
e.printStackTrace();
}
return -1;
}
public ResultSet querySQL(String SQL) {
try {
this.statement = this.connection.createStatement();
this.rs = this.statement.executeQuery(SQL);
} catch (SQLException e) {
e.printStackTrace();
}
return this.rs;
}
public void close() {
try {
if(this.rs!=null){
this.rs.close();
}
if(this.statement!=null){
this.statement.close();
}
if(this.connection!=null){
this.connection.close();
}
}catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
DButil butil = new DButil();
ResultSet rs = butil.querySQL("select * from HO_User");
try {
while(rs.next()) {
System.out.println("-------------->" + rs.getString("UserName"));
}
// System.out.println("***************************************");
// Date date = new Date();
// Random random = new Random();
// System.out.println("random.nextInt()"+random.nextInt());
// System.out.println("random.nextLong()"+random.nextLong());
} catch (SQLException e) {
e.printStackTrace();
}
finally{
butil.close();
}
}
}