连接mysql数据库

来源:互联网 发布:微软keeper是什么软件 编辑:程序博客网 时间:2024/06/05 06:09
public static void main(String[] args) {try{Class.forName("com.mysql.jdbc.Driver");}catch(Exception e){e.printStackTrace();}try{Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");PreparedStatement stmt=conn.prepareStatement("select * from student");ResultSet rs1=stmt.executeQuery();while(rs1.next()){System.out.print(rs1.getString(1));System.out.print(rs1.getString(2));System.out.print(rs1.getString(3));System.out.print(rs1.getString(4));System.out.println(rs1.getString(5));}}catch(SQLException e){e.printStackTrace();}}

0 0
原创粉丝点击