maintest.java

Struts+Spring+Hibernate 增删改查

package com.yumeng.ssidemo.test;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.yumeng.ssidemo.po.Student;

public class MainTest {

	SqlMapClient sqlMapClient = null;

	public MainTest() {

		try {
			/*
			 * FileInputStream in = new FileInputStream(
			 * "E:/work/WorkPlace/SSIDemo/WebRoot/WEB-INF/sql-map-config.xml");
			 * sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(in);
			 * /*String resource ="/WebRoot/WEB-INF/sql-map-config.xml";
			 */
			/**
			 * 这里的sql-map-config.xml必须得放到src下面
			 */
			Reader reader = Resources
					.getResourceAsReader("sql-map-config.xml");
			sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
		} catch (IOException e) {
			e.printStackTrace();
		}

	}

	public void insertStudent() {
		Student student = new Student();
		student.setName("mm");
		student.setSex("女");
		student.setAge(20);
		student.setNationality("汉族");
		student.setAddress("中国湖北武汉");
		student.setPhonenumber(65200293);
		try {
			sqlMapClient.insert("insertStudent", student);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public static void main(String args[]) {
		MainTest test = new MainTest();
		test.insertStudent();

	}

}