Spring Data_学习记录_01

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数据库