package cn.cnic.dep.test;
import java.sql.DriverManager;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
public class Test {
public static void main(String[] args) {
try {
Connection conn;
Statement stmt;
ResultSet res;
// 加载Connector/J驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
// 建立到MySQL的连接
conn = (Connection) DriverManager.getConnection(
"jdbc:mysql://localhost:3306/dep", "root", "root");
// 执行SQL语句
stmt = (Statement) conn.createStatement();
res = (ResultSet) stmt.executeQuery("select * from dayeye");
// 处理结果集
while (res.next()) {
String name = res.getString("context");
System.out.println(name);
}
res.close();
} catch (Exception ex) {
System.out.println("Error : " + ex.toString());
}
}
}
非常短的java操作mysql数据库的代码
最新推荐文章于 2024-08-07 11:24:41 发布