java连接mysql

java连接mysql

import java.sql.Connection;import java.sql.DriverManager;import java.util.*;public class Test1 {//org.gjt.mm.mysql.Driverpublic static void main(String[] args){Connection conn=null;try{Class.forName("org.gjt.mm.mysql.Driver");conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/temp","root","123456");System.out.println(conn);conn.close();}catch(Exception ex){ex.printStackTrace();}}}

 

myeclipse中添加 mysql的驱动jar包

在工程上右键，properties---->java build path中的Libraries选项卡中Add External JARs

 

 

 

 插入、修改、删除

import java.sql.Connection;import java.sql.DriverManager;//import com.mysql.jdbc.Statement;不能用此行，会出现connot convert statement to statementimport java.sql.Statement;public class Test1 {//org.gjt.mm.mysql.Driverpublic static void main(String[] args){Connection conn=null;Statement stmt=null;try{Class.forName("org.gjt.mm.mysql.Driver");conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/temp","root","123456");//String sql="insert mytable(name,password,age) values('hongda','123456789',16)";String sql="delete from mytable";stmt= conn.createStatement();for(int i=0;i<10000;i++)stmt.executeUpdate(sql);conn.close();}catch(Exception ex){ex.printStackTrace();}}}

 

 

 

查询

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class Test1 {public static void main(String[] args){Connection conn=null;Statement stmt=null;ResultSet rs=null;try{Class.forName("org.gjt.mm.mysql.Driver");conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/temp","root","123456");//String sql="insert mytable(name,password,age) values('hongda','123456789',16)";//String sql="delete from mytable";//String sql="update mytable set name='wang' where name='hongda'";String sql="select * from mytable";stmt= conn.createStatement(); rs=stmt.executeQuery(sql);while(rs.next()){int id =rs.getInt("id");String name=rs.getString("name");String password=rs.getString("password");System.out.println(" "+id+" "+name+" "+" "+password);}rs.close();stmt.close();conn.close();}catch(Exception ex){ex.printStackTrace();}}}