非常短的java操作mysql数据库的代码
来源：互联网 发布：英国高中帅哥知乎 编辑：程序博客网 时间：2024/06/11 16:23
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());}}}
