c ibatis mysql实例_[Java教程]java程序中的ibatis连接mySql的基本实例

[Java教程]java程序中的ibatis连接mySql的基本实例

0 2015-03-16 00:01:32

属性文件:SqlMap.properties1 driver=com.mysql.jdbc.Driver2 url=jdbc:mysql://localhost:3306/ibatis3 username=root4 password=gys

SqlMapconfig.?> 4 5 6 7 8 9 select * from tb1_student10 11 12 select * from tb1_student where id=#id#13 14 15 16 select name,birth,score from tb1_student where name like '%$name$%'17 18 19 insert into tb1_student (name,birth,score) values (#name#,#birth#,#score#)20 21 select @@identity as inserted22 23 24 25 delete from tb1_student where id=#id#26 27 28 update tb1_student set name=#name#,birth=#birth#,score=#score# where id=#id#29 30

Student.java1 package com.iflytek.entity; 2 3 import java.sql.Date; 4 5 public class Student { 6 private int id; 7 private String name; 8 private Date birth; 9 private float score;10 11 public Student(){}12 13 public int getId() {14 return id;15 }16 public void setId(int id) {17 this.id = id;18 }19 public String getName() {20 return name;21 }22 public void setName(String name) {23 this.name = name;24 }25 public Date getBirth() {26 return birth;27 }28 public void setBirth(Date birth) {29 this.birth = birth;30 }31 public float getScore() {32 return score;33 }34 public void setScore(float score) {35 this.score = score;36 }37 @Override38 public String toString(){39 return "id="+id+"\t name"+name+"\t ajor="+birth+"\t score="+score+"\n";40 }41 42 }

IStudentDao.java1 package com.iflytek.dao; 2 3 import java.util.List; 4 5 import com.iflytek.entity.Student; 6 7 public interface IStudentDao { 8 /* 9 * 添加学生信息10 */11 public boolean addStudent(Student student);12 /*13 * 根据id删除学生信息14 */15 public boolean deleteStudentById(int id);16 /*17 * 更新学生信息18 */19 public boolean updateStudent(Student student);20 /*21 * 查询全部学生信息22 */23 public List selectAllStudent();24 25 /*26 * 根据学生姓名模糊查询学生信息27 */28 public List selectStudentByName(String name);29 /*30 * 根据学生id查询学生信息31 */32 public Student selectStudentById(int id);33 34 }

StudentDaoImpl.java1 package com.iflytek.daoimpl; 2 3 import java.io.IOException; 4 import java.io.Reader; 5 import java.sql.SQLException; 6 import java.util.List; 7 8 import com.ibatis.common.resources.Resources; 9 import com.ibatis.sqlmap.client.SqlMapClient; 10 import com.ibatis.sqlmap.client.SqlMapClientBuilder; 11 import com.iflytek.dao.IStudentDao; 12 import com.iflytek.entity.Student; 13 14 public class StudentDaoImpl implements IStudentDao { 15 private static SqlMapClient sqlMapClient = null; 16 17 // 读取配置文件 18 static { 19 try { 20 Reader reader = Resources.getResourceAsReader("com/iflytek/entity/SqlMapConfig.); 21 sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader); 22 reader.close(); 23 } catch (IOException e) { 24 e.printStackTrace(); 25 } 26 } 27 28 public boolean addStudent(Student student) { 29 Object object = null; 30 boolean flag = false; 31 try { 32 object = sqlMapClient.insert("addStudent", student); 33 System.out.println("添加学生信息的返回值:" + object); 34 } catch (SQLException e) { 35 e.printStackTrace(); 36 } 37 if (object != null) { 38 flag = true; 39 } 40 return flag; 41 } 42 43 public boolean deleteStudentById(int id) { 44 boolean flag = false; 45 Object object = null; 46 try { 47 object = sqlMapClient.delete("deleteStudentById", id); 48 System.out.println("删除学生信息的返回值:" + object + ",这里返回的是影响的函数"); 49 } catch (SQLException e) { 50 // TODO Auto-generated catch block 51 e.printStackTrace(); 52 } 53 if (object != null) { 54 flag = true; 55 } 56 return flag; 57 } 58 59 public boolean updateStudent(Student student) { 60 boolean flag = false; 61 Object object = false; 62 try { 63 object = sqlMapClient.update("updateStudent", student); 64 System.out.println("更新学生信息的返回值:" + object + ",返回影响的行数"); 65 } catch (SQLException e) { 66 e.printStackTrace(); 67 } 68 if(object!=null){ 69 flag=true; 70 } 71 return flag; 72 } 73 74 public List selectAllStudent() { 75 List students=null; 76 try { 77 students=sqlMapClient.queryForList("selectAllStudent"); 78 } catch (SQLException e) { 79 // TODO Auto-generated catch block 80 e.printStackTrace(); 81 } 82 return students; 83 } 84 85 public List selectStudentByName(String name) { 86 List students=null; 87 try { 88 students=sqlMapClient.queryForList("selectStudentByName", name); 89 } catch (SQLException e) { 90 e.printStackTrace(); 91 } 92 return students; 93 } 94 95 public Student selectStudentById(int id) { 96 Student student=null; 97 try { 98 student=(Student)sqlMapClient.queryForObject("selectStudentById",id); 99 } catch (SQLException e) { 100 e.printStackTrace();101 }102 return student;103 }104 105 }

TestIbatis.java1 package com.iflytek.test; 2 3 import java.sql.Date; 4 import java.util.List; 5 6 import com.iflytek.daoimpl.StudentDaoImpl; 7 import com.iflytek.entity.Student; 8 9 public class TestIbatis {10 public static void main(String[] args) {11 StudentDaoImpl studentDaoImpl=new StudentDaoImpl();12 13 //测试插入14 Student addStudent=new Student();15 addStudent.setName("李四");16 addStudent.setBirth(Date.valueOf("2011-09-02"));17 addStudent.setScore(88);18 System.out.println(studentDaoImpl.addStudent(addStudent)); 19 20 addStudent.setName("李四2");21 addStudent.setBirth(Date.valueOf("1990-09-02"));22 addStudent.setScore(98);23 System.out.println(studentDaoImpl.addStudent(addStudent));24 //根据Id查询25 System.out.println(studentDaoImpl.selectStudentById(2));26 27 //根据姓名查询28 List list=studentDaoImpl.selectStudentByName("四");29 for(Student student:list){30 System.out.println(student);31 }32 33 //查询所有34 List list=studentDaoImpl.selectAllStudent();35 for(Student student:list){36 System.out.println(student);37 }38 39 //更新信息40 Student updateStudent=new Student();41 updateStudent.setId(1);42 updateStudent.setName("李四1+");43 updateStudent.setBirth(Date.valueOf("1990-09-07"));44 updateStudent.setScore(24);45 System.out.println(studentDaoImpl.updateStudent(updateStudent));46 47 //删除数据48 Boolean b=studentDaoImpl.deleteStudentById(1);49 System.out.println("删除结果:"+b);50 51 } 52 }

本文网址：http://www.shaoqun.com/a/112243.html

*特别声明：以上内容来自于网络收集，著作权属原作者所有，如有侵权，请联系我们：admin@shaoqun.com。

JAVA

0