JAVA连接Mysql数据库

直接撸代码

需要jar包 然后对其引入

package test;
import java.sql.*;

import org.omg.CORBA.Object;
public class test {
	
		static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
		static final String DB_URL = "jdbc:mysql://192.168.0.11:30030/student?useUnicode=true&characterEncoding=UTF-8&useSSL=false";
		
		
		
		static final String USER ="root";
		static final String PASS = "123";
		
		public static void main(String[] args) {
			Connection conn = null;
			Statement stmt = null;
			try {
				
				Class.forName(JDBC_DRIVER);//注册驱动
			
				
				
				//开始连接
				System.out.println("连接数据库");
				conn = DriverManager.getConnection(DB_URL,USER,PASS);
				
				
				//查询
	            System.out.println(" 实例化Statement对象...");
	            stmt = conn.createStatement();
	            String sql;
	            
	            sql = "select * from eb_student";
	            ResultSet rs = stmt.executeQuery(sql);
	            
	            student student= new student("");
				//数据结果
	            while(rs.next()){
	            	
	            	
	            	String name = rs.getString("name");
//	            	System.out.println("姓名:" + name);
		            student.name = name;
	            }
	            System.out.println(student);
	            
	            rs.close();
	            stmt.close();
	            conn.close();
	            
			} catch (SQLException se) {
	            se.printStackTrace();
			}catch(Exception e){
	            e.printStackTrace();
	        }finally{
	            try{
	                if(stmt!=null)
	                	stmt.close();
	            }catch(SQLException se2){
	            	
	            }
	            try{
	                if(conn!=null)
	                	conn.close();
	            }catch(SQLException se){
	                se.printStackTrace();
	            }
	        }
		}
}