public class Driver { public static void main(String[] args){ try { Class.forName("com.mysql.jdbc.Driver"); System.out.println("测试通过"); java.sql.Connection conn; conn= DriverManager.getConnection("jdbc:mysql://localhost/zlx", "root", "123456"); System.out.println("conn-------------"+conn); Statement stmt=(Statement) conn.createStatement(); ResultSet rs=stmt.executeQuery("select * from tb_test"); while(rs.next()){ String sno=rs.getString("sno"); String sname=rs.getString("sname"); System.out.println("name------"+sno+"--------sname-"+sname); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
intellij idea连接mysql模版
最新推荐文章于 2023-01-29 10:42:30 发布