栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 前沿技术 > 大数据 > 大数据系统

SSM学习

SSM学习

JDBC 测试工程
新建javaProject, 导入:数据库驱动包 mysql-connector-java-5.1.46-bin.jar

package com.zcl.test;

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

public class JdbcTest {
		
	public static void main(String[] args) {

		//链接对象
		Connection con = null;
		
		//查询对象
		PreparedStatement ps = null;
		
		//结果集对象
		ResultSet rs = null;
		
		try {
			//加载数据库驱动
			Class.forName("com.mysql.jdbc.Driver");
			
			//获取连接
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ssm_mybatis?useUnicode=true&characterEncoding=utf-8&useSSL=false", "root", "123");
			
			String sql = "SELECt * FROM user WHERe u_sex = ?";
			//获取statement
			ps = con.prepareStatement(sql );
			ps.setString(1, "0");
			
			//查询 输出结果
			rs = ps.executeQuery();
			while(rs.next()) {
				System.out.println(rs.getString("u_id") + "   " + rs.getString("u_username") +"   " + rs.getString("u_sex"));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			if(rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			
			if(ps != null) {
				try {
					ps.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			
			if(con != null) {
				try {
					con.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
		
		
		
	}
}

Mybatis测试工程:
新建javaProject, 导入:
数据库驱动包: mysql-connector-java-5.1.46-bin.jar ojdbc7.jar
mybatis包: mybatis-3.4.6.jar
依赖包:

创建javaBean对象

User

package com.sikiedu.bean;

import java.util.Date;

public class User {

	
	
	private Integer u_id;
	private String u_username;
	private String u_password;
	private String u_sex;
	private Date u_createTime;
	private Integer u_cid;
	
	public Integer getU_id() {
		return u_id;
	}
	public void setU_id(Integer u_id) {
		this.u_id = u_id;
	}
	public String getU_username() {
		return u_username;
	}
	public void setU_username(String u_username) {
		this.u_username = u_username;
	}
	public String getU_password() {
		return u_password;
	}
	public void setU_password(String u_password) {
		this.u_password = u_password;
	}
	public String getU_sex() {
		return u_sex;
	}
	public void setU_sex(String u_sex) {
		this.u_sex = u_sex;
	}
	public Date getU_createTime() {
		return u_createTime;
	}
	public void setU_createTime(Date u_createTime) {
		this.u_createTime = u_createTime;
	}
	public Integer getU_cid() {
		return u_cid;
	}
	public void setU_cid(Integer u_cid) {
		this.u_cid = u_cid;
	}
	@Override
	public String toString() {
		return "User [u_id=" + u_id + ", u_username=" + u_username + ", u_password=" + u_password + ", u_sex=" + u_sex
				+ ", u_createTime=" + u_createTime + ", u_cid=" + u_cid + "]";
	}
}



创建主配置文件

sqlMapCOnfig.xml



  

	
	
	
	
	
		
		
	
	
 
  
    
    
      
      
      
        
        
        
        
      
    
  
  
  
  
   	
   	
   	
   	
   	
   	
  

创建UserMapper配置文件




	
	
		 select * from user where u_id = #{id}