Question

Java的连接数据库的那段代码是怎么写来着？

Answer 1

public static void main(String[] args)
  {
    try
    {
      String url="jdbc:mysql://localhost/mydb";
      String user="root";
      String pwd="123456";
                                      
      //加载驱动，这一句也可写为：Class.forName("com.mysql.jdbc.Driver");
     Class.forName("com.mysql.jdbc.Driver").newInstance();
      //建立到MySQL的连接
       Connection conn = DriverManager.getConnection(url,user, pwd);
                                      
      //执行SQL语句
       Statement stmt = conn.createStatement();//创建语句对象，用以执行sql语言
      ResultSet rs = stmt.executeQuery("select * from student");
                                     
       //处理结果集
      while (rs.next())
      {
        String name = rs.getString("name");
        System.out.println(name);
      }
      rs.close();//关闭数据库
      conn.close();
    }
    catch (Exception ex)
    {
      System.out.println("Error : " + ex.toString());
    }
  }

另外记得导入相应的jar包。。。。。。。

Answer 2

给我联系方法，给你传一个完整的连接，
我这有他的两个简单示例
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:gaodebao", "system", "orcl");

Answer 3

驱动程序名
String driver = "com.mysql.jdbc.Driver";
// URL指向要访问的数据库名scutcs
String url = "jdbc:mysql://127.0.0.1:3306/database_name";
// MySQL配置时的用户名
String user = "root";
// Java连接MySQL配置时的密码
String password = "root";
try {
// 加载驱动程序
Class.forName(driver);
// 连续数据库
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
// statement用来执行SQL语句
Statement statement = conn.createStatement();
// 要执行的SQL语句
String sql = "select * from student";