package filmsDao;
import addHibernateFile.HibernateSessionFactory;
import PO.Stuinfo;
import java.util.List;
import javax.swing.JOptionPane;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
public class StudentDao {
private Transaction transaction;
private Session session;
private Query query;
public StudentDao(){
}
//添加电影
public boolean saveInfo(Stuinfo info){
try{
session=HibernateSessionFactory.getSession();
transaction=session.beginTransaction();
session.save(info);
transaction.commit();
session.close();
return true;
}catch(Exception e){
message("saveInfo.error:"+e);
e.printStackTrace();
return false;
}
}
//通过电影名修改信息
public List findInfo(String type,Object value){
session=HibernateSessionFactory.getSession();
try{
transaction=session.beginTransaction();
String queryString="from Stuinfo as model where model."+type+"=?";
query=session.createQuery(queryString);
query.setParameter(0, value);
List list=query.list();
transaction.commit();
session.close();
return list;
}catch(Exception e){
message("findInfo.error:"+e);
e.printStackTrace();
return null;
}
}
//浏览电影信息
public List findAllInfo(){
session=HibernateSessionFactory.getSession();
try{
transaction=session.beginTransaction();
String queryString="from Stuinfo";
query=session.createQuery(queryString);
List list=query.list();
transaction.commit();
session.close();
return list;
}catch(Exception e){
message("findInfo.error:"+e);
e.printStackTrace();
return null;
}
}
//删除电影
public boolean deleteInfo(String id){
try{
session=HibernateSessionFactory.getSession();
transaction=session.beginTransaction();
Stuinfo info=new Stuinfo();
info=(Stuinfo)session.get(Stuinfo.class, id);
session.delete(info);
transaction.commit();
session.close();
return true;
}catch(Exception e){
message("deleteInfo.error:"+e);
e.printStackTrace();
return false;
}
}
//修改电影信息
public boolean updateInfo(Stuinfo info){
try{
session=HibernateSessionFactory.getSession();
transaction=session.beginTransaction();
session.update(info);
transaction.commit();
session.close();
return true;
}catch(Exception e){
message("updateInfo.error:"+e);
e.printStackTrace();
return false;
}
}
public void message(String mess){
int type=JOptionPane.YES_NO_OPTION;
String title="提示信息";
JOptionPane.showMessageDialog(null, mess, title, type);
}
}
软件工程专业 实训写的电影后台管理系统 有sql文件 （148个子文件） 
StudentDao.class 3KB RegisterAction.class 3KB LoginRegisterInfo.class 3KB UpdateMessageAction.class 2KB AddMessageAction.class 2KB uploadAction.class 2KB HibernateSessionFactory.class 2KB addNews.class 2KB NewsDao.class 2KB updateNews.class 2KB LoginAction.class 2KB FindMessageAction.class 2KB Stuinfo.class 1KB LookMessageAction.class 1KB NewsInfoPO.class 1KB DeleteMessageAction.class 1KB lookNews.class 1KB deleteNews.class 1KB UserInfoPO.class 910B uploadDao.class 272B .classpath 3KB org.eclipse.wst.common.component 467B base.css 5KB main.css 2KB login.css 2KB login.css 1KB menu.css 1003B addFilm.css 135B
ehcache-2.10.3.jar 8.5MB hibernate-core-5.2.12.Final.jar 6.37MB mysql-connector-java-8.0.20.jar 2.28MB struts2-core-2.5.10.1.jar 1.52MB freemarker-2.3.23.jar 1.29MB jaxb-impl-2.3.0.jar 941KB javassist-3.20.0-GA.jar 733KB mchange-commons-java-0.2.11.jar 592KB c3p0-0.9.5.2.jar 486KB antlr-2.7.7.jar 435KB commons-lang3-3.4.jar 424KB dom4j-1.6.1.jar 307KB jaxb-core-2.3.0.jar 250KB ognl-3.1.12.jar 230KB log4j-api-2.7.jar 214KB jandex-2.0.3.Final.jar 182KB commons-io-2.4.jar 181KB hibernate-ehcache-5.2.12.Final.jar 138KB jaxb-api-2.3.0.jar 123KB hibernate-jpa-2.1-api-1.0.0.Final.jar 111KB javax.activation-1.2.0.jar 76KB struts2-json-plugin-2.5.10.1.jar 75KB hibernate-commons-annotations-5.0.1.Final.jar 74KB commons-fileupload-1.3.2.jar 69KB jboss-logging-3.3.0.Final.jar 65KB classmate-1.3.0.jar 63KB slf4j-api-1.7.7.jar 29KB jboss-transaction-api_1.2_spec-1.0.1.Final.jar 28KB hibernate-c3p0-5.2.12.Final.jar 11KB StudentDao.java 3KB uploadAction.java 2KB RegisterAction.java 2KB HibernateSessionFactory.java 2KB LoginRegisterInfo.java 2KB NewsDao.java 2KB LoginAction.java 2KB AddMessageAction.java 2KB UpdateMessageAction.java 2KB addNews.java 2KB updateNews.java 1KB FindMessageAction.java 1KB Stuinfo.java 885B NewsInfoPO.java 810B DeleteMessageAction.java 793B lookNews.java 740B deleteNews.java 727B LookMessageAction.java 704B UserInfoPO.java 641B uploadDao.java 53B
in2.jpg 1.67MB in2.jpg 1.67MB hotel.jpg 1MB hotel.jpg 1MB light.jpg 1007KB inner2.jpg 705KB inner2.jpg 705KB 3.jpg 690KB in.jpg 482KB in.jpg 482KB inner.jpg 388KB inner.jpg 388KB dark2.jpg 336KB main.jpg 210KB dark.jpg 210KB 6.jpg 197KB bg.jpg 186KB lan.jpg 158KB lv.jpg 97KB 4.jpg 19KB 4.jpg 19KB 31.jpg 18KB 38.jpg 18KB共 148 条
- 1
- 2
- 1
- 2
前往页