borrowinit.java

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

package com.ivan.borrowManage;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.ivan.db.Database;

public class BorrowInit
{
	public static String[] init(String clss)
	{
		Connection connection;
		ResultSet rs=null;
		String[] s = new String[4];
		String sql="select * from rule where readerClass='"+clss+"';";
		
		connection = Database.getConnection();            //建立数据库连接
		Statement stmt=null;
		
		try 
		{
			stmt= connection.createStatement();
			rs=stmt.executeQuery(sql);
			
		    if(rs.next())
		     {
		    	 s[0]=rs.getString("maxBorrow");
		    	 s[1]=rs.getString("maxDay");
		    	 s[2]=rs.getString("addDay");
		    	 s[3]=rs.getString("eachDayMoney");
		    	 
		    	 return s;
		     }
		    
		} 
		catch (SQLException e) 
		{
			
			e.printStackTrace();
		}
		
		finally
		{
			try 
			{
				connection.close();
			} 
			catch (SQLException e)
			{
				
				e.printStackTrace();
			}
		}
		
		return null;
		
	}

}