savemodify.java

来自「JAVA图书管理软件源码,是我师兄亲自参与编的毕业设计」· Java 代码 · 共 64 行

package com.ivan.borrowManage;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import com.ivan.db.Database;

public class SaveModify 
{

	public static boolean save(Vector<String> v)
	{
		String readerClass=v.get(0);
		String maxBorrow=v.get(1);
		String maxday=v.get(2);
		String addday=v.get(3);
		String eachDayMoney=v.get(4);
		
		String sql="update rule set maxborrow='"+maxBorrow+"',Maxday='"+maxday+"'," +
				    "addDay='"+addday+"',eachDayMoney='"+eachDayMoney+"' "+
				    "where readerClass='" +readerClass+"'";
		Connection connection;		
		connection = Database.getConnection();            //建立数据库连接
		Statement stmt=null;
		
		try 
		{
			stmt= connection.createStatement();
			stmt.executeUpdate(sql);
			return true;
		} 
		catch (SQLException e) 
		{
			try 
			{
				connection.rollback();
			} 
			catch (SQLException e1)
			{
				
				e1.printStackTrace();
			}
			e.printStackTrace();
		}
		
		finally
		{
			try 
			{
				connection.close();
			} 
			catch (SQLException e)
			{
				
				e.printStackTrace();
			}
		}
		
		return false;
	}
}