通过JDBC连接数据库
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class ConnMySQL
{
public static void main(String[] args)
throws ClassNotFoundException, SQLException
{
//通过反射加载驱动
String className = "com.mysql.jdbc.Driver";
Class.forName(className);
//获取Connection数据库连接对象
String url = "jdbc:mysql://127.0.0.1:3306/arvin";
Connection connection = DriverManager.getConnection(url, "root", "111111");
//获取Statement对象:执行SQL语句的工具接口
String sql = "select * from ljb_t_student";
java.sql.PreparedStatement pStatement = connection.prepareStatement(sql);
//获取结果集对象resultSet
ResultSet resultSet = pStatement.executeQuery();
while (resultSet.next())
{
System.out.println(resultSet.getInt(1) + "->" + resultSet.getString(2) + ":" + resultSet.getString(3));
}
}
}