java简单的jdbc连接mysql数据库代码

所需jar包：mysql-connector-java-5.1.47-bin

增删改的常用代码：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestConn {
	   private static final String DBURL="jdbc:mysql://localhost:3306/调用的数据库名";
	   private static final String DBUSER="root";
	   private static final String DBPWD="数据库密码";	
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		   Connection connection = null;
		   ResultSet rs=null;
		   Statement stmt = null;
		   try {
			   //a.导入驱动，加载具体的驱动类
			   Class.forName("com.mysql.jdbc.Driver");//驱动类
			   
			   //b.与数据库建立连接
			   connection = DriverManager.getConnection(DBURL,DBUSER,DBPWD);
			   
			   //c.发送sql，执行（增删改查） 
			   stmt = connection.createStatement();
			   
			   String sql = "insert into users values(15,'xijsb','xibgao')";
			   
			   //执行sql语句  executeUpdate作用于增删改，executeQuery()用于查询
			   int count = stmt.executeUpdate(sql);//返回值表示增删改几条数据
			   
			   //d.处理结果
			   if(count > 0) {
				   System.out.println("操作成功");
			   }
			   } catch (Exception e) {
					// TODO: handle exception
					e.printStackTrace();
				
			   }finally {
						try {						
							  if(stmt!=null) stmt.close();
							  if(connection!=null)connection.close();
							} catch (SQLException e) {
								// TODO Auto-generated catch block
								e.printStackTrace();
							}		
					    }

    }
}

查询的相关代码

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


public class TestConn2 {
	  private static final String DBURL="jdbc:mysql://localhost:3306/数据库名";
	   private static final String DBUSER="root";
	   private static final String DBPWD="密码";	
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		 Connection connection = null;
		   ResultSet rs=null;
		   Statement stmt = null;
		   try {
			   //a.导入驱动，加载具体的驱动类
			   Class.forName("com.mysql.jdbc.Driver");//驱动类
			   //b.与数据库建立连接
			   connection = DriverManager.getConnection(DBURL,DBUSER,DBPWD);
			   //c.发送sql，执行（增删改查） 
			   stmt = connection.createStatement();
			   String sql = "select id,username from users";
			   //执行sql语句  executeUpdate作用于增删改，executeQuery()用于查询
			   rs = stmt.executeQuery(sql);//返回值表示增删改几条数据
			   //d.处理结果
			   while(rs.next()) {
				   int id  = rs.getInt("id");//等价于int id  = rs.getInt(1);
				   String uname = rs.getString("username");//等价于String uname = rs.getString(2);
				   System.out.println(id+":"+uname);
			   } 
			   
			   
				} catch (Exception e) {
					// TODO: handle exception
					e.printStackTrace();
				
					}finally {
						try {
							//先开的后关，后开的先关
							  if(rs!=null) rs.close();
							  if(stmt!=null) stmt.close();
							  if(connection!=null)connection.close();
							} catch (SQLException e) {
								// TODO Auto-generated catch block
								e.printStackTrace();
							}
						
					}

}}