package com.milanoo.util;
import
java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUtils {
private static Connection conn = null;
PreparedStatement statement = null;
public static void getConn() {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://172.20.100.11:3306/milanoo?characterEncoding\=UTF-8";
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, "dev", "devpass");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* 查询数据
* @param
sql * @return sql执行后的结果集
*/
public static ResultSet selectSql(String sql) {
ResultSet rs = null;
try {
Statement statement = conn.createStatement();
rs = statement.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
public static void closeConn() {
try {
if (conn != null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}