Spring Data_学习记录_01

朴灿烈づ我的快乐病毒、 2022-02-26 19:28 205阅读 0赞

### 1.Using JDBC without Spring ###

*  org.zcs.springjdbc-JdbcDemo.java

package org.zcs.springjdbc;
    
    import org.zcs.springjdbc.dao.JdbcDaoImpl;
    import org.zcs.springjdbc.model.Circle;
    
    public class JdbcDemo { 
    	public static void main(String[] args) { 
    		Circle circle = new JdbcDaoImpl().getCircle(1);
    		System.out.println(circle.getName());
    	}
    }

*  org.zcs.springjdbc.dao-JdbcDaoImpl.java

package org.zcs.springjdbc.dao;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    
    import org.zcs.springjdbc.model.Circle;
    
    import com.mysql.jdbc.Statement;
     
    public class JdbcDaoImpl { 
    	public Circle getCircle(int circleId) { 
    	 
    		   String driver = "com.mysql.jdbc.Driver";
    	        /*这个链接包含主机，库名“newcapec“，其他乱七八糟的都是模版*/
    	        String url = "jdbc:mysql://172.21.3.210:3306/data1?useSSL=false";
    
    	        String user = "MHadoop"; //用户名root，一般都是这个
    	        String password = "12345678"; //自己数据库密码
    	        try { 
    	        Class.forName(driver); //这上面可以封装起来一个方法
    	        Connection con = (Connection) DriverManager.getConnection(url, user, password);//连接数据库
     
    	        String sql = "Select * from springdata where id = ?";//对表的操作语句
    	        PreparedStatement ps = con.prepareStatement(sql);
    	        ps.setInt(1, circleId);
    	        Circle circle = null;
    	        ResultSet rs = ps.executeQuery();
    	        if(rs.next()) { 
    	        	circle = new Circle(circleId, rs.getString("name"));
    	        }
    	       
    	        rs.close();
    	        
    	        ps.close();
    	        con.close();
    	        return circle;
    	        
    	        }catch (Exception e) { 
    	        	throw new RuntimeException(e);
    	        } 
    	}
    }

*  org.zcs.springjdbc.model-Circle.java

package org.zcs.springjdbc.model;
    
    public class Circle { 
    	public int id;
    	public String name;
    	public int getId() { 
    		return id;
    	}
    	public void setId(int id) { 
    		this.id = id;
    	}
    	public String getName() { 
    		return name;
    	}
    	public void setName(String name) { 
    		this.name = name;
    	}
    	public Circle(int circleId, String name) { 
    		setId(circleId);
    		setName(name);
    }
    }

### 2.学习记录 ###

*  主要学习了 如何使用javaee来链接mysql数据库