java中操作mysql_java中操作mysql操作

java操作mysql必须下载一个jar包，冲过odbc来操作，

在java中的更新类操作依赖于依赖于Statement接口来完成

具体看代码怎么操作：

package excise;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class ConnectDemo {

public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";

public static final String DBURL = "jdbc:mysql://localhost:3306/test";

public static final String DBUSER = "root";

public static final String DBPASS = "";

public static void main(String args[]) throws SQLException, ClassNotFoundException {

Connection conn = null;

Class.forName(DBDRIVER);

conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);

System.out.println(conn);

int index=1;

String add="江西省九江市";

String birthString="1990-04-05";

String cardString="222222220";

String sex="女";

String sql="insert into person(index_table,address,birthday,card,sexxx)"

+"values("+index+",'"+add+"','"+birthString+"','"+cardString+"','"+sex+"')";

System.out.println(sql);

String sql_update="update person set card='360424198804052879' where card='222222220'";

Statement smt=conn.createStatement();

smt.executeUpdate(sql);

smt.executeUpdate(sql_update);

smt.close();

conn.close();

}

}

查询结果依赖于ResultSet接口来操作，具体看代码怎么操作：

package excise;

import java.sql.Statement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class ConnectDemo {

public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";

public static final String DBURL = "jdbc:mysql://localhost:3306/test";

public static final String DBUSER = "root";

public static final String DBPASS = "";

public static void main(String args[]) throws Exception{

Connection conn=null;

Statement stmt=null;

ResultSet rs=null;

String sqlString="select index_table,address,birthday,card,sexxx from person";

Class.forName(DBDRIVER);

conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);

stmt=conn.createStatement();

rs=stmt.executeQuery(sqlString);

while(rs.next()){

int id=rs.getInt("index_table");

String add=rs.getString("address");

String card=rs.getString("card");

System.out.println("索引号的是："+id);

System.out.println("地址是："+add);

System.out.println("身份证号码是："+card);

}

rs.close();

stmt.close();

conn.close();

}

}