java增刪改
public void save(AnswerInfo transientInstance) {
log.debug("saving AnswerInfo instance");
try {
getHibernateTemplate().save(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}
public void delete(AnswerInfo persistentInstance) {
log.debug("deleting AnswerInfo instance");
try {
getHibernateTemplate().delete(persistentInstance);
log.debug("delete successful");
} catch (RuntimeException re) {
log.error("delete failed", re);
throw re;
}
}
public AnswerInfo findById(java.lang.Integer id) {
log.debug("getting AnswerInfo instance with id: " + id);
try {
AnswerInfo instance = (AnswerInfo) getHibernateTemplate().get(
"com.wj.po.AnswerInfo", id);
return instance;
} catch (RuntimeException re) {
log.error("get failed", re);
throw re;
}
}
public List findByExample(AnswerInfo instance) {
log.debug("finding AnswerInfo instance by example");
try {
List results = getHibernateTemplate().findByExample(instance);
log.debug("find by example successful, result size: "
+ results.size());
return results;
} catch (RuntimeException re) {
log.error("find by example failed", re);
throw re;
}
}
public List findByProperty(String propertyName, Object value) {
log.debug("finding AnswerInfo instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from AnswerInfo as model where model."
+ propertyName + "= ?";
return getHibernateTemplate().find(queryString, value);
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
public List findByDoctorname(Object doctorname) {
return findByProperty(DOCTORNAME, doctorname);
}
public List findByContent(Object content) {
return findByProperty(CONTENT, content);
}
public List findByAnswerTimes(Object answerTimes) {
return findByProperty(ANSWER_TIMES, answerTimes);
}
public List findAll() {
log.debug("finding all AnswerInfo instances");
try {
String queryString = "from AnswerInfo";
return getHibernateTemplate().find(queryString);
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}
public AnswerInfo merge(AnswerInfo detachedInstance) {
log.debug("merging AnswerInfo instance");
try {
AnswerInfo result = (AnswerInfo) getHibernateTemplate().merge(
detachedInstance);
log.debug("merge successful");
return result;
} catch (RuntimeException re) {
log.error("merge failed", re);
throw re;
}
}
public void attachDirty(AnswerInfo instance) {
log.debug("attaching dirty AnswerInfo instance");
try {
getHibernateTemplate().saveOrUpdate(instance);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
}
public void attachClean(AnswerInfo instance) {
log.debug("attaching clean AnswerInfo instance");
try {
getHibernateTemplate().lock(instance, LockMode.NONE);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
}
public static AnswerInfoDAO getFromApplicationContext(ApplicationContext ctx) {
return (AnswerInfoDAO) ctx.getBean("AnswerInfoDAO");
}
}
Ⅱ java用介面實現增刪改查
// 定義介面 public interface SyUsersService {
/***新增用戶*/
public void addSyUser(SyUsers syUsers);
/***根據用戶名得到用的注冊信息***/
public SyLeaguer isRightPasswordProtect(SyLeaguer syLeaguer);
/***更新用戶的密碼***/
public void updateSyUserPassword(SyUsers syUsers);
/***用戶登錄驗證***/
public boolean checkSyUserLogin(SyUsers syUsers);
/**
* 更新用戶狀態 * @param loginName 登錄名 * @param state 狀態號 0/1
* @return 是否更新成功 true/flase
*/
public boolean updateSyUserState(String loginName,Integer state);
/**
* 分頁查詢用戶信息
* @param pageNo 頁號
* @param pageSize 頁面大小
* @param hqlQueryRule 查詢規則
* @return Page 分頁查詢對象
*/
public Page querySyUserPage(int pageNo,int pageSize,HqlQueryRule hqlQueryRule);
/**
* 更新用戶密碼
* @param loginName 登錄名 * @param oldPassword 舊的密碼
* @param newPassword 新的密碼
*/
public void updateSyUserPassword(String loginName,String oldPassword,String newPassword);
/**
* 根據查詢規則查詢用戶
* @see HqlQueryRule
* @param hqlQueryRule 查詢規則
* @return 結果集列表 */
public List querySyUser(HqlQueryRule hqlQueryRule);
/**
* 根據登錄名獲取用戶信息 * @param loginName
* @return
*/
public SyUsers getSyUserByLoginName(String loginName);
/**
* 根據登錄名獲取用戶信息
* @param loginName
* @return
*/
public boolean isRepeatUser(String loginName);
/**
* 更新用戶
* @param loginName
* @return
*/
public void updateSyUsers(SyUsers syUsers);
}
// 實現介面 public class SyUsersServiceImp extends
org.springframework.orm.hibernate3.support.HibernateDaoSupport
implements SyUsersService {
protected static final Log logger = LogFactory.getLog(SyUsersServiceImp.class); public SyUsersServiceImp() {}
/***用戶注冊添加用戶***/
public void addSyUser(SyUsers syUsers) {
this.getHibernateTemplate().save(syUsers);
Set babySet=syUsers.getSyLeaguer().getSyLeaguerBabies();
if(babySet!=null&&babySet.size()>0){
SyLeaguerBaby baby=(SyLeaguerBaby)babySet.iterator().next();
this.getHibernateTemplate().save(baby);
}
}
/***用戶登錄***/
public boolean checkSyUserLogin(SyUsers syUsers){
String querySQL = "FROM SyUsers WHERE loginName=:username and loginPassword=:password and state=:state and isEmp=:isemp";
Query query = this.getSession().createQuery(querySQL);
query.setString("username", syUsers.getLoginName());
query.setString("password", syUsers.getLoginPassword());
query.setInteger("state", 1);
query.setInteger("isemp", 0);
List list = (List)query.list();
return list.size()>0?true:false;
}
/***密碼找回得到注冊密保信息***/
public SyLeaguer isRightPasswordProtect(SyLeaguer syLeaguer){
String querySQL = "FROM SyLeaguer WHERE loginName=:loginname";
Query query = this.getSession().createQuery(querySQL);
query.setString("loginname", syLeaguer.getLoginName());
return (SyLeaguer)query.uniqueResult();
}
public void updateSyUserPassword(String loginName,String newPassword){
} public Page querySyUserPage(int pageNo, int pageSize,
HqlQueryRule hqlQueryRule) {
// TODO Auto-generated method stub
// Criteria c=this.getSession().createCriteria(SyUsers.class);
// for(int i=0;restrictList!=null&&i<restrictList.size();i++){
// c=c.add((Criterion) restrictList.get(i));
// }
// for(int i=0;orderList!=null&&i<orderList.size();i++){
// c=c.addOrder((Order) orderList.get(i));
// }
// c.setFirstResult((int)page.getStart());
// c.setMaxResults(page.getPageSize());
// List resultList=c.list();
//HqlQueryRule hqr=new HqlQueryRule();
//hqr.addEqual("id", new Integer(1234));
Page p = new Page();
Page page = null;
String queryPageHQL = "select new map( su.loginName as loginName, su.loginPassword as loginPassword,su.isEmp as isEmp) from SY_RES su where 1=1";
String countHQL = "select count(*) from SyUsers where 1=1 ";// 總記錄數
queryPageHQL=queryPageHQL+hqlQueryRule.getHql();
Query query = this.getSession().createQuery(queryPageHQL);
List list = query.list();
PageTool pt=new PageTool(page);
page=pt.getHQLQueryPage(this.getSession(), queryPageHQL,countHQL, null);
return page;
} public boolean updateSyUserState(String loginName, Integer state) {
// TODO Auto-generated method stub
return false;
} public List querySyUser(HqlQueryRule hqlQueryRule) {
// TODO Auto-generated method stub
return null;
} public void updateSyUserPassword(String loginName, String oldPassword,
String newPassword) {
// TODO Auto-generated method stub
} public SyUsers getSyUserByLoginName(String loginName) {
return (SyUsers)this.getSession().get(SyUsers.class, loginName);
}
/***用戶名是否重復***/
public boolean isRepeatUser(String loginName){
String querySQL = "FROM SyUsers WHERE loginName=:username";
Query query = this.getSession().createQuery(querySQL);
query.setString("username", loginName);
List list = (List)query.list();
return list.size()>0?true:false;
}
public void updateSyUserPassword(SyUsers syUsers){
this.getSession().update(syUsers);
}
public void updateSyUsers(SyUsers syUsers){
this.getSession().update(syUsers);
}
}
公司的項目的一段
Ⅲ JAVA增刪改查
array[index].setNumber("T108");
array[index].setName("何八");
array[index].setAge(0);
這三句應該放在for外面的吧。
功能四(len按照你的程序表示的是總數加1）：
public void delete(Employee array[],int len,int index){
for(int i=index;i<len-1;i++)
{
array[i].setNumber(array[i+1].getNumber());
array[i].setName(array[i+1].getName());
array[i].setAge(array[i+1].getAge()); }
array[len-1].setNumber(null);
array[len-1].setName(null);
array[len-1].setAge(0);
len--;
}
Ⅳ java 增刪改查
判斷成功還是失敗，看你方法返回的值一般用int來判斷受到音響的行數，判斷數字決定是否成功！
進入下一步操作！
Ⅳ java增刪改查功能怎麼實現
你所說的增刪改查是資料庫的命令操作。在Java編程中，在Java和資料庫完成連接以後，可以調用資料庫的select、delete、updata等命令。你也可以把相關的命令變成一個字元串對象，這樣調用起來會更簡單。
Ⅵ java 程序 增刪改查
class NewAction implements ActionListener{
String url="jdbc:odbc:s";
String user="sa";
String passwd="";
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(e.getSource()==jb){
Find();
}
else if(e.getSource()==jb1){
Write();
JOptionPane.showMessageDialog(null, "添加成功");
}
else if(e.getSource()==jb3){
Del();
JOptionPane.showMessageDialog(null, "刪除成功");
}
else if(e.getSource()==jb4){
Update();
JOptionPane.showMessageDialog(null, "修改成功");
}
else if(e.getSource()==jb5){
Build();
}
}
public void Find(){
boolean f=false;
String lk="select * from std";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection con= DriverManager.getConnection(url,user,passwd);
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery(lk);
while(rs.next()){
String p=rs.getString(1);
f=(jf13.getText().trim()).equals(p.trim());
if(f){
jf1.setText(p);
jf1.setEditable(false);
jf2.setText(rs.getString(2));
jf2.setEditable(false);
jf3.setText(rs.getString(3));
jf3.setEditable(false);
jf4.setText(rs.getString(4));
jf4.setEditable(false);
jf5.setText(rs.getString(5));
jf5.setEditable(false);
jf6.setText(rs.getString(6));
jf6.setEditable(false);
jf7.setText(rs.getString(7));
jf7.setEditable(false);
jf8.setText(rs.getString(8));
jf8.setEditable(false);
jf9.setText(rs.getString(9));
jf9.setEditable(false);
jf10.setText(rs.getString(10));
jf10.setEditable(false);
jta.setText(rs.getString(11));
jta.setEditable(false);
jf12.setText(rs.getString(12));
jf12.setEditable(false);
jf13.setText(rs.getString(13));
jf13.setEditable(false);
}
}
if(!f){
JOptionPane.showMessageDialog(null,"此人不存在！");
}
rs.close();
sql.close();
con.close();
}catch(SQLException p){}
catch(Exception d){}
}
public void Write(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection con= DriverManager.getConnection(url,user,passwd);
PreparedStatement sql=con.prepareStatement("insert into std values(?,?,?,?,?,?,?,?,?,?,?,?)");
sql.setString(1,jf1.getText());
sql.setString(2, jf2.getText());
sql.setString(3,jf3.getText());
sql.setString(4, jf4.getText());
sql.setString(5, jf5.getText());
sql.setString(6, jf6.getText());
sql.setString(7, jf7.getText());
sql.setString(8, jf8.getText());
sql.setString(9, jf9.getText());
sql.setString(10, jf10.getText());
sql.setString(11, jta.getText());
sql.setString(12, jf12.getText());
sql.executeUpdate();
con.close();
sql.close();
}catch(Exception p){
p.printStackTrace();
}
}
public void Del(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection con= DriverManager.getConnection(url,user,passwd);
PreparedStatement sql=con.prepareStatement("delete from std where 姓名=?");
sql.setString(1, jf13.getText());
sql.executeUpdate();
sql.close();
con.close();
}catch(Exception p){
p.printStackTrace();
}
}
public void Update(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection con= DriverManager.getConnection(url,user,passwd);
PreparedStatement sql=con.prepareStatement("update std set 姓名=?,班級=?,性別=?,宿舍=?,出生年月=?,行動電話=?,民族=?,電子郵件=?,籍貫=?,備注=?,家庭詳細住址=?,郵政編碼=? where 姓名=?");
sql.setString(1,jf1.getText());
sql.setString(2, jf2.getText());
sql.setString(3,jf3.getText());
sql.setString(4, jf4.getText());
sql.setString(5, jf5.getText());
sql.setString(6, jf6.getText());
sql.setString(7, jf7.getText());
sql.setString(8, jf8.getText());
sql.setString(9, jf9.getText());
sql.setString(10, jf10.getText());
sql.setString(11, jta.getText());
sql.setString(12, jf12.getText());
sql.setString(13, jf13.getText());
sql.executeUpdate();
con.close();
sql.close();
}catch(Exception p){
p.printStackTrace();
}
}
}這是我以前寫的 修改表對應的列項 就好了
Ⅶ JAVA增刪改查的介面怎麼寫
一個完整的資料庫2000的連接，加增刪改查的方法實現，
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import Bean.Bean;
public class shixian implements DAO {
public void delete(Bean bean) throws Exception {
// 刪除數據
String sql = "delete from person where name=?";
Conn conn = new Conn();
PreparedStatement pre;
try {
pre = conn.getConn().prepareStatement(sql);
pre.setString(1, bean.getName());
pre.executeUpdate();
pre.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void insert(Bean bean) throws Exception {
// 增加數據
String sql = "insert into person values(?,?)";
Conn conn = new Conn();
PreparedStatement pre = null;
try {
pre = conn.getConn().prepareStatement(sql);
pre.setString(1, bean.getName());
pre.setString(2, bean.getPassword());
pre.executeUpdate();
pre.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
public Bean select(String name) throws Exception {
// 查詢數據
String sql = "select name,password from person where name=?";
Conn conn=new Conn();
Bean bean = new Bean();
PreparedStatement pre = null;
try{
pre = conn.getConn().prepareStatement(sql);
pre.setString(1, name);
ResultSet rs = pre.executeQuery();
if (rs.next()) {
bean.setName(rs.getString(1));
bean.setPassword(rs.getString(2));
}
rs.close();
pre.close();
} catch (Exception e) {
e.printStackTrace();
}
return bean;
}
public void update(Bean bean) throws Exception {
// 修改數據
String sql = "insert into person values(?,?)";
Conn conn = new Conn();
PreparedStatement pre = null;
try {
pre = conn.getConn().prepareStatement(sql);
pre.setString(1, bean.getName());
pre.setString(1, bean.getPassword());
pre.executeUpdate();
pre.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
Ⅷ 用JAVA實現對txt文件文本增刪改查
正好今天寫了個~原來是兩個類，好吧，加一個...= =~囧
以文件的形式存儲的
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.io.Serializable;
import java.util.Arrays;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Scanner;
import java.util.Set;
public class StudentManager {
private static File DB = new File("students.db");
private static Set<Student> studentList = null;
@SuppressWarnings("unchecked")
private static void initStudentList() {
if (DB.exists()) {
FileInputStream fi = null;
ObjectInputStream oi = null;
try {
fi = new FileInputStream(DB);
oi = new ObjectInputStream(fi);
Object obj = oi.readObject();
fi.close();
oi.close();
if (obj instanceof Set)
studentList = (Set<Student>) obj;
} catch (Exception e) {
e.printStackTrace();
}
}
if (studentList == null)
studentList = new HashSet<Student>();
}
private static void save() {
if (studentList == null)
return;
if (!DB.exists())
try {
DB.createNewFile();
} catch (Exception e) {
e.printStackTrace();
}
FileOutputStream fo;
try {
fo = new FileOutputStream(DB);
ObjectOutputStream oo = new ObjectOutputStream(fo);
oo.writeObject(studentList);
fo.close();
oo.close();
} catch (Exception e) {
e.printStackTrace();
}
}
private static Student[] getStudents(int id, String name) {
HashSet<Student> rlt = new HashSet<Student>();
if (id != 0) {
for (Student s : studentList) {
if (s.id == id)
rlt.add(s);
}
} else if (name != null && !name.isEmpty()) {
for (Student s : studentList) {
if (s._name.equalsIgnoreCase(name))
rlt.add(s);
}
}
return rlt.toArray(new Student[0]);
}
static {
initStudentList();
}
static void out(Object obj){
System.out.println(obj);
}
public static void menu() {
out("Welcome to use Student Manager!\n1-search student;\t2-add student;\t3-list all students;\nothers-exit");
Scanner in = new Scanner(System.in);
Student student = null;
String input = in.nextLine();
if (input.equals("1")) {
Student[] students = new Student[0];
out("please input name/id");
String ins = in.nextLine();
if (ins.matches("\\d+"))
students = getStudents(Integer.parseInt(ins), null);
else
students = getStudents(0, ins);
if (students.length != 0) {
out(Arrays.toString(students).replaceAll(
"\\[|\\]|, ", "\n"));
if (students.length == 1)
student = students[0];
else {
out("please choose a student by id:\n");
int i = in.nextInt();
for (Student s : students) {
if (s.id == i) {
student = s;
break;
} else {
out("error");
menu();
}
}
}
out("1-set score;\t2-delete score;\t3-delete student;\tother-exit");
int input1=in.nextInt();
in.nextLine();
String course=null;
float score=0;
switch(input1){
case 1:
out("please input course");
course=in.nextLine();
out("please input score");
score = in.nextFloat();
in.nextLine();
student.setScore(course, score);
break;
case 2:
out("please input course");
course=in.nextLine();
student.removeScore(course);
break;
case 3:
student.removeFrom(studentList);
break;
}
}
else {
out("NO current record!");
}
}
if (input.equals("2")) {
out("please input id");
int id=in.nextInt();
in.nextLine();
out("please input name");
String name = in.nextLine();
out("please input class");
String cname=in.nextLine();
student=new Student(id, name, cname);
if(studentList.add(student)){
out("create success!\n");
String input2="-";
while(!input2.isEmpty()){
out("set score? \n1-yes;\t2-no");
input2=in.nextLine();
if(input2.equals("1")){
out("please input course");
String course=in.nextLine();
out("please input score");
float score = in.nextFloat();
student.setScore(course, score);
in.nextLine();
}
else break;
}
}else out("Error: id or student exists");
}
if (input.equals("3")) {
out(studentList.toString().replaceAll("\\[|\\]|, ", "\n"));
}
if(input.isEmpty())return;
save();
menu();
}
public static void main(String[] args){
menu();
}
}
class Student implements Serializable {
public String toString() {
return "id: " + id + "\tclass: " + _class + "\tname: " + _name
+ courses.toString().replaceAll("\\{|\\}|, ", "\n").replaceAll("=", ": ");
}
Student(int id, String _name, String _class) {
this.id = id;
this._class = _class;
this._name = _name;
}
private static final long serialVersionUID = 1L;
public int id = 0;
public String _name = "";
public String _class = "";
HashMap<String, Float> courses = new HashMap<String, Float>();
void setScore(String course, float score) {
courses.put(course, score);
System.out.println("set success!\n\n"+this);
}
void removeScore(String course) {
courses.remove(course);
System.out.println("delete success!\n\n"+this);
};
void removeFrom(Set<?> list) {
list.remove(this);
System.out.println("delete success!");
}
public int hashCode() {
return 31;
}
public boolean equals(Object obj) {
Student s = null;
if(obj instanceof Student){
System.out.println(1);
s=(Student)obj;
return s.id==id||(s._class.equals(_class)&&s._name.equals(_name));
}
return false;
}
}
class DaJiangYou{
DaJiangYou(){
System.out.println("I am da jiang you");
}
}
Ⅸ 怎麼才能實現增刪改查，我剛學習java，老師讓寫一個項目
你學習java，然後是說用來安卓移動端開發嗎？如果用AS或eclipse開發工具可以通過SQLite實現，也可以用第三方的。但你剛學，老老實實的寫安卓自帶的吧.
如果是javaEE寫後台，那導入一些jar包之後，根據相應的方法去實現，想必你有相關資料吧，沒有就上網網路，有網路就是這么好，多多上網查資料，比在這問好很多，這是真的
Ⅹ java求做增刪改查
增：語法：insert [into] <表名> [列名] values <列值>
例：insert into Strdents (姓名,性別,出生日期) values ('開心朋朋','男','1980/6/15')
刪：語法：delete from <表名> [where <刪除條件>]
例：delete from a where name='開心朋朋'（刪除表a中列值為開心朋朋的行）
改：語法：update <表名> set <列名=更新值> [where <更新條件>]
例：update tongxunlu set 年齡=18 where 姓名='藍色小名'
查：語法：select <列名> from <表名> [where <查詢條件表達試>] [order by <排序的列名>[asc或desc]]
例：select * from a where 姓名='藍色小名' order by id asc