jbdc编程示例

为什么80%的码农都做不了架构师？>>>   

首先,编写实体类:

/** 
 * @author FGW 
 */

package hla.entity;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.Id;

 

@Entity

public class Trapsn {

     private String tra_PsnCode;

    private String tra_PsnName;

    private String tra_PsnPass;

    @Id @Column(name = "tra_PsnCode")

    public String getTraPsnCode() {

         return tra_PsnCode;

    }

    public void setTraPsnCode(String traPsnCode) {

        this.tra_PsnCode = traPsnCode;

     }

    @Column(name = "tra_PsnName")

     public String getTraPsnName() {

         return tra_PsnName;

     }

    public void setTraPsnName(String traPsnName) {

        this.tra_PsnName = traPsnName;

    }

    @Column(name = "tra_PsnPass")

     public String getTraPsnPass() {

        return tra_PsnPass;

    }

    public void setTraPsnPass(String traPsnPass) {

        this.tra_PsnPass = traPsnPass;

    }

}

然后,创建对应的rowMapper:

public class TraPsnRowMapper implements RowMapper<Trapsn> {

    @Override
    public Trapsn mapRow(ResultSet rs, int index) throws SQLException {
        Trapsn trapsn = new Trapsn();
        trapsn.setTraPsnCode(rs.getString("tra_PsnCode"));
        trapsn.setTraPsnName(rs.getString("tra_PsnName"));
        trapsn.setTraPsnPass(rs.getString("tra_PsnPass"));
        return trapsn;
    }

}

然后,就可以自需要的地方编写自己的逻辑代码:

下面是编写了一个注册的方法供前台使用:

public class Login {


    private JdbcTemplate jdbcTemplate;
    
    public void setDataSource(DataSource dataSource) {

        //这里注入一个dataSource,在spring中配置
        this.jdbcTemplate = new JdbcTemplate(dataSource);

    }

public String register(Map params) {

    List trapsns = (List)jdbcTemplate.query("select * from trapsn", new TraPsnRowMapper());

    for(Trapsn trapsn : trapsns) {

        if(trapsn.getTraPsnCode().equals(params.get("psnCode"))) {

             return "用户编码重复!";

         }

    }

    if(!params.get("password").equals(params.get("confirmPass"))) {

         return "两次密码不一致!";

    }

    jdbcTemplate.update("insert into trapsn(tra_psncode,tra_psnname,tra_psnpass) values(?,?,?)",

        new Object[]{params.get("psnCode"), params.get("psnName"), params.get("password")},

         new int[]{java.sql.Types.VARCHAR, java.sql.Types.VARCHAR, java.sql.Types.VARCHAR});

    return "注册成功!";

    }

    }

需要注意的是update方法的参数和类型一定要对应.

转载于:https://my.oschina.net/kkdo/blog/724052