Java jdbc 连接数据库

来源：互联网发布：php提交按钮代码编辑：程序博客网时间：2024/05/14 08:37

连接数据库需要jdbc驱动，在 Eclipse 中 add external jar 即可

package db.test;import java.sql.*;public class JdbcTest {    public static void main(String[] args) {    // TODO Auto-generated method stub        String driver = "com.mysql.jdbc.Driver";    String url = "jdbc:mysql://127.0.0.1:3306/test";        String user = "dbtest";    String passwd = "123456";        try {      Class.forName(driver);      Connection conn = DriverManager.getConnection(url, user, passwd);      if (!conn.isClosed())        System.out.println("Success");      Statement statement = conn.createStatement();      String sql = "select * from dbstu";            ResultSet rs = statement.executeQuery(sql);      System.out.println("ID" + "\t" +"Name");      String name = null;            while (rs.next()) {        name = rs.getString("name");        System.out.println(rs.getString("id") + "\t" + name);      }      rs.close();      statement.close();      conn.close();    }    catch (ClassNotFoundException e) {      System.out.println("Can not find the driver !");      e.printStackTrace();    } catch (SQLException e) {      e.printStackTrace();    } catch (Exception e) {      e.printStackTrace();    }  }}