如何在action中直接写sql查询

我的项目是springMVC的项目，因为功能简单，就没有写底层代码，想直接在controller中写sql查询，请教大神该怎么写？？

难道功能简单你就不用写jdbc了吗

string sql= “select。。。”，connection连数据库
preparedstatement 接sql 传sql 直接硬编码查

用jdbc 连接数据库 然后在action里面直接写sql 在执行

 public class testsql {
    private final static String driver=DBconfig.getDriver();
    private final static String url=DBconfig.getUrl();
    private final static String user=DBconfig.getUser();
    private final static String password=DBconfig.getPassword();
    static Connection con=null;
    static Statement stmt=null;

    public static Statement createconnect() {
        try {
            Class.forName(driver);
            con=(Connection)DriverManager.getConnection(url, user, password);
            stmt=(Statement)con.createStatement();
            System.out.println("connect success");          
            return stmt;
        }
        catch (Exception e) {
            System.out.println(e);
            System.out.println("connect failed");
            // TODO: handle exception
            return null;
        }


    }       

}

 //注册用户
    @RequestMapping("/ajax/insertuser")
    @ResponseBody
    public Result insert(User user) {
        sqlcommend sqlcommend = new sqlcommend();
        sqlcommend.setName(user.getName());
        sqlcommend.setPassword(user.getPassword());
        Statement stmt = testsql.createconnect();
        String query = sqlcommend.insertC();
        Result dataresult = new Result();
        boolean userExit = false;
        try {
            stmt.execute(query);
            userExit = true;
            dataresult.setDataExit(userExit);
        }
        catch (SQLException e) {
            e.printStackTrace();
        }

        return dataresult;
    }

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html");
PrintWriter out = response.getWriter();

    String pid=request.getParameter("pid");
    String pname=request.getParameter("pname");
    String a=request.getParameter("date");
    String ptid=request.getParameter("ptid");
    String poid=request.getParameter("poid");

     SimpleDateFormat sdf=new  SimpleDateFormat("yyyy-MM-dd");
     java.sql.Date date = java.sql.Date.valueOf(a);


    BaseDao bd=new BaseDao();
    String sql="insert into petinfo values(?,?,?,?,?)";
    Object[] objs=new Object[5];
    objs[0]=pid;
    objs[1]=pname;
    objs[2]=date;
    objs[3]=ptid;
    objs[4]=poid;
    bd.write(sql, objs);

    response.sendRedirect("cxsycw");
}


public void init() throws ServletException {
    // Put your code here
}
public zengjia2() {
    super();
}

建议还是放在其他层中，后面要是扩展的话，会比较方便,如果不扩展的话，倒是无所谓.