简单的JDBC应用,java连接 MYsql;

来源:互联网 发布:我的梦是什么样的优化 编辑:程序博客网 时间:2024/05/17 06:22
package JDBC;
package JDBC;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class ConnToMySql {public static void main(String[] args) throws Exception{Class.forName("com.mysql.jdbc.Driver");Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mysql", "root", "1");Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("select * from teacher");while ( rs.next()) {System.out.println(rs.getInt(1) + "\t" + rs.getString(2)+ "\t");}}}


0 0
原创粉丝点击