JAVA连接MySQL简单例子

来源：互联网发布：淘宝美工的岗位职责编辑：程序博客网时间：2024/05/22 16:51

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {

/**
* @param args
*/
// private static Connection con ;
// private Statement stmt;
// private static String username ;
// private static String password ;
// private static String url ;
//

public static void main(String[] args) {
  // TODO Auto-generated method stub

        String username ="root";
        String password ="admin";
        String url ="jdbc:MySQL://localhost/book";

        try {
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   Connection con = DriverManager.getConnection(url,username,password);
   Statement stmt = con.createStatement() ;
   ResultSet rs = stmt.executeQuery("select * from bookinfo");
   while(rs.next())
   {
    System.out.println(rs.getString("bookid"));
    System.out.println(rs.getString("bookname"));
    System.out.println(rs.getString("author"));
    System.out.println(rs.getString("publisher"));
    System.out.println(rs.getString("price"));
   }
   rs.close();
   stmt.close();
   con.close();


  } catch (InstantiationException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
   catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }

}

}