Java连mysql数据库

package

database;

import

java.sql.Connection;

import

java.sql.DriverManager;

public

classConDA {

/**

*

@param

args

*/

public static void main(String[] args) {

// TODO Auto-generated method stub

String driver =

"com.mysql.jdbc.Driver";

String url =

"jdbc:mysql://localhost:3306/extractor";

String username =

"root";

String pwd =

"root";

try {

Class.forName(driver);

Connection conn = DriverManager.getConnection(url,username,pwd);

System.

out.println(conn);

// return conn;

}

catch (Exception e) {

e.printStackTrace();

// return null;

}

}

}

 

 

**********************************

***********************************

package

database;

import

java.sql.Connection;

import

java.sql.DriverManager;

import

java.sql.ResultSet;

import

java.sql.SQLException;

import

java.sql.Statement;

public

class

ConnectDA {

/**

*

@param

args

*/

public static void

main(String[] args) {

String JDriver =

"com.mysql.jdbc.Driver"

;

String conURL =

"jdbc:mysql://localhost:3306/extractor"

;

try

{

Class.forName(JDriver);

}

catch

(ClassNotFoundException cnf_e) {

System.

out.println("Driver Not Found: "

+ cnf_e);

}

try

{

Connection con = DriverManager

.getConnection(conURL,

"root", "root"

);

Statement s = con.createStatement();

ResultSet rs = s.executeQuery(

"select * from extractor_txt;"

);

while

(rs.next()) {

System.

out

.println(rs.getInt(

"id") + "\t" + rs.getString("txt"

));

}

s.close();

con.close();

}

catch

(SQLException sql_e) {

System.

out

.println(sql_e);

}

}

}

*******************************************************

**************************************************************

package database;

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

public class DACon {

 /**
  * @param args
  * @throws ClassNotFoundException
  * @throws IllegalAccessException
  * @throws InstantiationException
  * @throws SQLException
  */
 public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
  // TODO Auto-generated method stub
     Class.forName("org.gjt.mm.mysql.Driver").newInstance();
     String url ="jdbc:mysql://localhost/extractor?user=root&password=root&useUnicode=true&characterEncoding=8859_1";
     Connection conn= DriverManager.getConnection(url);
     //Connection conn= DriverManager.getConnection("jdbc:mysql://localhost/myDB","root","password");

 }

}