Java连接Mysql实例

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

public class JDBCTest {

 public static void main(String[] args) {
  String driver = "com.mysql.jdbc.Driver";
  String url = "jdbc:mysql://127.0.0.1:3306/logicaldoc?useUnicode=true&characterEncoding=utf-8";
  String user = "root";
  String password = "mypassword";
  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();
//   ResultSet rs = statement.executeQuery(sql);
   
   
   // 要执行的SQL语句
   String sql = "select * from ld_document where ld_id = ?";
   PreparedStatement prepareStatement = conn.prepareStatement(sql);
   prepareStatement.setLong(1, 2);
   ResultSet rs = prepareStatement.executeQuery();
   
   String name = null;
   while (rs.next()) {
    name = rs.getString("ld_filename");
    System.out.println(name);
   }

   rs.close();
   conn.close();

  } catch (Exception e) {
   e.printStackTrace();
  }
 }
}