Hibernate
Configuration cfg = new Configuration().configure("hibernate.cfg.xml");
SessionFactory factory = cfg.buildSessionFactory();
Session session = factory.openSession()
HQL
UUser user = new UUser();
String sql = "from UUser where UUser.userName= :name";
Query qu = session.createQuery ("from UUser where userName= :name and userCode= :password");
qu.setParameter("name", name);
qu.setParameter("password", password);
user = (UUser) qu.list().get(0);
Criteria
Criteria c=session.createCriteria(UUser.class);
* c.add(Restrictions.eq("userName",name));//eq是等于,gt是大于,lt是小于,or是或
* c.add(Restrictions.eq("userCode",password));
*
* if(c.list().size()>0){
*
* user=(UUser)c.list().get(0);
*
* }
setString():qu.setParameter("name", name); 传字符串
setParameter() 传Object:String ,integer,data...
对于一些类型就必须写明映射类型,比如java.util.Date类型,因为它会对应Hibernate的多种映射类型,
比如Hibernate.DATA或者Hibernate.TIMESTAMP。
query.setParameter(“data”,data,Hibernate.DATA);
setProperties()
Query query=session.createQuery(“from Customer c where c.name=:name and c.age=:age ”);
customer.setName(“lyp”);
customer.setAge(80);
query.setProperties(customer);
ExtJs
1.必备文件:
adapter,resources,ext-all.js,ext-all-debug.js
maximizable : true,最大化
collapsible:true,可折叠
private String[] getFiledName(Object o){
Field[] fields=o.getClass().getDeclaredFields();
String[] fieldNames=new String[fields.length];
for(int i=0;i<fields.length;i++){
System.out.println(fields[i].getType());
fieldNames[i]=fields[i].getName();
}
return fieldNames;
}
Query query = HibernateSessionFactory.getSession().createSQLQuery(sql)
.addScalar("score", Hibernate.DOUBLE)
.addScalar("gname", Hibernate.STRING)
.addScalar("cname", Hibernate.STRING);
query.setResultTransformer(Transformers.aliasToBean(Select.class));
List list = query.list();
Select[] selectList = new Select[list.size()];
for (int i = 0; i < list.size(); i++) {
Select select = (Select) list.get(i);
selectList[i] = select;
}
ajax json
1.
Gson gson = new GsonBuilder().create();
gson.toJson("Hello", System.out);
gson.toJson(123, System.out);
2.
Writer writer = new FileWriter("Output.json");
Gson gson = new GsonBuilder().create();
gson.toJson("Hello", writer);
gson.toJson(123, writer);
writer.close();
3.
//返回数据
String flag = "ok";
PrintWriter out = response.getWriter();
Gson gson = new Gson();
String flagJson = gson.toJson(flag);
out.write(flagJson);
4.JSONArray jsonArray =JSONArray.fromObject( list );
out.write(jsonArray.toString());
System.out.println(jsonArray.toString());
ajax提交from表单
$.ajax({
type: "POST",
url:"SearchInfo/QueryMoreInfo",
dataType:text,
data:$('#fm').serialize(),// 序列化表单值
async: false,
error: function(request) {
alert("Connection error");
},
success: function(data) {
window.location.href="跳转页面"
}
});
ajax获取
$(document).ready(function() {
$.ajax({
type : "GET",
url : "servlet/UserServlet",
dataType : 'json',
success : function(data) {
$.each(data, function (index, item) {
//循环获取数据
var cid = data[index].classId;
var gid = data[index].gradeId;
var name = data[index].stuName;
$("#list").html($("#list").html() + "<br>" + name + " - " + gid + " - " + cid + "<br/>");
});
}
});
});
md5加密
MessageDigest messageDigest = MessageDigest.getInstance("MD5");
String input = "abc";
// 输入的字符串转换成字节数组
byte[] inputByteArray = input.getBytes();
// inputByteArray是输入字符串转换得到的字节数组
messageDigest.update(inputByteArray);
// 转换并返回结果,也是字节数组,包含16个元素
byte[] resultByteArray = messageDigest.digest();
// 字符数组转换成字符串返回
for (byte i : resultByteArray) {
System.out.println(i);
}