大学时候就学的最原始的JDBC,刚毕业那会,笔试还要求手写JDBC。什么都不说了,看代码吧。
首先,要去官网下载一个mysql的驱动包,如:mysql-connector-java-5.1.27.jar
然后,Run As Java Application
package com.rice.web;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JdbcUtil {
public static void main(String[] args) {
test();
}
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getMysqlConn() {
try {
return DriverManager.getConnection("jdbc:mysql://rm-wz9n1e39tno3o4x14do.mysql.rds.aliyuncs.com:3306/rice_dev", "rice", "abc123");
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
@SuppressWarnings("resource")
public static void test() {
Connection conn = null;
Prepared