storedb.java

来自「用java编写的c/s结构的网络社区」· Java 代码 · 共 37 行

package client;
import java.sql.*;




public class Storedb extends database
{
	Storedb(String strDBName, String id, String pw)
	{
		super(strDBName, id, pw);
	}
	void QueryData(String strName)
	{
		String strQuery="Select * from 商品 WHERE 商品名称='"+strName+"'";
		try {
			rs=sql.executeQuery(strQuery);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	boolean next() throws SQLException
	{
		return rs.next();
	}
	int getInt(String columnName) throws SQLException
	{
		return rs.getInt(columnName);
	}
	void updatedata(String columnName,Object x) throws SQLException
	{
		    rs.absolute(1);   
			rs.updateObject(columnName,x);
			rs.updateRow();
		
	}
}