java链接mysql原始方法_Java连接mysql原始方法

private static String mysqlUrl = "jdbc:mysql://192.168.1.1:3306/test?useUnicode=true&characterEncoding=utf-8";

public static void main(String[] args) {

Connection conn = null;

PreparedStatement preStatement = null;

ResultSet rs = null;

try {

Class.forName("com.mysql.jdbc.Driver");

System.out.println("成功加载MySql驱动！");

conn = DriverManager.getConnection(mysqlUrl, "user", "password");

String sql = "";

preStatement = conn.prepareStatement(sql);

rs = preStatement.executeQuery();

while (rs.next()) {

//TODO

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}finally{

try {

if(rs!=null)rs.close();

if(preStatement!=null)preStatement.close();

if(conn!=null)conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

分享到：

2016-11-14 16:45

浏览 142

评论